{{ t('Configuration Wizard: Oracle Database') }}
{{ t('Host Information') }}
{{ t('Configure Oracle Monitoring') }}

{{ t('Administration Settings') }}

{{ t('Please replace XXXXX with your version.') }}
  1. {{ t('Please download a recent version of the following packages from here') }} ( https://www.oracle.com/de/database/technologies/instant-client/linux-x86-64-downloads.html )
    • instantclient-basic
    • instantclient-sdk
    • instantclient-sqlplus
    • instantclient-tools
  2. {{ t('Extract files') }}
    • 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
  3. {{ t('Install') }}
    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.
  4. {{ t('Environment Variables') }}
    {{ t('Add the following to {0}', {"0": "/etc/environment"}) }}
    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
  5. {{ t('Create User within Database') }}
    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;