I must have had a different goal in mind than you do, but when I wrote my script to check on databases it would return a success/failure for each Oracle instance. A failure for a particular instance would send an e-mail saying "go see why that instance isn't up, bring it up, and check that your resume is still current." For me the fact that the instance didn't allow connections was all the information I was looking for.
> -----Original Message-----
> Michael Milligan
>
> What if the instance can't start?
>
> -----Original Message-----
> Jacques Kilchoer
>
> 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.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
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
-----------------------------------------------------------------
Received on Thu Mar 11 2004 - 20:01:44 CST
