>===== Original Message From [EMAIL PROTECTED] ===== >Oracle 8i on NT4.0 > >via the Oracle Database Configuration Assistant create another >database. >ie create another database with its instance and by default the >db name and instance are same. say i proceed forward and create it. >so now the box would have 2 separate services... > OracleService<SID1> > OracleService<SID2> > >is that correct ? --> Yes this is correct.
>question: >if yes then next if i would start the svrmgrl and do a startup then >which instance would be started ? --> The default instance. >is there a way to give the startup command to get only a particular instance >started ? --> Yes, set the ORACLE_SID environment variable to the SID that you want started and just issue "startup" in svrmgrl. >Next, the docs mention that it is possible to have two or more >instance(s) associated with a given database. The above example >shows two separate database, each with its one unique database. >So how does one implement or have 2 instances for a given database >? --> I believe you have to have RAC/Parallel Server for this kind of setup. I've never had a reason to do this. Hopefully someone else who has done this before could shed more light on this topic. >can someone explain the difference between the two scenarios ? --> I can't answer this one for you. Sorry. -Scott Stefick > > >__________________________________________________ >Do you Yahoo!? >Yahoo! Mail Plus - Powerful. Affordable. Sign up now. >http://mailplus.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: john > 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.com -- Author: sstefick 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).