【Oracle】GoldenGate 12.2 OGG-01201 Error reported by MGR : Access denied.

前端之家收集整理的这篇文章主要介绍了【Oracle】GoldenGate 12.2 OGG-01201 Error reported by MGR : Access denied.前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

前几天做oracleMysqL的数据初始化使用GoldenGate 12.2版本,在源端启动initload进程时报错如下:

Source Context :

SourceModule : [er.idlx]

SourceID : [/scratch/aime/adestore/views/aime_adc4150378/oggcore/OpenSys/src/app/er/idlx.c]

SourceFunction : [idlx_get_port_from_remote_mgr]

SourceLine : [1443]

ThreadBacktrace : [13] elements

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f9f09b93f8b]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*,unsigned int,...)+0x134) [0x7f9f09b8e114]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/libgglog.so(_MSG_ERR_IDLX_MGR_ERROR(CSourceContext*,char const*,CMessageFactory::MessageDisposition)+0x30) [0x7f9f09b70c87]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(IDLX_tcp_send_data+0x61d) [0x595c81]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(IDLX_send_session_begin_cmd+0xc0) [0x596057]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(ggs::er::DatabaseDataSource::processSourceTables()+0xfe) [0x5ee2de]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract() [0x5f3d04]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d0400]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d15ed]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(ggs::gglib::MultiThreading::MainThread::Run(int,char**)+0xb1) [0x6d16d1]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract(main+0x3b) [0x5f4feb]]

: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x387ae1ed5d]]

: [/u01/app/oracle/product/12.2.0.1.0/gghome_1/extract() [0x5630f9]]

2016-06-15 14:20:00 ERROR OGG-01201 Error reported by MGR : Access denied.

2016-06-15 14:20:00 ERROR OGG-01668 PROCESS ABENDING.

看报错是提示被目标端mgr拒绝连接。

查看目标端mgrreport,看到以下内容

2016-06-15 14:20:00 INFO OGG-00963 Oracle GoldenGate Manager for Oracle,mgr.prm: Command received from EXTRACT on host [106.3.*.*]:46817 (START REPLICAT REPINIT cpu -1 PRI -1 PARAMS ).

2016-06-15 14:20:00 WARNING OGG-00936 Oracle GoldenGate Manager for Oracle,mgr.prm: Access denied (request from 106.3.*.*,rule #0).

可以看到是目标端mgr主动拒绝了源端extract启动replicat进程repinit

后进过查询资料,这是由于GoldenGate 12.2的新特性导致的,要想可以通过远程启动目标端的replicat进程,需要在mgr增加参数如下:

ACCESSRULE,PROG *,IPADDR 106.3.*.*,ALLOW

之后再从源端启动initload进程,这次成功启动,进程状态正常。

猜你在找的Oracle相关文章