incorrect listener_networks in ODA 19.5
(Doc ID 2662005.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database Appliance Software - Version 18.3.0.0.0 ODAVP and laterOracle Net Services - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.
Symptoms
After the deployment for ODA 19.5,following message is repeated in listener.log
listener.log
----
23-MAR-2020 09:26:59 *
(ADDRESS=(PROTOCOL=tcp)(HOST=<IP1>)(PORT=<PORT1>)) * service_register *
TMCDB2 * 1184
TNS-01184: Listener rejected registration or update of service handler
"DEDICATED"
TNS-01185: Registration attempted from a remote node
----
----
23-MAR-2020 09:26:59 *
(ADDRESS=(PROTOCOL=tcp)(HOST=<IP1>)(PORT=<PORT1>)) * service_register *
TMCDB2 * 1184
TNS-01184: Listener rejected registration or update of service handler
"DEDICATED"
TNS-01185: Registration attempted from a remote node
----
From alert log for DB,LOCAL_LISTENER set with both node1 and node2 IP address in LISTENER_NETWORKS parameter
alert_<SID1>.log
-----
2020-03-19T17:06:12.609632+09:00
ALTER SYSTEM SET listener_networks='' SCOPE=BOTH;
2020-03-19T17:06:12.617973+09:00
ALTER SYSTEM SET local_listener='-oracle-none-' SCOPE=BOTH;
2020-03-19T17:06:12.629496+09:00
ALTER SYSTEM SET remote_listener='' SCOPE=BOTH;
2020-03-19T17:06:18.067421+09:00
ALTER SYSTEM SET
listener_networks='((NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL <--*
=TCP)(HOST=<IP2 for node1>)(PORT=1521)))))','((NAME=net1)(LOCAL_LISTENER=(DESCRIPTI <--*
ON=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP3 for node2>)(PORT=1521)))))','((NAME=net1)(REMO <--*
TE_LISTENER=<SCAN_NAME>:1521))' SCOPE=BOTH;
2020-03-19T17:06:20.283418+09:00
ALTER SYSTEM SET local_listener='-oracle-none-' SCOPE=BOTH;
2020-03-19T17:06:20.291218+09:00
ALTER SYSTEM SET remote_listener='' SCOPE=BOTH;
2020-03-19T17:15:17.496398+09:00
----
-----
2020-03-19T17:06:12.609632+09:00
ALTER SYSTEM SET listener_networks='' SCOPE=BOTH;
2020-03-19T17:06:12.617973+09:00
ALTER SYSTEM SET local_listener='-oracle-none-' SCOPE=BOTH;
2020-03-19T17:06:12.629496+09:00
ALTER SYSTEM SET remote_listener='' SCOPE=BOTH;
2020-03-19T17:06:18.067421+09:00
ALTER SYSTEM SET
listener_networks='((NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL <--*
=TCP)(HOST=<IP2 for node1>)(PORT=1521)))))','((NAME=net1)(LOCAL_LISTENER=(DESCRIPTI <--*
ON=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP3 for node2>)(PORT=1521)))))','((NAME=net1)(REMO <--*
TE_LISTENER=<SCAN_NAME>:1521))' SCOPE=BOTH;
2020-03-19T17:06:20.283418+09:00
ALTER SYSTEM SET local_listener='-oracle-none-' SCOPE=BOTH;
2020-03-19T17:06:20.291218+09:00
ALTER SYSTEM SET remote_listener='' SCOPE=BOTH;
2020-03-19T17:15:17.496398+09:00
----
* LOCAL_LISTENER usually does not specify the IP of the remote node.
crsd_oraagent_oracle.trc
-----
2020-03-19 17:06:00.845 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:02.435 : AGFW:740456192: [ INFO] {1:50426:4418} Agent received the message: AGENT_HB[Engine] ID 12293:13366
2020-03-19 17:06:05.846 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:10.846 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:15.846 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:20.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:25.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:30.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:32.435 : AGFW:740456192: [ INFO] {1:50426:4418} Agent received the message: AGENT_HB[Engine] ID 12293:13768
2020-03-19 17:06:35.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:40.848 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:45.848 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:50.848 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:55.849 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
-----
-----
2020-03-19 17:06:00.845 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:02.435 : AGFW:740456192: [ INFO] {1:50426:4418} Agent received the message: AGENT_HB[Engine] ID 12293:13366
2020-03-19 17:06:05.846 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:10.846 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:15.846 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:20.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:25.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:30.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:32.435 : AGFW:740456192: [ INFO] {1:50426:4418} Agent received the message: AGENT_HB[Engine] ID 12293:13768
2020-03-19 17:06:35.847 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:40.848 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:45.848 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:50.848 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
2020-03-19 17:06:55.849 : USRTHRD:100964096: [ INFO] {1:50426:4418} Thread:DedicatedThread DbAgent::DedicatedThread::run 380 m_stopnow:0 m_restart:0 setLsnrs:0 m_pConnxn:0x7f5ae40009d0
-----
*There is no log "alter system set listener_networks" at around 17:06.
Changes
Just Deploying on ODA 19.5
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 |
| References |