check_has

Project Notes

Nagios plug-in for Oracle High Availability Services OHAS (11g and above)
It checks:
a) ohas stack status
b) OCR registry integrity
c) resource status (ONLINE/OFFLINE); you can define exceptions with exclude option
d) database instance status - if it is running as configured

This plug-in needs to be run as clusterware binaries owner (usually oracle).

Run 'check_has --help' for full description.

Setup:

1. disable 'requiretty' for nrpe-owner in /etc/sudoers
Defaults:nagios !requiretty

2. enable sudo for nrpe-owner to run this script
nagios ALL=(oracle) NOPASSWD: /usr/lib64/nagios/plugins/check_has

3. edit nrpe.cfg and insert required checks with options:

command[check_has_ohasstatus]=sudo -u oracle /usr/lib64/nagios/plugins/check_has --has_home=$CRS_HOME --action=ohasstatus
command[check_has_ocrcheck]=sudo -u oracle /usr/lib64/nagios/plugins/check_has --has_home=$CRS_HOME --action=ocrcheck
command[check_has_resstatus]=sudo -u oracle /usr/lib64/nagios/plugins/check_has --has_home=$CRS_HOME --action=resstatus --exclude=res1.example,res2.example
command[check_has_instancestatus]=sudo -u oracle /usr/lib64/nagios/plugins/check_has --has_home=$CRS_HOME --action=instancestatus

Sample output:

check_has --has_home=/oracle/gridhome --action=ohasstatus
[OK] All OHAS services are up (OHAS version: 11.2.0.4.0)
check_has --has_home=/oracle/gridhome --action=ocrcheck
[OK] Cluster registry integrity check succeeded - (/u01/app/11.2.0/grid11204/cdata/localhost/local.ocr: succeeded)
check_has --has_home=/oracle/gridhome --action=resstatus
[OK] All required resources are up
check_has --has_home=/oracle/gridhome --action=instancestatus
[OK] All required database instances are up