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:

An Oracle8i or later 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 Oracle8 database, require service configuration 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.example.com )


   (ORACLE_HOME=/oracle)


      (SID_NAME=sales)))

Listener Configuration Overview

Related Topics