-
I have created two instance in my computer.and my operating system is Windows2000 adv server.
Old instance id is Oracle8i,new one is mydb,I want to use svrmgrl to connect the instance mydb.How do I?
Pl. give me some advise!
thanks!
[Edited by wolfshome on 03-12-2002 at 07:43 PM]
Gaga ghost
-
Set your ORA_SID and ORACLE_HOME environment variables to the instance and home you want to use.
When they're set, you'll connect to that instance and home when you run svrmgrl, sqlplus, imp, etc.
Look under "System" in your "control panel" to set environment variables.
-Ken
-
Hi,KenEwald:
Thank you very much!
But the environment variable ORACLE_SID AND ORACLE_HOME are only set in register!
Do I have to change these variables in register when I switch these two instance?
Gaga ghost
-
Hi,
You can set then at command prompt before starting the SVRMGRL.
SET ORACLE_SID=SidName
take care,
Nishant
-
Hi,my friends!
You are right!
thanks !
Gaga ghost
-
Originally posted by wolfshome
I have created two instance in my computer.and my operating system is Windows2000 adv server.
Old instance id is Oracle8i,new one is mydb,I want to use svrmgrl to connect the instance mydb.How do I?
Pl. give me some advise!
thanks!
[Edited by wolfshome on 03-12-2002 at 07:43 PM]
if possible you wanna use sqlplus /nolog instead of svrmgrl because svrmgrl is obsolete in 9i and future versions of Oracle
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
|