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)
Amir,
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
needed?
~ 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,
>
>>-Mark
>>________________________________________
>>From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
>>Of Amir Gheibi [gheibia@xxxxxxxxx]
>>
>Sent: Friday, August 07, 2009 4:18
>>To: ORACLE-L
>>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?
>
>>Thanks.
>
>>~ Amir Gheibi
>
>
Other related posts:
