Server Manager question

[akhorram]

Hello all, I have a question that I cannot find the answer to. I have two 8i instances on Win 2000. When I connect to Server Manager and I want to switch between the two instances, how do I do that? For example, lets say I want to bring up both instances, so I connect internal and issue the startup open command, so the "first" instance is open. So, how do I switch to the second instance in order to start that one up? Thanks in adnvance for your help.

[vicky]

Hi,
U can switch to another instance by changing the SID,

c:\>set ORACLE_SID = second sid
c:\>svrmgrl
svrmgr>connect internal
svrmgr>startup

Regds...Vicky

[tomate]

Hello
The anwer of vicky is right but there are an secound way too
you can make this but there the tnsname.ora must have the right information.

sqlplus internal@db1
then start the database
exit;

and then
sqlplus internal@db2
then start this database
exit;

Now both db are open...


Commit;
Thomas Schmidt

[inosov]

The more comfortable (and recommended) way:

c:\> svrmgrl

SVRMGR> set instance orc1
SVRMGR> connect internal
SVRMGR> startup
SVRMGR> disconnect

SVRMGR> set instance orc2
SVRMGR> connect internal
SVRMGR> shutdown immediate
SVRMGR> disconnect

etc.