RE: instance and database

John,

You're welcome. I'm always happy when I can help.

-Scott

>===== Original Message From ORACLE-L_at_fatcity.com =====
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sstefick
  INET: sstefick_at_harper.cc.il.us

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