RE: Multiple Instance in Unix

From: Bobak, Mark <>
Date: Fri, 7 Aug 2009 04:25:53 -0400
Message-ID: <>

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: [] On Behalf Of Amir Gheibi [] 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

-- Received on Fri Aug 07 2009 - 03:25:53 CDT

Original text of this message