GoldenGate 12.3 初始化提示时 OGG-01201 Error reported by MGR : Access denied.

最新推荐文章于 2024-07-18 02:11:33 发布

Leo-2016

最新推荐文章于 2024-07-18 02:11:33 发布

阅读量883

点赞数

分类专栏： GoldenGate

本文链接：https://blog.csdn.net/leo__1990/article/details/92765698

版权

GoldenGate 专栏收录该内容

23 篇文章 5 订阅

订阅专栏

描述：

Ogg 启动初始化进程，report 初始化进程提示OGG-01201 Error reported by MGR : Access denied.：

GGSCI (cndba) 33> start extinit

Sending START request to MANAGER ...
EXTRACT EXTINIT starting

GGSCI (cndba) 34> view report extinit
...
Source Context :
  SourceModule            : [er.idlx]
  SourceID                : [/scratch/aime/adestore/views/aime_adc4150313/oggcore/OpenSys/src/app/er/idlx.c]
  SourceMethod            : [idlx_get_port_from_remote_mgr]
  SourceLine              : [1468]
  ThreadBacktrace         : [14] elements
                          : [/u01/app/oracle/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f15aa9c293e]]
                          : [/u01/app/oracle/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x16e) [0x7f15aa9b671e]]
                          : [/u01/app/oracle/ogg/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition)+0x89) [0x7f15aa9b21e9]]
                          : [/u01/app/oracle/ogg/extract(IDLX_tcp_send_data+0x874) [0x59d9e8]]
                          : [/u01/app/oracle/ogg/extract(IDLX_send_session_begin_cmd+0x7c) [0x59dd6b]]
                          : [/u01/app/oracle/ogg/extract(ggs::er::DatabaseDataSource::processSourceTables()+0x182) [0x600888]]
                          : [/u01/app/oracle/ogg/extract(ggs::er::OraDatabaseDataSource::processSourceTables()+0x6) [0x5ff488]]
                          : [/u01/app/oracle/ogg/extract() [0x616121]]
                          : [/u01/app/oracle/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x71) [0x710111]]
                          : [/u01/app/oracle/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14c) [0x70f82c]]
                          : [/u01/app/oracle/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb5) [0x710085]]
                          : [/u01/app/oracle/ogg/extract(main+0x3b) [0x6173eb]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3139c1ed1d]]
                          : [/u01/app/oracle/ogg/extract(__gxx_personality_v0+0x489) [0x582169]]

2017-10-22 22:21:09  ERROR   OGG-01201  Error reported by MGR : Access denied.

2017-10-22 22:21:09  ERROR   OGG-01668  PROCESS ABENDING.

查看目标端mgr的report，看到以下内容：

2017-10-20T06:26:18.120+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host [192.168.1.61]:63008 (START REPLICAT repinit CPU -1 PRI -1 PARAMS ).
2017-10-20T06:26:18.120+0800  WARNING OGG-00936  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access denied (request from 192.168.1.61, rule #0).

解决方法：

可以看到是目标端mgr主动拒绝了源端extract启动replicat进程repinit。
查询资料metalink 2098284.1，2095174.1，这是由于GoldenGate 12.2的新特性导致的，要想可以通过远程启动目标端的replicat进程，
添加以下目标端MGR参数文件解决了这个问题
ACCESSRULE, PROG *, IPADDR <ip address>, ALLOW
ACCESSRULE, PROG *, IPADDR 192.168.1.61, ALLOW

<ip address> 是MGR报告文件中看到的ip.
之后再从源端启动exitinit进程，这次成功启动，进程状态正常，数据初始化成功。