Avatar of Maddy
MaddyFlag for India 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  
Unix OSOracle Database

Avatar of undefined
Last Comment
LindaC

8/22/2022 - Mon
SOLUTION
elimesika

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
schwertner

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
elimesika

HI

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

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
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Maddy

hi  peter991:

What is the time stamp of above script.
Your help has saved me hundreds of hours of internet surfing.
fblack61
peter991

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

ASKER
Maddy

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.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Maddy

hi peter991:
Thanks lots..

The iplante  process name is JAVA.

 
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mark Geerlings

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".
peter991

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
ASKER
Maddy

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
peter991

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

SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.