HOWTO – Add check_db Plug-in (check_db)

The plug-in can be found at nagios exchange bu this is a modified version which actually uses SERVICE_NAME instead of SID. This has been loaded with the new JDBC connectivity driver for the new Oracle server Connectivity.

Description:

Nagios plugin to check output of a Oracle sql query, matched with a regular expression. This checks the numeric data to the matched regular expression.

Remote oracle database check using JDBC drivers. Supports custom SQL queries and regular expression match. Provides similar functionality as SiteScope DB monitor. This plug-in can check almost every aspect of oracle database

The plug-in uses JSAP command line parser from http://www.martiansoftware.com/jsap/  and a ojdbc6.jar class file for the connectivity.

This plug-in involves basically 4 component check_db , DbCheck.class/DbCheck.java , ojdbc6.jar and JSAP-2.0a.jar

You can get the completed doc and file at this location: https://skydrive.live.com/redir?resid=7109A4AA026A5AFB!112