-
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