Listener Configuration Overview

A listener is configured with one or more listening protocol addresses and information about the destination service.

Protocol addresses are configured in the listener configuration file, listener.ora. Service information may or may not be configured in the listener.ora file:

During installation, Oracle Net Configuration Assistant assumes you may use Oracle Enterprise Manager to monitor the database, so service information is configured statically in the listener.ora file.

The following listener.ora file shows a sample configuration. The LISTENER entry defines the listening protocol address for a listener named LISTENER and the SID_LIST_LISTENER entry provides information about the database service, including the global database name, the Oracle home location of the database, and the Oracle System Identifier (SID) of the instance.

LISTENER=
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=sales.us.acme.com)
      (ORACLE_HOME=/oracle9i)
      (SID_NAME=sales)))