RE: Multiple Instance in Unix

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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: