How to set email or sms alert when database is down .

HI

As I understand , the Q was how to be notified that the DB is going down ' isn't it ???

hi schwertner

thanks for u r Reply .... sir can u guide me how to set CRON job .... can u give me script.. What i need is when our database is down i what to receive email or sms.

thank

hi  peter991:

What is the time stamp of above script.

Hi!
Do you need date/time in the message?
I don't think I understand your question.

hi perter991,

NO.... No....the above script when it will be run or if database is down then only it will run and send mail. can u explain above script

Then one more think .... if Application sever( we have iplante) is down ? did u have any script for that ? the iplanet also running on sun solaris.  perter if u wont mind can u give me step by step procedure?

thanks.

hi peter991:
Thanks lots..

The iplante  process name is JAVA.

 

Just be aware that if you set up an O/S job to check every few minutes if an Oracle database is down, and send you an e-mail, your mailbox may get flooded if the database is ever down for maintenance, or if you are sleeping, on vacation, or just not checking your e-mail for some time.

Also, which server will you schedule this on?  If you run this on the same server as the database, but the server itself goes down, you will *NOT* be informed by e-mail that Oracle is down!

Then what about the problem of the database being up, but the Oracle listener is down?  That will also prevent new user connections, even though the database is "up".

markgeer has a point here.
If you want to bring this to a more professional level I would recommend nagios.

www.nagios.org

To check your listner you can use tnsping <SID>
IP can be used as well.

Regards

hi peter991:

i have created cronjob script (which u given ), but when i shutdown my database, i not receiving  any email. what will be the resion.

Then how to check and test whether my OS(sun solaris 8) sending mail or not.

Hi!
Perhaps you need to configure your sendmail.
I recommend that you start a new question about sendmail in unix-zone.
I'm sure you will get alot of help on this issue.

Regards