instance and database

From: john <john_g123_9_at_yahoo.com>
Date: Sat, 30 Nov 2002 06:38:38 -0800
Message-ID: <F001.0050F5AB.20021130063838@fatcity.com>

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). Received on Sat Nov 30 2002 - 08:38:38 CST