合 报错“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 |