instantclient-basic
instantclient-sdk
instantclient-sqlplus
instantclient-tools
unzip instantclient-sdk-linux.x64-XXXXXXdbru.zip
unzip instantclient-basic-linux.x64-XXXXXXdbru.zip
unzip instantclient-sqlplus-linux.x64-XXXXXXdbru.zip
unzip instantclient-tools-linux.x64-XXXXXXdbru.zip
mkdir -p /opt/oracle/ mv instantclient_XX_X /opt/oracle/ sh -c "echo /opt/oracle/instantclient_XX_X > /etc/ld.so.conf.d/oracle-instantclient.conf" ldconfig mkdir -p /opt/oracle/instantclient_XX_X/network/admin copy tnsnames.ora into this folder.
TNS_ADMIN=/opt/oracle/instantclient_XX_X/network/admin ORACLE_HOME=/opt/oracle/instantclient_XX_X LD_LIBRARY_PATH=/opt/oracle/instantclient_XX_X/lib
create user nagios identified by oradbmon; grant create session to nagios; grant select any dictionary to nagios; grant select on V_$SYSSTAT to nagios; grant select on V_$INSTANCE to nagios; grant select on V_$LOG to nagios; grant select on SYS.DBA_DATA_FILES to nagios; grant select on SYS.DBA_FREE_SPACE to nagios; -- -- for Oracle 8.1.7 ... grant select on sys.dba_tablespaces to nagios; grant select on dba_temp_files to nagios; grant select on sys.v_$Temp_extent_pool to nagios; grant select on sys.v_$TEMP_SPACE_HEADER to nagios; grant select on sys.v_$session to nagios;