Multiple Oracle Homes on Unix

From: Browett, Darren <dbrowett_at_city.coquitlam.bc.ca>
Date: Wed, 12 Sep 2001 15:23:02 -0700
Message-ID: <F001.0038C736.20010912153650@fatcity.com>

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). Received on Wed Sep 12 2001 - 17:23:02 CDT