Maddy
asked on
How to set email or sms alert when database is down .
Hi expert new task for me ..
I what to set email or sms alter when database is down.
Database : Oracle8i
OS: Sun solars
thanks
I what to set email or sms alter when database is down.
Database : Oracle8i
OS: Sun solars
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi peter991:
What is the time stamp of above script.
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.
Do you need date/time in the message?
I don't think I understand your question.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi peter991:
Thanks lots..
The iplante process name is JAVA.
Thanks lots..
The iplante process name is JAVA.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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".
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
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
ASKER
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.
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As I understand , the Q was how to be notified that the DB is going down ' isn't it ???