Yes. I have had 7.3.4 and 8.1.6 databases runing together just fine.
There are two schools of thought on this.
1. 2 seperate IDs and homes
2. 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:[EMAIL PROTECTED]
----------------------------------------------------------------------------
-------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
