Oracle-L: RE: instance and database

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Sat, 30 Nov 2002 08:23:41 -0800
Message-ID: <F001.0050F603.20021130082341@fatcity.com>

Before you get into svrmgrl, check your %ORACLE_SID% environmental variable. Whichever SID it's set to, that's the database you are going to startup/shutdown. You can do "set ORACLE_SID=NEW_SID" to change it.

Having two or more instances associated with a database is called Oracle Parallel Server (pre-9i) or Real Application Cluster (9i). You would need a cluster of minimum two nodes with a shared disk to implement it. It's possible to set up RAC on a single node under Windows or Linux.

Regards,

Richard Ji

-----Original Message-----
Sent: Saturday, November 30, 2002 9:39 AM To: Multiple recipients of list ORACLE-L

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: Richard Ji
INET: richard.ji_at_mobilespring.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------