This howto describe, how to install check_oracle_health plugins on FAN 2.0
As root, run
yum install make perl-DBI gcc
Download on Oracle Instant Client pour linux :
Download perl library : DBD-Oracle-1.23.tar.gz
Installation RPM :
As root, run
rpm -Uvh oracle-instantclient11.2-basic-11.2.0.1.0-1.i386.rpm rpm -Uvh oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386.rpm rpm -Uvh oracle-instantclient11.2-devel-11.2.0.1.0-1.i386.rpm
Installation perl library :
As root, run
tar xzf DBD-Oracle-1.23.tar.gz cd DBD-Oracle-1.23 export ORACLE_HOME=/usr/lib/oracle/11.2/client/lib export LD_LIBRARY_PATH=$ORACLE_HOME perl Makefile.PL make make install
Download check_oracle_health-1.6.2.tar.gz
As root, run
tar xzf check_oracle_health-1.6.2.tar.gz cd check_oracle_health-1.6.2 ./configure --build=i686-redhat-linux-gnu --host=i686-redhat-linux-gnu --target=i386-redhat-linux-gnu --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --prefix=/usr/lib/nagios --libexecdir=/usr/lib/nagios/plugins --with-perl=/usr/bin/perl make make install
As nagios, run
/usr/lib/nagios/plugins/check_oracle_health --connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=X.X.X.X)(PORT=1521))(CONNECT_DATA=(SID=base)))" --user user --password secret --mode tnsping