Oracle GoldenGate OGG 报错汇总（转）

1、IP限制因其的目标端拒绝源端进程

源端告警：view report ext_1

ERROR OGG-01201 Error reported by MGR : Access denied.
ERROR OGG-01668 PROCESS ABENDING.

目标端告警: view report mgr

INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [106.3..]:46817 (START REPLICAT REPINIT CPU -1 PRI -1 PARAMS ).
WARNING OGG-00936 Oracle GoldenGate Manager for Oracle, mgr.prm: Access denied (request from 172.41.176.102, rule #0).

解决：

可以看到是目标端mgr主动拒绝了源端extract启动replicat进程repinit。
后进过查询资料，这是由于GoldenGate 12.2的新特性导致的，要想可以通过远程启动目标端的replicat进程，需要在mgr配置文件中增加参数如下：
执行

GGSCI (custom04) 3> EDIT PARAMS MGR

添加

ACCESSRULE, PROG *, IPADDR 172.41.176.102 ALLOW

注意：IPADDR 后面IP是根绝Report mgr 面的IP填写

2、命令“MAP”未以分号结尾

源端告警：view report ext_1

ERROR OGG-00396 Command "MAP" not terminated by semi-colon

解决：

在目标服务器执行下面语句：

GGSCI (custom04) 3> EDIT PARAMS RINI_1

修改MAP命令，最后添加一个分号;

MAP marvin.*,TARGET mvschema. *;

3、无法打开检查点文件

源端警告 ：view report ext_1

WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, eini_1.prm: EXTRACT task RINI_1 abended : Could not open checkpoint file /home/oracle/ogg/ogg/dirchk/RINI_1.cpr, mode 1 (error 2, No such file or directory).

目标报错：

ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rini_1.prm: Could not open checkpoint file /home/oracle/ogg/ogg/dirchk/RINI_1.cpr, mode 1 (error 2, No such file or directory).

解决：

在目标服务器执行下面语句：

GGSCI (custom04) 3> add replicat RINI_1,specialrun

4、数据库操作失败：无法连接到 ODBC

源端警告 ：view report ext_1

OGG-01194 EXTRACT task RINI_1 abended : Database operation failed: Couldn't connect to EMP. ODBC error: SQLSTATE IM002 native

解决：在目标服务器执行如下语句

GGSCI (custom04) 3> EDIT PARAMS RINI_1

修改TARGETDB 为ODBC的连接字符串名称

 

image.png

将原配置

TARGETDB EMP USERID sa, PASSWORD sa123456

修改为

TARGETDB Oracle USERID sa, PASSWORD sa123456

5、目标端未有同样表结构的数据表存在，导致无法进行数据同步

利用OGG进程数据初始化源端警告：view report ext_1

OGG-01194 EXTRACT task RINI_1 abended : Table mvschema.MARVIN does not exist in target database

原因：是由于目标端未有同样表结构的数据表存在，导致无法进行数据同步

解决：

1、源端获取建表DDL

SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
set long 999999
SET PAGESIZE 1000
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);
SELECT DBMS_METADATA.GET_DDL('TABLE','MARVIN','MARVIN') FROM DUAL; DBMS_METADATA.GET_DDL('TABLE','EMP_OGG','SCOTT') -------------------------------------------------------------------------------- CREATE TABLE "SCOTT"."EMP_OGG" ( "EMPNO" NUMBER(4,0), "ENAME" VARCHAR2(10), "JOB" VARCHAR2(9), "MGR" NUMBER(4,0), "HIREDATE" DATE, "SAL" NUMBER(7,2), "COMM" NUMBER(7,2), "DEPTNO" NUMBER(2,0), CONSTRAINT "PK_EMPNO_OGG" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE "JWT" ENABLE, SUPPLEMENTAL LOG GROUP "GGS_102724" ("EMPNO") ALWAYS, SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS, SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "JWT" 

2、在目标端服务器数据库的SC