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 <jherrick_at_igs.net> 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_at_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: john_g123_9_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (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: jherrick_at_igs.net
>
> 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: ListGuru_at_fatcity.com (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: john_g123_9_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Sat Nov 30 2002 - 15:58:43 CST
