Check Database availability [message #59095] |
Tue, 28 October 2003 06:34 |
fuzzy
Messages: 2 Registered: October 2003
|
Junior Member |
|
|
How to check the status of a database with logging into it(through sqlplus etc). I want to check when the database becomes available after the coldback up.
Thanks.
|
|
|
Re: Check Database availability [message #59096 is a reply to message #59095] |
Tue, 28 October 2003 06:35 |
fuzzy
Messages: 2 Registered: October 2003
|
Junior Member |
|
|
SORRY there was a typo in the first message.
How to check the status of a database "without" logging into it(through sqlplus etc). I want to check when the database becomes available after the coldback up.
Thanks.
|
|
|
Re: Check Database availability [message #59101 is a reply to message #59096] |
Tue, 28 October 2003 09:06 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Logging into the database is quite easy and very reliable..Why didnt you want to do that ?
checking for background process will succeed even if the database is not open ..
I usually check v$instance and interpret the o/p..
|
|
|