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: [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: Richard Ji
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).
