Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Multiple Oracle Homes on Unix
Yes. I have had 7.3.4 and 8.1.6 databases runing together just fine.
There are two schools of thought on this.
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% recycledelectrons
--
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).
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 - 19:06:46 CDT
![]() |
![]() |