how to diagnose if the oracle goes down
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
the alert file has the startup time, the orclsmon trace file didnt show any latest error.
How to find the reason behind this..?
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 ).
Catch me online at Yahoo: ddpatel256
Re: how to diagnose if the oracle goes down
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.
Originally posted by castlerock
All of sudden my oracle database went down...while connecting to it i got the follwing error " shared memory realm exist"
Click Here to Expand Forum to Full Width