Re: Multiple Instance in Unix

  • From: Joey D'Antoni <jdanton1@xxxxxxxxx>
  • To: gheibia@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 7 Aug 2009 03:38:59 -0700 (PDT)


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: