RE: Physical Design Question

[Gene Sais]

I do the same.  One OH for each version.  Listener uses the latest OH.  Databases set env script for OH required.  Simple and it works. I couldn't imagine having 14 OH's for 14 8i databases on one server :).  Now if I were running on Windows then I would have one db per server hence one OH.  Its all relative, do what you like! Gene >>> [EMAIL PROTECTED] 07/18/03 09:19AM >>> 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).