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

Thread: Shutdown

  1. 10-01-2002, 03:13 PM #1
    Rajkartha
    Rajkartha is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 10-01-2002, 03:18 PM #2
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    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."
    Reply With Quote Reply With Quote
  3. 10-01-2002, 03:18 PM #3
    mike2000
    mike2000 is offline Senior Member
    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

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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