DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Abount Svrmgrl!

  1. #1
    Join Date
    Mar 2002
    Posts
    15
    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

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    15
    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

  4. #4
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    Hi,
    You can set then at command prompt before starting the SVRMGRL.
    SET ORACLE_SID=SidName
    take care,
    Nishant

  5. #5
    Join Date
    Mar 2002
    Posts
    15
    Hi,my friends!
    You are right!

    thanks !
    Gaga ghost

  6. #6
    Join Date
    Aug 2001
    Posts
    147
    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
  •  


Click Here to Expand Forum to Full Width