$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_2/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = accord.novaglobal.com.sg)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = orcl) (PRESENTATION = RO) ) ) cat listener.ora # listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_2/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_2) (PROGRAM = extproc) (ENVS = "LD_LIBRARY_PATH=/home/oracle/DSAccord/lib, ACCORD_SYSTEM_6=/home/oracle/DSAccord/system/, ACCORD_SETTINGS_6=/home/oracle/DSAccord/accord6.ini, EXTPROC_DLLS=libaccora10.so.6:libaccosk10.so.6") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = accord.novaglobal.com.sg)(PORT = 1521)) ) ) cat sqlnet.ora # sqlnet.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_2/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)