报错“OGG-01201:Error reported by MGR : Access denied”

0    308    1

Tags:

👉 本文共约984个字,系统预计阅读时间或需4分钟。

现象

ERROR OGG-01201 Error reported by Manager: Access denied.
OGG-01201:Error reported by MGR : Access denied

CAUSE: Command received from EXTRACT on host [10.40.30.98]:64316 (START REPLICAT DINIT CPU -1 PRI -1 PARAMS ).
目标端mgr主动拒绝源端初始化进程sinit启动replicat初始化进程dinit

解决

查询资料metalink 2098284.1,2095174.1,这是由于GoldenGate 12.2的新特性导致的,要想可以通过远程启动目标端的replicat进程,目标端mgr添加参数:

参考

Doc ID 2098284.1

MGR report shows "WARNING OGG-01877 Missing explicit accessrule for server collector" or "WARNING OGG-00936 Access denied (request from , rule #0)." (Doc ID 2098284.1)
SYMPTOMS
Source extract abends trying to reach the target mgr with following message

eg.,

Oracle GoldenGate Capture for SQL Server
Version 12.2.0.1.0 OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2
Windows x64 (optimized), Microsoft SQL Server on Nov 10 2015 22:49:02

2016-01-06 13:00:49 ERROR OGG-01201 Error reported by MGR : Access denied.
2016-01-06 13:00:49 ERROR OGG-01668 PROCESS ABENDING.

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信dbaup66,谢谢!
AiDBA后续精彩内容已被站长无情隐藏,请输入验证码解锁本文!
验证码:
获取验证码: 请先关注本站微信公众号,然后回复“验证码”,获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。

标签:

Avatar photo

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复