Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

3 Answers

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.

share|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
add comment

Use Nagios, it's free and have Oracle connectors

http://www.nagios.org/

share|improve this answer
add comment

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.

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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