RE: Unix script to check database status
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 18:04:38 -0800
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
