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