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

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
75071
Files:
FileDescription
check_remote_oraclePlugin file (shell script)
check_remote_oracleVersion 0.2
check_remote_oracleVersion 0.3

Help Support Ethan Galstad's New Project:

Help Support Ethan

A Message From The Founder...

As the founder of Nagios, I'm asking for your help in a cause that's dear to my heart.

I'm launching a new project to help better the world by providing the information, ideas, and inspiration that I believe can improve the lives of people everywhere.

I know you're busy managing networks, but I would appreciate it if you would consider liking my Facebook page and showing your support for the content and messages I produce by sharing them with your friends and family.

You can learn more about my project by visiting ethangalstad.me/nagios. Thank you for your time. I wish you all the best in your endeavors, whatever they may be.

- Ethan

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)