Create and configure a listener

The listener forwards client requests to supported services. These services can be configured statically in the listener.ora file or they can be dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the PMON process.

Below sample listener.ora file. The LISTENER entry defines the listening protocol address for a listener named LISTENER, and the SID_LIST_LISTENER entry provides information about the external services statically supported by the listener LISTENER.
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc) (queuesize=50))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=plsextproc)
(ORACLE_HOME=/oracle11g)
(PROGRAM=extproc)))

•  If you expect the listener to handle large volumes of concurrent connection requests, then you can specify a listener queue size for its TCP/IP or IPC listening endpoints.

Configuring Static Service Information
The listener uses the dynamic service information about the database and instance before using statically configured information in the listener.ora file. Configuration of static service information is necessary if you require remote database startup from a tool other than Oracle Enterprise Manager, or you have Oracle Database releases earlier than Oracle8i.

The following example shows an excerpt of a listener.ora file statically configured for a database service called sales.us.example.com:
SID_LIST_listener=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=sales.us.example.com)
(SID_NAME=sales)
(ORACLE_HOME=/u01/app/oracle/11g)))
Password for listener
You can use the Listener Control utility (lsnrctl) or Oracle Enterprise Manager to configure or change the Oracle Net Listener password.
■ To set a new encrypted password using lsnrctl, do the following:
LSNRCTL> SET PASSWORD
Password: password
The command completed successfully
■ To change an encrypted password using lsnrctl, do the following:
LSNRCTL> CHANGE_PASSWORD
Old password: old_password
New password: new_secure_password
Reenter new password: new_secure_password
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=tpc)(HOST=sales-server)(PORT=1521)))
Password changed for LISTENER
The command completed successfully
LSNRCTL> SAVE_CONFIG
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sales-server)(PORT=1521)))
Saved LISTENER configuration parameters.
Listener Parameter File /oracle/network/admin/listener.ora
Old Parameter File /oracle/network/admin/listener.bak
The command completed successfully

Managing Oracle Net Services
Using Oracle Enterprise Manager to Configure Oracle Net Services


Easy Connect
SQL> connect LSMITH@"192.168.20.81/OCM1"
Enter password:
Connected.
SQL>
Related Topic:
Using Connection Manager
Resetting Listener Log without stopping Database