Re: Multiple Instance in Unix


You should be able to run the '. oraenv' command. This will prompt you to enter 
the SID you'd like to connect to, and will check the /etc/oratab file for the 
appropriate ORACLE_HOME.

Good luck,

Joe D'Antoni
Synthes USA

From: Amir Gheibi <gheibia@xxxxxxxxx>
To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, August 7, 2009 4:44:23 AM
Subject: Re: Multiple Instance in Unix

Hi Mark,

Thanks for the swift reply. Appreciate it.

But if re-set ORACLE_SID to the new SID and keep the ORACLE_HOME, how would I 
access to the first instance? Change ORACLE_SID back to the old SID whenever is 

~ Amir

On Fri, Aug 7, 2009 at 4:25 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:

>Hi Amir,
>>This is a common practice.  There is no need to create a new OS user.  You 
>>can even create a new database under the same Oracle home.
>>The thing to keep in mind is that the combination of ORACLE_SID and 
>>ORACLE_HOME need to be unique.  So, that will uniquely identify an instance 
>>on a host, and then that instance's pfile/spfile will point to your 
>>database's control file(s).  In that way, your new instance will clearly 
>>identify which database it will mount and open.
>>Hope that helps,
>>From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
>>Of Amir Gheibi [gheibia@xxxxxxxxx]
>Sent: Friday, August 07, 2009 4:18
>>Subject: Multiple Instance in Unix
>>Hi listers,
>>I have a HP Unix box that has Oracle 10g R2 installed on it. There is already 
>>an instance running and a database attached to it.
>>I need to create another instance and database. There is no X Server 
>>installed on the OS. I created the first database through command line.
>>My question is whether I have to create another OS user in order to create 
>>the new instance? Or I can use the same OS user (oracle:dba) to create the 
>>new instance? As I need to set environment variables then if I use the same 
>>OS user, what would happen to the first instance?
>>Is there a guideline on how to do this?
>>~ Amir Gheibi


Other related posts: