John, You're welcome. I'm always happy when I can help.
-Scott >===== Original Message From [EMAIL PROTECTED] ===== >thanks Scott, Jeff, Richard for this one. >also many thanks for arup for helping out with the earlier >db shutdown problem that i had earlier. > > > >--- Jeff Herrick <[EMAIL PROTECTED]> wrote: >> >> 1) Identify the database you wish to start using an environment >> variable (good old DOS) >> >> c:\> set ORACLE_SID=SID1 >> c:\> svrmgrl >> >> You can also use LOCAL=SID1...It will override ORACLE_SID >> Both of these variables can also be set in the registry under >> HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful >> to 'hide' a remote database so that you don't have to specify >> 'connect user/passwd@remotedb' you can just 'connect user/pass' >> >> You can also set either at the System environment level using a >> right-click on My Computer / Properties / Environment using >> variable names LOCAL or ORACLE_SID >> >> It's good form to do a 'select * from V$database' after you >> connect to make sure you are working on the right database >> =8-0 >> >> 2) A database can be opened by multiple instances when it's >> configured in an OPS (Oracle Parallel Server) environment. >> Not to sound 'flip' here but I wouldn't worry about OPS until >> you get your mind around how a single instance works :) >> OPS is now known as RAC - Real Application Clusters >> >> Cheers >> >> Jeff Herrick >> >> On Sat, 30 Nov 2002, john wrote: >> >> > 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 ? >> > question: >> > if yes then next if i would start the svrmgrl and do a startup >> then >> > which instance would be started ? is there a way to give the >> > startup command to get only a particular instance started ? >> > >> > 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 >> > ? >> > can someone explain the difference between the two scenarios ? >> > >> > >> > __________________________________________________ >> > 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: Jeff Herrick >> 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). >> > > >__________________________________________________ >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).