RE: Multiple Oracle Homes on Unix

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 12 Sep 2001 17:06:46 -0700
Message-ID: <F001.0038C83E.20010912170519@fatcity.com>

Yes. I have had 7.3.4 and 8.1.6 databases runing together just fine.

There are two schools of thought on this.

2 seperate IDs and homes
The same ID and same home.

With the first version you setup your 2 id's (They can have the same group) and point those IDs to 2 seperate homes. Each ID will have different profiles that will setup the appropriate ORACLE_HOME, Paths, Sids, etc.

The second version is a little more complicated but was the one we used.

We used 1 id and therefore 1 home.

By default NO ORACLE VARIABLES WERE SET. This way if you did not do the next step, you could not login and screw up the DB.

Next , we create a script that setup the correct Oracle Home and Path variables when you choose it from a menu. This way, we could log into 1 ID, choose which instance we wanted to go to, and then get all the variable setup.

It worked very good.

But, if you are more of a Novice Unix person and Oracle DBA I would suggest 2 seperate homes. It eliminates the headache of creating the other environment setting script.

Kevin
-----Original Message-----
Sent: Wednesday, September 12, 2001 6:37 PM To: Multiple recipients of list ORACLE-L

Currently I have a 8.0.5 environment that was installed and configured by the previous
DBA who liked to things a certain way, not necessarily the right way, just a certain way.

I am in the process of installing 8.1.6, according to the docs I should setup a separate unix account for installing the software, which I have.

What I want to do is create a mixed environment with multiple oracle homes, currently
8.1.6 and 8.0.5, with oracle 9 coming in sometime in the future.

I am having trouble with the owner/privileges.

If I have installed 8.1.6 software as owner 'oracle' group 'dba', can I create a new unix account, 'ora816'
group 'dba' and run the software and instance/database ?.

The ora816 would issue the necessary login profile to setup its ORACLE_HOME and supporting variables.

I would create a environment for the 8.0.5 account (ora805).

I am assuming that the database files themselves would have to be created and owned by ora816 and
or ora805

Any tips,articles general info would be appreciated as Metalink doesn't quite answer the questions
I have, at least I can't find the answers.

Thanks

Darren

Darren Browett P.Eng                                    This message was
transmitted
Systems Admin/DBA                                       using 100% recycled

electrons
Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Browett, Darren
INET: dbrowett_at_city.coquitlam.bc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------