Re: instance and database

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