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

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

You must be logged in to submit a review.

Your review has been submitted and is pending approval.

Your recommendation has been sent.

Project Overview Project Files Project Notes Reviews