Re: Unix script to check database status
- From: <jtesta@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Mar 2004 15:31:52 -0500 (EST)
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.
Joe
> Hi,
>
> I have to write an HP-UX Korn shell script to check the status of 20
> databases - up or down - and send an email if any are down. I'm a
> relative newbie at Unix. I'm not asking anyone to "do it for me", but
> does anyone know of any scripts to check database status by greping or
> otherwise looking at the oratab or other file and checking the status?
>
> Thanks,
>
> Mike
>
>
> 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 //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
