check_oracle_health

check_oracle_health is an open source Nagios plugin that can be used to monitor a variety of oracle database metrics.

check_oracle_health includes connection time, SGA data buffer hit ratio, SGA dictionary cache hit ratio, SGA library cache hit ratio, SGA shared pool free, tablespace usage, PGA in memory sort ratio, tablespace fragmentation, invalid objects, tablespace I/O balance, and many more.

What is new in this release:

• Bugfix in add_nagios, raising a deprecated-message in Perl. (Thanks Philip Griesbacher)

What is new in version 1.7.3:

• New modes were added: sga-library-cache-pinhit-ratio, sga-library-cache-gethit-ratio, and sga-library-cache-reloads.
• The mode sql now correctly handles DML SQL errors like missing tables, etc.

What is new in version 1.6.8.1:

• This version fixes a bug that lead to numerous leftover temp files under Windows.
• Upgrading is recommended.

What is new in version 1.6.8:

• massive speedup in modes seg-top10-* (Thanks Michael Nieberg http://kenntwas.de)
• bugfix in -mode sql (numeric vs. regexp result) (Thanks Michel Meelker)

What is new in version 1.6.7:

• mode sql can now have a non-numerical output which is compared to a string/regexp
• new mode report can be used to output only the bad news (short,long,html)
• better error message with method sqlplus when db is down

What is new in version 1.6.6.1:

• dbthresholds have an argument
• added a workaround rof an oracle-bug in shared-pool-free. Thanks Yannick

What is new in version 1.6.6:

• new parameter -dbthresholds. thresholds can now also be deposited in the table check_oracle_health_thresholds
• bugfix in connection-time. dbuser was uninitialized in rare cases

What is new in version 1.6.2:

• Bugfix in tablespace-usage/free wg. nicht-autoextensible TEMP-Tablespaces. (Danke Daniel Graef)

What is new in version 1.6.1:

• --mode=tablespace-usage|free erkennt jetzt offline Tablespaces. (Danke Daniel Graef)

Requirements:

• Perl
• DBI
• Nagios