We have one Oracle home for all of our non-11i backend instances and one each for each of them (more for the extproc's that Dick was talking about and for ease of testing upgrades than for any other pressing reason.)
Auditors are a funny breed... they want total separation even at the expense of practicality.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~
-----Original Message-----
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 18, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Physical Design Question
Ray,
Boy are you ever. In our location every version gets an Oracle_Home. Databases that share the same version share the same home. BTW: Oracle Support recommends using the listener for the highest version installed. I do that & it works very darn well, unless your into extproc's. Then you should have an extproc listener for each version installed.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Thursday, July 17, 2003 7:29 PM
To: Multiple recipients of list ORACLE-L
my 2cents...
Every instance get it's own oracle home, user id and group id. Total isolation and separation. It
makes our auditors happy too!
Then again, I may be an extremist...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
Com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Physical Design Question
.com
07/17/2003 05:14
PM
Please respond to
ORACLE-L
Well, since nobody else has jumped on this...
-----Original Message-----
> Here's my situation:
> 1. Should I use a separate Oracle Home for each DB?
Not unless you have some peculiar situation there. Use separate ORACLE_HOME
for each version of Oracle but not each database.
> Pros: --Allows upgrade/patching of 1 DB at a
> time without affecting others (some are home-grown,
> some are 3rd party).
The separate ORACLE_HOME for each version takes care of this. You just
change the ORACLE_HOME in the oratab when you upgrade the database. If you
use environment setting scripts, have them grab the correct ORACLE_HOME from
the oratab.
something like:
export ORACLE_HOME=`/usr/bin/nawk -F: '$1 == SID {print $2}'
SID="$ORACLE_SID" "$ORATAB"`
where ORATAB is the path to your oratab file.
Sorry, I got no opinions on your storage arrangement.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author: Ron Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. |
