问题描述：运用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

说明：此后成功开启源端初始化抽取进程.
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.
  • 18.
  • 19.
  • 20.
  • 21.
  • 22.
  • 23.
  • 24.
  • 25.
  • 26.
  • 27.
  • 28.
  • 29.