This software named check_oracle_health functions as a plugin for Nagios that can oversee various metrics of an Oracle database system.
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;.
Version 2.1: N/A