General discussion

Locked

Managing multiple databases

By prashantattray ·
Here is the scenario
I have 3 oracle databases on a single linux server. All installed under the same owner oracle. Each one supports a different language. I want to start all the three databases up and running at the same time. How do i do it? What parameters do i need to change? Do i need to set any environment variables? Or do i need to install it under different oracle user group? If so, then how? Any help/insight into this will be helpful.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Managing multiple databases

by dsauxier In reply to Managing multiple databas ...

You can write a shell script that will start them all.

You'll have to set your ORACLE_HOME, ORACLE_BASE and ORACLE_SID environment variables properly prior to starting each one of the 3 instances. (if they're all 3 the same database version, thenonly ORACLE_SID will change).

I haven't worked with any databases other than English, but I believe that all the NLS parameters are in the init<sid>.ora file so as far as I know, you don't need to set any additional environment variables to do this.

Collapse -

Managing multiple databases

by prashantattray In reply to Managing multiple databas ...

The question was auto-closed by TechRepublic

Collapse -

Managing multiple databases

by sundagan In reply to Managing multiple databas ...

As the other email mentions, you can set the shell script to point to different Oracle Sid's and work with the instance.

Regarding the different languages, if you are using any server side tools, the appropriate NLS environment settings should bemade. Else there is no need to worry as database takes care of everything.

Collapse -

Managing multiple databases

by prashantattray In reply to Managing multiple databas ...

The question was auto-closed by TechRepublic

Collapse -

Managing multiple databases

by maillists In reply to Managing multiple databas ...

make a shell script to start the databases, using the SID env variable. You don't have to worry about language settings. oracle handles all with no problem and the language is anyway set up at database creation time.

Sebastian

Collapse -

Managing multiple databases

by prashantattray In reply to Managing multiple databas ...

The question was auto-closed by TechRepublic

Collapse -

Managing multiple databases

by prashantattray In reply to Managing multiple databas ...

This question was auto closed due to inactivity

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums