运用OGG同步异构数据库时OGG-01201、OGG-00936的异常处理

问题描述：运用OGG同步异构数据库时OGG-01201、OGG-00936的异常处理.
数据库：源端 oracle 19.13 目标端 mysql 8.0.27
ogg安装包：源端 213000_fbo_ggs_Linux_x64_Oracle_shiphome.zip 目标端 213000_ggs_Linux_x64_MySQL_64bit.zip

1、问题重现
oracle源端全量同步数据到mysql目标端启动OGG抽取进程时，出现OGG-00936、OGG-01201报错.

源端告警日志：
2024-08-07T11:11:45.258+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, ext0.prm: Using the following key columns for source table RPTUSER.FRUITS: F_ID.
2024-08-07T11:11:45.271+0800 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext0.prm: Extract group EXTRACT EXT0 started.
2024-08-07T11:11:45.299+0800 ERROR OGG-01201 Oracle GoldenGate Capture for Oracle, ext0.prm: Error reported by Manager: Access denied.
2024-08-07T11:11:45.299+0800 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext0.prm: PROCESS ABENDING.
2024-08-07T11:11:50.838+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info ext0 detail.

目标端告警日志：
2024-08-07 11:11:45 INFO OGG-00963 Command received from application EXTRACT on host [192.168.133.101]:36206: START REPLICAT REP0 CPU -1 PRI -1 PARAMS.

2024-08-07 11:11:45 WARNING OGG-00936 Access denied (request from 192.168.133.101, rule #0).

2、问题分析
目标端告警日志出现rule #0，表明没有rule规则.rule为mgr的一个属性，类似防火墙，表示是否允许远程访问，语法如下：

ACCESSRULE[, PROG program_name][, IPADDR address][, PRI rule][, login_ID]{, ALLOW | DENY}

3、解决方案
--目标端mgr进程添加如下参数
ACCESSRULE, PROG *,IPADDR *, ALLOW

说明：此后成功开启源端初始化抽取进程.