Home / server / Questions / 123447
In Process
BIBD
Asked: 2010-03-18 07:44:14 +0800 CST

Getting an alert when my oracle database goes up or down

  • 772

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?

email monitoring network-monitoring oracle

3 Answers

  1. 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.

    • 1

  2. Use Nagios, it's free and have Oracle connectors

    http://www.nagios.org/

    • 1

  3. 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.

    • 0