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 : lien
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 --with-mymodules-dir=/usr/lib/nagios/plugins --with-mymodules-dyn-dir=/usr/lib/nagios/plugins # make # make install
As nagios, run
/usr/lib/nagios/plugins/check_oracle_health --environment ORACLE_HOME=/usr/lib/oracle/11.2/client/lib --environment LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib --connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=X.X.X.X)(PORT=1521))(CONNECT_DATA=(SID=base)))" --user user --password secret --mode tnsping