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:
An Oracle9i and Oracle8i database service automatically registers certain information with the listener, such as its service names, instance names, service handlers, and load information. This feature, called service registration, does not require static configuration in the listener.ora file.
Other services, including an Oracle7 or Oracle8 database and the Oracle Enterprise Manager management tools, require service configuration 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)))