Setting up Nagios Check Oracle Health (Oracle Linux 8)

[David]

dnf --enablerepo=ol8_codeready_builder install libnsl2-devel
dnf install perl-DBI

perl -MCPAN -e shell
get DBD::Oracle
quit

cd ~/.cpan/build/DBD-Oracle*
export LD_LIBRARY_PATH=/u01/app/oracle/product/db19.3.0.0/lib
export ORACLE_HOME=/u01/app/oracle/product/db19.3.0.0
perl Makefile.PL
make
make install

Unzip the attached file to your nagios plugin directory.

Setup nrpe for nagios similar to this...
command[deveng_time]=/usr/lib64/nagios/plugins/check_oracle_health --connect deveng --user nagios --password 'supersecretpw' --mode connection-time -environment ORACLE_HOME=/u01/app/oracle/product/db19.3.0.0/ -environment LD_LIBRARY_PATH=/u01/app/oracle/product/db19.3.0.0/lib

command[deveng_pool_free]=/usr/lib64/nagios/plugins/check_oracle_health --connect deveng --user nagios --password 'supersecretpw' --mode sga-shared-pool-free -environment ORACLE_HOME=/u01/app/oracle/product/db19.3.0.0/ -environment LD_LIBRARY_PATH=/u01/app/oracle/product/db19.3.0.0/lib

command[deveng_datafile]=/usr/lib64/nagios/plugins/check_oracle_health -environment ORACLE_HOME=/u01/app/oracle/product/db19.3.0.0/ -environment LD_LIBRARY_PATH=/u01/app/oracle/product/db19.3.0.0/lib --connect deveng --user nagios --password 'supersecretpw' --mode datafile-io-traffic --datafile users.264.870252275