yaonp - yet another oracle nagios plugin

Sorry for answering your question so late. But i had problems with my internet connection and was most time offline. Even now it is very slow and often disconnecting.

But now back to topic. Here is a small, step by step, example how to extend yaonp:

1. on oracle host

1. open yaonp-collector.pl, go to the section where the checks are defined and copy/paste the last check, three lines. E.g.

$NAME[12]='tbspcuse';
$ACTIVE[12]='yes';
$SQL[12]='SELECT \'tbspcuse\'||\'|\'||ROUND(USED_PERCENT)||\'|\'||TABLESPACE_NAME||\'|\'||\'|Tablespace Usage=%|\' FROM dba_tablespace_usage_metrics;';

2. modify this lines to your needs
a. give the test a name. Eg. sessuti
b. count the array index up by one
c. edit the SQL-Statement to your needs and adjust the output fitting for yaonp-plugin.pl. E.g.

select current_utilization from v$resource_limit where resource_name ='sessions';

will be

'SELECT \'sessuti\'||\'|\'||current_utilization||\'|\'||\'|\'||\'|Session Utilization=%|\'FROM v$resource_limit WHERE resource_name =\'sessions\';';

the resulting lines should look like:

$NAME[13]='sessuti';
$ACTIVE[13]='yes';
$SQL[13]='SELECT \'sessuti\'||\'|\'||current_utilization||\'|\'||\'|\'||\'|Session Utilization=%|\'FROM v$resource_limit WHERE resource_name =\'sessions\';';

3. test it

ozone:~$ ./yaonp-collector.pl |grep sess
numsessions|24|||Count Sessions=|
numblcksess|0|||Number of sessions blocked by other sessions=|
sessuti|31|||Session Utilization=%|

looks good.

4. edit nrpe.cfg and insert the new check, e.g.

command[ora_sessuti]=/usr/local/nagios/libexec/yaonp-plugin.pl sessuti -w 50% -c 75%

5. reload/restart nrpe.

All done on oracle host.

2. on nagios host

1. edit checkcommands.cfg and insert the new command, e.g.

define command {
command_name ora_sessuti
command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -c ora_sessuti
}

2. edit services.cfg, e.g.

define service {
service_description ora_sessuti
check_command ora_sessuti!
host_name ozone
check_period 24x7
event_handler_enabled 0
max_check_attempts 3
check_interval 5
retry_interval 1
active_checks_enabled 1
passive_checks_enabled 0
notifications_enabled 1
check_freshness 0
freshness_threshold 86400
contact_groups admins
}

3. reload/restart nagios/icinga on your nagios host
4. done