Miscellany

listener.ora

# listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      (ADDRESS = (PROTOCOL = TCP)(HOST = accord.novaglobal.com.sg)(PORT = 1521))
    )
  )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
      (ENVS = "LD_LIBRARY_PATH=/home/oracle/DSAccord6/lib,
        ACCORD_SYSTEM_6=/home/oracle/DSAccord6/system/,
        ACCORD_SETTINGS_6=/home/oracle/DSAccord6/accord6.ini,
        EXTPROC_DLLS=ANY")
    )   

        (SID_DESC =
        (SID_NAME = extproc)
        (PROGRAM=extproc)
    )
  )


TRACE_LEVEL_LISTENER = ADMIN
TRACE_FILE_LISTENER = TESTTRC.trace

---------------------------

sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
TRACE_LEVEL_CLIENT = USER
TRACE_FILE_CLIENT = CLIENT.trace
TRACE_DIRECTORY_CLIENT = /home/oracle/



--------------------------
]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/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 = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = extproc)
      (PRESENTATION = RO)
    )
  )