My Oracle Support Banner

incorrect listener_networks in ODA 19.5 (Doc ID 2662005.1)

Last updated on APRIL 27, 2020

Applies to:

Oracle Database Appliance Software - Version 18.1 and later
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
----




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



* 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
-----



*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


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