Home » RDBMS Server » Server Administration » Check Database availability
Check Database availability [message #59095] Tue, 28 October 2003 06:34 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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..
Previous Topic: ORA-00020 maximum number of processes (150) exceeded
Next Topic: oracle temporary tablespace in 8i
Goto Forum:
  


Current Time: Fri Sep 20 08:23:08 CDT 2024