DB Drivers
  • Oracle 8.1.7 Client for Linux
Configuration  of ‘tnsnames.ora’.
Located at /opt/ora/OraHome1/network/admin.
# TNSNAMES.ORA Network Configuration File: /opt/ora/OraHome1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

PARADIGM.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db-host)(PORT = 1519))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PARADIGM)
    )
  )

INST1_HTTP.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db-host)(PORT = 1519))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = PARADIGM)
      (PRESENTATION = http://admin)
    )
  )
  • Modification of /etc/profiles on server Lofty
NX_ROOT=/opt/CAisd
ORACLE_BASE=/opt/ora
ORACLE_HOME=/opt/ora/OraHome1
ORACLE_SID=paradigm
PATH=$PATH:$NX_ROOT/bin:$ORACLE_HOME/bin
NX_DB_SIZE=MEDIUM
NX_DATA_TABLESPACE=PDM_DATA
NX_INDEX_TABLESPACE=PDM_INDEX
SQLNET_V=V2
DISPLAY=lofty:0.0
export NX_DB_SIZE NX_DATA_TABLESPACE NX_INDEX_TABLESPACE ORACLE_SID
export NX_ROOT PATH ORACLE_HOME ORACLE_BASE SQLNET_V DISPLAY