isolated for you mere mortals!!!!! REAL MEN STRESS NT boxes!!
-----Original Message----- Sent: Friday, July 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Tom, yours is an isolated incident, bwahhahahaha, unix still rulz joe Mercadante, Thomas F wrote: >We do it all the time. Not a problem at all. My current dev box has 17 >instances on it (a shared box among many projects). There is nothing to >prevent you from doing this. And turn-around for a development box is >reasonable. > >My production NT 4.0 box has two active Oracle instances on it - Production >and Training. Running Oracle Failsafe to fail both instances over when the >primary box fails. > >So naa-naa to the NT nay-sayers. > >Tom Mercadante >Oracle Certified Professional > > >-----Original Message----- >Sent: Friday, July 18, 2003 11:55 AM >To: Multiple recipients of list ORACLE-L > > >It's entirely possible to have multiple Oracle homes with multiple >databases on windoze. > >Not as slick as unix, but it works. > >Jared > > > > > > >"Gene Sais" <[EMAIL PROTECTED]> >Sent by: [EMAIL PROTECTED] > 07/18/2003 06:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: RE: Physical Design Question > > >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). > > > > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: Mercadante, Thomas F 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).