1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Instance is down

Discussion in 'System Administration & Application DBA' started by chester04, Feb 10, 2011.

  1. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi,

    How to check if the instance is down?
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Connect to the DB with /nolog option. and check the view v$instance.
     
  3. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    thank you very much
     
  4. janste

    janste Active Member

    Messages:
    23
    Likes Received:
    6
    Trophy Points:
    90
    Your alert.log should give you some indications as well.

    or

    #ps -ef | grep pmon (on UNIX), this will list out running oracle instances.