-
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.
Thanks,
Afshin.
-
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
vicky
-
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
-
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.
inosov
Brainbench MVP for Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|