ORACLE CLIENT installation

ORACLE CLIENT installation for check_oracle_health plugin on Linux x86_64 platform

1) INSTALL RPM PKGS
================
yum install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
check the installation path of the rpm to set the path for ORACLE HOME and LIBRARY PATH
rpm -ql oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm


2) SET ENV VARIABLES PERMANETLY
===========================
[root@RMIR1BLNNGOS01 libexec]# cat /etc/environment
ORACLE_HOME=/usr/lib/oracle/11.2/client64
LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib




3) CPAN
====
install DBI
install DBD::Oracle


4) VALIDATE THE CONNECTION


sqlplus 'test/test@123@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostIPaddress)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=service_name)))'
./check_oracle_health --username=test --password=test@123 --connect='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostIPaddress)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name)))' --mode=tablespace-free