Listener.ora

From Oracle FAQ
Jump to: navigation, search

Listener.ora is a SQL*Net configuration file used to configure Oracle Database Listeners (required to accept remote connection requests).

This file normally resides in the ORACLE HOME\NETWORK\ADMIN directory or in the directory define by the $TNS_ADMIN variable.

Example listener.ora file:

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

# SID_LIST_LISTENER =
#   (SID_LIST =
#     (SID_DESC =
#       (SID_NAME = PLSExtProc)
#       (ORACLE_HOME = /app/oracle/product/11.1.0/db_1)
#       (PROGRAM = extproc)
#     )
#   )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )