【Oracle】GoldenGate 12.2 OGG-01201 Error reported by MGR : Access denied.
来源:互联网 发布:剑桥美国经济史知乎 编辑:程序博客网 时间:2024/05/20 11:47
前几天做oracle到mysql的数据初始化使用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拒绝连接。
查看目标端mgr的report,看到以下内容:
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】GoldenGate 12.2 OGG-01201 Error reported by MGR : Access denied.
- 【Oracle】GoldenGate 12.2 OGG-01201 Error reported by MGR : Access denied.
- 【GoldenGate】 OGG-01201 Error reported by MGR : Access denied.
- oracle goldengate error ogg-00664
- 【Oracle】GoldenGate 12.2 OGG-06591 OGG-01031
- [Oracle数据库] 【GoldenGate】ERROR OGG-00446 ,ERROR OGG-01668
- goldengate ERROR OGG-00446
- goldengate ERROR OGG-01172
- Oracle goldengate搭建ogg
- Oracle--ogg(goldengate)
- Oracle Goldengate For Mysql 复制进程错误ERROR OGG-00768
- Extract Abends with ERROR OGG-01733 Oracle GoldenGate Capture
- Oracle GoldenGate EXTRACT/REPLICAT/MGR parameter Example
- Oracle GoldenGate 11.2 OGG-01168
- OGG(ORACLE GOLDENGATE)使用手册
- Oracle GoldenGate OGG管理员手册
- OGG(ORACLE GOLDENGATE)使用手册
- ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, capture.prm: (capture
- Longest Increasing Subsequence 最长递增子序列
- Maven pom常用配置解析表
- matlab在循环中保存图片命名不重复
- C# 文件转字节数组 byte[]
- android-----XUtils框架之BitmapUtils源码分析
- 【Oracle】GoldenGate 12.2 OGG-01201 Error reported by MGR : Access denied.
- 广东海洋大学 电子1151 孔yanfei python语言程序设计 第六周
- 扛得住双11的Mysql---操作系统
- Math.ceil() 、Math.floor() 、Math.round() 三个函数的理解
- Mysql 存储过程 处理批量插入具有一定特点的数据
- 正则表达式详解
- ubuntu 14.04.4 install
- 翻译 SystemClock类
- 写在最初