Home Directory Plugins Databases Oracle Check Remote Oracle through Ssh (No need to install Oracle client)

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

Check Remote Oracle through Ssh (No need to install Oracle client)

Current Version
0.2
Last Release Date
2012-04-23
Compatible With
  • Nagios 3.x
License
GPL
Hits
80333
Files:
FileDescription
check_remote_oraclePlugin file (shell script)
check_remote_oracleVersion 0.2
check_remote_oracleVersion 0.3
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
New version 0.3 to fetch real undo usage ("UNEXPIRED SEGMENTS")

(New version 0.2 with active sessions count, ASM diskgroups and hard/soft parsing percentage ratios check)

This is the original official check_oracle nagios plugin, developed by latigid010@yahoo.com (whoever he is) modified to work through ssh to check the remote oracle server, and allows to check the listener, the pmon process status, the caches hits ratio and the not temporary tablespaces size (hoping to add this temp tablespaces too in the future).

The script requires the ssh server running on the oracle server and the nagios user public ssh key to be copied to the oracle machine you want to monitor so the plugin can access with no password to it.

As the original, it's programmed on shell script, so it's clearer to debug and understand.

More checks will be added in the future, as this is just the first release.

I hope you find it useful.

Regards and enjoy!
This is the original official check_oracle nagios plugin, developed by latigid010@yahoo.com (whoever he is) modified to work through ssh to check the remote oracle server, and allows to check the listener, the pmon process status, the caches hits ratio and the not temporary tablespaces size (hoping to add this temp tablespaces too in the future).

The script requires the ssh server running on the oracle server and the nagios user public ssh key to be copied to the oracle machine you want to monitor so the plugin can access with no password to it.

As the original, it's programmed on shell script, so it's clearer to debug and understand.

More checks will be added in the future, as this is just the first release.

I hope you find it useful.

Regards and enjoy!

my_nagios_server:/usr/local/nagios/libexec# su - nagios -c "/usr/local/nagios/libexec/check_remote_oracle -H oracle_server.mycompany.com --tns ORCL"
OK - reply time 0 msec from ORCL
my_nagios_server:/usr/local/nagios/libexec# su - nagios -c "/usr/local/nagios/libexec/check_remote_oracle -H oracle_server.mycompany.com --db ORCL"
ORCL OK - 1 PMON process(es) running
my_nagios_server:/usr/local/nagios/libexec# su - nagios -c "/usr/local/nagios/libexec/check_remote_oracle -H oracle_server.mycompany.com --cache ORCL 90 95"
ORCL OK - Cache Hit Rates: 99.86% Lib -- 99.49% Buff|lib=99.86%;95;90;0;100 buffer=99.49%;95;90;0;100
my_nagios_server:/usr/local/nagios/libexec# su - nagios -c "/usr/local/nagios/libexec/check_remote_oracle -H oracle_server.mycompany.com --tablespace ORCL SYSTEM 95 90"
ORCL : SYSTEM CRITICAL - 97.60% used [ 22 / 900 MB available ]|SYSTEM=97.60%;90;95;0;100
Reviews (1)
byottow, June 4, 2014
Works as advertised. Make sure to put script under /libexec before testing or it will not work (it calls utils.sh from the current dir)