Nagios and Oracle

SMN · 12 Jun 2012 at 15:41

Hi all,

Is anyone here using Nagios to monitor any Oracle databases? Im losing my mind trying to get check_oracle, check_oracle_health etc working from the Nagios Exchange.

Thanks,
Sam

SMN · 12 Jun 2012 at 20:39

That'd be amazing. Im having issues with it saying something along the lines of "ORACLE NOT KNOWN" or something, i think i need to declare / set some values first.

SMN · 13 Jun 2012 at 13:09

Awesome. What i dont get though, is:

/check_oracle_health --mode=session-usage --connect=****dbab1 --username=nagios --password=****** --warning=35 --critical=80

Where in that is the actual Host IP/hostname specified?

SMN · 13 Jun 2012 at 16:13

Yeah, well i installed the client but when i did a "find / -name .ora 2> /dev/null" it didnt find anything. Do you know where it is stored generally?

SMN · 14 Jun 2012 at 14:16

OK i got it working thanks guys! Turns out i was doing it wrong, so i found the file on sourceforge, did the ./configure (with correct options) and then make/make install, but this time instead of then going to the "plugins" folder in the make directory, i went to /usr/local/nagios and ran that script, and once i got DBD::Oracle installed, it worked great

SMN · 21 Jun 2012 at 11:41

I wrote up a "how to" for using the plugin with my companies software, its based on Nagios though so the steps are exactly the same up until step 9, afterwhich you can ignore.

http://www.opsview.com/whats-new/blog/monitoring-oracle-using-opsview-v4

Hope it makes sense to everyone/is useful, as it took me a good week or 2 to get this flaming plugin to work