Oracle Restart: Second listener listens Multiple IP's due to oraagent registration
(Doc ID 2092643.1)
Last updated on MARCH 29, 2024
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
Symptoms
The Listener LISTENER has been configured on IP 10.64.xxX.xxx (host ip) and LISTENER_DG configured on 10.64.YYY.YYY in listener.ora. The LISTENER_DG listener status shows listens on both IP's.
$ lsnrctl status LISTENER >>>>>>>>>>>>> LOCAL LISTENER
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 15-JAN-2016 14:14:39
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
..
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XXX.XXX)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
..
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
$ lsnrctl status LISTENER_DG >>>>>>>>>>> Configured New Listener
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 15-JAN-2016 14:15:57
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XXX.XXX)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DG
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 15-JAN-2016 13:36:18
Uptime 0 days 0 hr. 39 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/product/12.1.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/celvpint5012/listener_dg/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XXX.XXX)(PORT=1529)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XXX.XXX)(PORT=1529))) >>>>>>>>>>>Displaying the host IP which has been not configured to listen for LISTENER_DG
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
$ srvctl config listener -l LISTENER
Name: LISTENER
Type: Database Listener
Home: /u01/app/grid/product/12.1.0/grid
End points: TCP:1521
Listener is enabled.
$ srvctl config listener -l LISTENER_DG
Name: LISTENER_DG
Type: Database Listener
Home: /u01/app/grid/product/12.1.0/grid
End points:TCP:1529
Listener is enabled.
$ crsctl stat res -t -init
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE celvpint5012 STABLE
ora.LISTENER_DG.lsnr
ONLINE ONLINE celvpint5012 STABLE
Changes
The Listener has been configured manually and registered in HAS through srvctl ,the Listener configuration is as follows
+++++++++++++++
$cat listener.ora
# listener.ora Network Configuration File: /u01/app/grid/product/12.1.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.64.YYY.YYY)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/grid/product/12.1.0/grid)
(SID_NAME = +ASM)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /u01/app/grid/product/12.1.0/grid)
(SID_NAME = ORCL)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
REGISTRATION_INVITED_NODES_LISTENER=() # line added by Agent
LISTENER_DG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.64.YYY.YYY)(PORT = 1529))
)
)
)
SID_LIST_LISTENER_DG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/grid/product/12.1.0/grid)
(SID_NAME = orcl)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_DG=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_DG=SUBNET # line added by Agent
REGISTRATION_INVITED_NODES_LISTENER_DG=() # line added by Agent
This only happens if second listener LISTENER_DG is added to Oracle Restart
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |