My Oracle Support Banner

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 later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.