Re: Multiple Instance in Unix

From: Amir Gheibi <>
Date: Fri, 7 Aug 2009 16:44:23 +0800
Message-ID: <>

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 <> 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: [] 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?
> Thanks.
> ~ Amir Gheibi

Received on Fri Aug 07 2009 - 03:44:23 CDT

Original text of this message