check_oracle_health

If you're looking for a Nagios plugin that can monitor various oracle database metrics, check_oracle_health is the perfect solution. It has a range of features, from measuring connection time to monitoring SGA data buffer hit ratios and much more.

Before diving right in, you'll need to compile the check_oracle_health script. To do this, run the configure script using the following command: './configure --prefix=BASEDIRECTORY --with-nagios-user=SOMEUSER --with-nagios-group=SOMEGROUP --with-perl=PATH_TO_PERL --with-statefiles-dir=STATE_PATH'. Be sure to replace each variable with the appropriate value. Simply running './configure' should suffice for creating a basic check_oracle_health script, which you can customize later.

Next, "compile" the plugin by using 'make'. This will produce a "check_oracle_health" script. Ignore 'check_oracle_health.pl' since it's simply a base for compilation.

You can then install the compiled plugin script with the 'make install' command. Ensure that your Nagios configuration files contain the correct paths to the new plugin.

The command line parameters for this plugin include --connect=< the oracle connect string >, --user=< username >, --password=< secret >, --mode=< operation mode >, --tablespace=< tablespace name >, --warning=< warning threshold >, and --critical=< critical threshold >.

To prepare the database for monitoring, use the following commands: create user nagios identified by 'whatever'; grant create session to nagios; grant select any dictionary to nagios; grant select on V_$SYSSTAT to nagios; grant select on V_$INSTANCE to nagios; grant select on V_$LOG to nagios; grant select on SYS.DBA_DATA_FILES to nagios; grant select on SYS.DBA_FREE_SPACE to nagios;.