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

Thread: Shutdown

  1. #1
    Join Date
    Nov 2001
    Posts
    55

    Red face

    Hi,

    I am administering three oracle instatnces. When the command shutdown is issued how does oralce detrmine what instance of the oracle to shutdown. Please help me

    ThanX in advance

    Raj

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Raj,
    when you are in your unix shell ORACLE_SID determines which sid/instance you are connecting to...
    once connected to svrmgr you can perform select * from v$database to determine which db you are connected to.
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    which O/S are you running on??? NT or Unix

    set oracle_sid=INSTANCE_NAME on NT

    export INSTANCE_NAME on UNIX

    or you can connect as:

    INTERNAL/MANAGER@DATABASE_NAME

    good luck


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