My Oracle Support Banner

ODA 19.5 にて不適切な listener_networks (Doc ID 2668040.1)

Last updated on MAY 07, 2020

適用範囲:

Oracle Database Appliance Software - バージョン 18.1 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

ODA 19.5 でデプロイ後、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
----



DB のアラートログからは、LISTENER_NETWORKS パラメータで node1 と node2 の IP アドレスが LOCAL_LISTENER に設定されています。

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 はリモートノードの IP を指定しません。

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



* 17:06 付近で "alter system set listener_networks" のログはありません。

 

変更点

ODA 19.5 でデプロイ

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


本書の内容
現象
変更点
原因
解決策
参照情報

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