ORACLE listerner.oraÎļþ ²ÎÊýÒâ˼

The following items are available in the network listener configuration file (listener.ora).
    * Listener Address Section
    * SID_LIST_listener_name Static Service Section
    * Control Parameters
The listener.ora file is located in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows NT, or in the directory specified by the TNS_ADMIN environment variable or registry value.
1. Listener Address Section
The listener address section of the listener.ora file defines the protocol address(es) of the listener.
DESCRIPTION
Purpose: Defines listener protocol address(es)
Example:
listener_name=
(description=
(address=(protocol=ipc)(key=extproc0))
(address=(protocol=tcp)(host=sales-pc)(port=1521)))
ADDRESS
Purpose: Defines a listener protocol address. This parameter can be embedded under a ADDRESS_LIST or DESCRIPTION.
Example:
listener_name=
(description=
(address=(protocol=ipc)(key=extproc0))
(address=(protocol=tcp)(host=sales-pc)(port=1521)))
ADDRESS_LIST
Purpose:
Defines lists of listener protocol addresses. If there is only one list of addresses, it is not necessary to use this parameter. This parameter can be embedded under a DESCRIPTION.
Example:
listener_name=
(description=
(address_list=
   (address=(protocol=ipc)(key=extproc0))
   (address=(protocol=tcp)(host=sales-pc)(port=1521))))
2. SID_LIST_listener_name Static Service Section
You can use the SID_LIST section of the listener.ora to statically configure service information with the listener.
The SID_LIST is required for backward compatibility with Oracle8 or Oracle7 databases, as well as external procedures and heterogeneous services, and some management tools, including Oracle Enterprise Manager.
Oracle8i database information is dynamically registered with the listener during instance startup. Therefore, this information is not required, unless Oracle Enterprise Manager is used to mo