Take the 2-minute tour ×
Server Fault is a question and answer site for 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

3 Answers 3

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. –  BIBD Mar 19 '10 at 19:18

Use Nagios, it's free and have Oracle connectors

http://www.nagios.org/

share|improve this answer

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). –  BIBD Mar 17 '10 at 18:19
    
Sorry, $39 is as close to free as I can find :-| –  DCookie Mar 17 '10 at 19:51

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.