Re:Multiple Oracle Homes on Unix

From: <dgoulet_at_vicr.com>
Date: Thu, 13 Sep 2001 06:39:21 -0700
Message-ID: <F001.0038D0B8.20010913061021@fatcity.com>

!! Please do not post Off Topic to this List !!

Darren,

I assume you have an account for your 8.0.5 Oracle software and hopefully the previous DBA created an 805 subdirectory off of $HOME to put $ORACLE_HOME in. If that is the case, just setup an 816 directory off $HOME for your new $ORACLE_HOME, install & have fun. Oracle's recommendation though is that you use the 816 listener for both databases. This will keep you out of the permissions problems and when your ready to migrate from 8.0 to 8i it's just a matter of moving a couple of files & migrating. Simple. All of your database files should be created and owned by the Oracle user irrespectively of where they are created from.

Dick Goulet

____________________Reply Separator____________________
Author: "Browett; Darren" <dbrowett_at_city.coquitlam.bc.ca>
Date:       9/12/2001 3:36 PM

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:
INET: dgoulet_at_vicr.com

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