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