Re: Multiple Instance in Unix

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 7 Aug 2009 13:01:32 +0200
Message-ID: <486b2b610908070401m1e9490a9ne51277debb2ce1a1_at_mail.gmail.com>

And another thing to keep in mind. Oracle identifies the instance based on an exact text match of the ORACLE_HOME. So therefore

/opt/app/oracle/product/10.2.0/

is NOT the same like

/opt/app/oracle/product/10.2.0

As in:

oracle_at_central:~/ [CENTRAL] echo $ORACLE_HOME /oracle/database/10.2.0.1
oracle_at_central:~/ [CENTRAL] sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Aug 7 14:12:03 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

*Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options*

sys_at_CENTRAL> Disconnected from Oracle Database 10g Enterprise Edition

Release 10                                  .2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options oracle_at_central:~/ [CENTRAL] export ORACLE_HOME=${ORACLE_HOME}/ oracle_at_central:~/ [CENTRAL] echo $ORACLE_HOME /oracle/database/10.2.0.1/
oracle_at_central:~/ [CENTRAL] sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Aug 7 14:12:16 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

*Connected to an idle instance.*

idle>

If you're going to set your environments manually between homes, you'll probably run into this sooner or later.

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Fri, Aug 7, 2009 at 10:25 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>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_at_freelists.org [oracle-l-bounce_at_freelists.org] On
> Behalf Of Amir Gheibi [gheibia_at_gmail.com]
> 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
>
>
>

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

Received on Fri Aug 07 2009 - 06:01:32 CDT