how to diagnose if the oracle goes down
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to diagnose if the oracle goes down

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    how to diagnose if the oracle goes down

    Hi,
    All of sudden my oracle database went down...while connecting to it i got the follwing error " shared memory realm exist" I have checked the bdump folder files like
    ORCLALRT
    orclSMON.TRC

    the alert file has the startup time, the orclsmon trace file didnt show any latest error.


    How to find the reason behind this..?

    Oracle Environment:
    NT,ORACLE 9i

    Thanks,

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    You can check Alert log file, or any other trc file written at BACKGROUND_DUMP_DEST.

    You can do shutdown abort and restart the database.

    Also you can check os utility, if any error log there (in event viewer in case of NT ).

    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  3. #3
    Join Date
    May 2001
    Posts
    736

    Re: how to diagnose if the oracle goes down

    Originally posted by castlerock
    Hi,
    All of sudden my oracle database went down...while connecting to it i got the follwing error " shared memory realm exist"
    Thanks,
    ITs common error.Usually u will get this error when u are trying to connect to DB when it is down.As said by Dilip if u didn't find any error messages on ALERT.LOG then it could be OS which forces the DB down.

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