合 报错“OGG-01201:Error reported by MGR : Access denied”
现象
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添加参数:
1 2 3 4 5 6 7 | ACCESSRULE,PROG *,IPADDR 10.40.30.98,ALLOW -- 或 edit params mgr port 7809 ACCESSRULE, PROG *, IPADDR *, ALLOW |
参考
Doc ID 2098284.1
MGR report shows "WARNING OGG-01877 Missing explicit accessrule for server collector" or "WARNING OGG-00936 Access denied (request from
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.