Listener configuration tutorial for Oracle 11g2
- 2021-01-02 22:01:52
- OfStack
There are two ways to register the listener service in Oracle, dynamic and static. Services that register dynamically at lsnrctl status display status as ready and static services as unknown.
In previous versions of 11g2, listeners were configured via the listener.ora file. In the 11g2 release, the configuration of the listener has changed. A new configuration file, ES10en_listener.ora, has been added, and both this file and the original listener.ora file have been moved to the $GRID_HOME/network/admin directory.
11 g2 listener configuration information stored in the $GRID_HOME network/admin/listener ora and endpoints_listener ora two file.
The file endpoints_listener.ora reads as follows:
. ora code
File ES40en. ora reads as follows:
. ora code
. ora code
Static service registry to add entries
If you need to add a statically registered service, add the corresponding entry in the listener.ora file as in previous version 1.
Use lsnrctl status listener to check the listener status as follows:
Log code
Install oracle 10g on grid infrastructure for 11g2. The listener configuration file for 10g also uses the file under $GRID_HOME/network/admin.
However, a compromise is needed to set the file of listener_HOME /network/admin of 10g to the file link of endpoints_HOME /network/admin of ES85en_listener.ora of $ORACLE_HOME/ admin.
In previous versions of 11g2, listeners were configured via the listener.ora file. In the 11g2 release, the configuration of the listener has changed. A new configuration file, ES10en_listener.ora, has been added, and both this file and the original listener.ora file have been moved to the $GRID_HOME/network/admin directory.
11 g2 listener configuration information stored in the $GRID_HOME network/admin/listener ora and endpoints_listener ora two file.
The file endpoints_listener.ora reads as follows:
. ora code
LISTENER_SERV2=
(DESCRIPTION=
(
ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=xxdb2-vip)(PORT=1551))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.100)(PORT=1551)(IP=FIRST))
)
)
File ES40en. ora reads as follows:
. ora code
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_WFG=ON # line added by Agent
. ora code
Static service registry to add entries
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = servdb)
(ORACLE_HOME = /u01/oracle/app/oracle/product/10.2.0/db)
(SID_NAME = servdb1)
)
)
If you need to add a statically registered service, add the corresponding entry in the listener.ora file as in previous version 1.
Use lsnrctl status listener to check the listener status as follows:
Log code
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2012 14:18:34
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 29-NOV-2012 14:11:17
Uptime 0 days 0 hr. 7 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0.3/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/serv2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.100)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.101)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "SERVDG2" has 1 instance(s).
Instance "servdb1", status READY, has 1 handler(s) for this service...
Service "SERVDG2_XPT" has 1 instance(s).
Instance "servdb1", status READY, has 1 handler(s) for this service...
Service "elvdb" has 2 instance(s).
Instance "elvdb1", status UNKNOWN, has 1 handler(s) for this service...
Instance "elvdb2", status READY, has 1 handler(s) for this service...
Service "elvdbXDB" has 1 instance(s).
Instance "elvdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
Install oracle 10g on grid infrastructure for 11g2. The listener configuration file for 10g also uses the file under $GRID_HOME/network/admin.
However, a compromise is needed to set the file of listener_HOME /network/admin of 10g to the file link of endpoints_HOME /network/admin of ES85en_listener.ora of $ORACLE_HOME/ admin.