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).