Re: Unix script to check database status

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Tue, 9 Mar 2004 17:23:30 -0500
Message-ID: <076501c40625$26ab65a0$51a36244@ryan2le36ofjce>

ls -l | grep pmon

then cut out the database name. You will also want to attempt to log in as follows

sqlplus -s / << EOF > $TEMPFILE

select 1
from dual;
EOF
if [ ! $? -eq 0]; them

send $TEMPFILE to yourself in an email. fi
delete $TEMPFILE
You are probably going to want to start creating an architecture for this, since as time goes on you will want to add more and more stuff(such as checking the alert log, testing queries and query plans, segments and tablespace stuff as well... )

So I recommend the following

scripts to create a tempfile, delete a tempfile, and concatenate stuff into your tempfile(these are like 5 lines each).
A wrapped email script with a flag for success, failure, and warning
An email list with emails of who gets what. For example

DATABASE CHECK [1] michael_at_company.com ryan_at_company.com

Then your scripts can grep for that with the status(1 is for failure) and send the appropriate email.

>From here you can plug into your architecture. This will make your life
easier.
----- Original Message -----
From: "Michael Milligan" <Michael.Milligan_at_ingenix.com> To: <oracle-l_at_freelists.org>
Sent: Tuesday, March 09, 2004 3:29 PM
Subject: Unix script to check database status

> 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_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
> -----------------------------------------------------------------

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 Tue Mar 09 2004 - 16:20:13 CST