up vote 2 down vote favorite
1
share [g+] share [fb]

How can I get an e-mail alert when my oracle database comes up or down?

I have a database that I need to know when it goes down (it would be nice to know if it has come back up), preferably from a remote machine. Conceivably I could hack together something that TNSPings my DB and e-mails me when that changes, but I'm hoping there's a free package out there. Something that would run on windows.

Any strong recommendations?

link|improve this question
78% accept rate
feedback

3 Answers

up vote 1 down vote

Take a look a http://www.bigsister.ch/bigsister.html

I 've used this in the past to monitor a small network. You can also add checks to test, if services (e.g. Oracle Listener) are available.

link|improve this answer
Excellent, it's free and it works on windows. I'll see if I can get it to work. – CodeSlave Mar 19 '10 at 19:18
feedback
up vote 1 down vote

Use Nagios, it's free and have Oracle connectors

http://www.nagios.org/

link|improve this answer
feedback
up vote 0 down vote

You can use system triggers to do some of this. You could combine the trigger with the use of the UTL_MAIL package. You might be able to use dbms_scheduler if you're monitoring via another database.

Additional info: I found DBUptime on Burleson's Guide to free Oracle Utilities Page. Maybe that's more what you want.

link|improve this answer
close... triggers would not be remote, and the other solution not really free (free to try though). – CodeSlave Mar 17 '10 at 18:19
Sorry, $39 is as close to free as I can find :-| – DCookie Mar 17 '10 at 19:51
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.