RE: Unix script to check database status

What if the instance can't start?

-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@xxxxxxxxx]
Sent: Thursday, March 11, 2004 4:33 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Unix script to check database status


Sure, once you have connected to the database you could get some additional
information via queries if you want. But if all you want to know is "Is the
database available to users?" then it should be sufficient to use SQL*Plus
from a client machine to connect and disconnect.

> -----Original Message-----
> Kevin Lange
> 
> Why not simply write a query that gets ran by OS that selects 
> the status and
> logins from v$instance.  You should be able to parse that 
> simple enough.
> 
> -----Original Message-----
> From: Jacques Kilchoer [mailto:Jacques.Kilchoer@xxxxxxxxx]
> 
> If you try a bogus userid/password and use the ORA-1017 as 
> "proof" that the
> database is up, you wouldn't know if the database is in 
> restricted session
> mode. (Something that has burned me before.) I personally 
> think the best way
> for verifying that the database is up is to create a session (create a
> userid that only has "create session" privilege and use that for
> verification.
> 
> > -----Original Message-----
> > testa@xxxxxxxxxx
> > 
> > Mike, make your script attempt to login into the 
> database(even with a
> > bogus userid/password),
> > 
> > you get a ORA-1017 invalid userid/password, you know the 
> > database is up
> > and you got a connection to it.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: