GoldenGate常见问题及处理

1、ERROR   OGG-00665  OCI Error creating temporary LOB to retrieve default LOB chunk size (status = 25153-ORA-25153: Temporary Tablespace is Empty), SQL.

重建数据库控制文件后，忘记添加临时表空间文件。
添加临时表空间文件即可。
alter tablespace temp01 add tempfile '/u01/app/oracle/oradata/temp01.dbf' size 100m reuse;

2、ERROR   OGG-00730  No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not in first row piece.

需要同步的表或数据库未启用supplemental logging
alter database add supplemental log data;
alter database add supplemental log data(primary key,unique,foreign key) columns;

3、ERROR   OGG-01044  The trail '/u01/app/ogg/dirdat/dg' is not assigned to extract 'DGRAC'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL /u01/app/ogg/dirdat/dg, EXTRACT DGRAC".

trail文件未指定extract进程
add exttrail /u01/app/ogg/dirdat/dg, EXTRACT DGRAC

4、OGG-00199  Table scott.SQLLDR does not exist in target database.

目标库不存在同步的表，配置DDL或者在目标库建立相同的表。

5、ERROR   OGG-00664  OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

数据库或监听未启动，或者无法连接到指定的数据库。

6、ERROR   OGG-00037  DEFSFILE file /u01/app/ogg/dirdef/emp.def already exists.

表结构定义文件已存在，删除后再创建。

7、ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption ke
ys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/u0
1/app/ogg/dirdat/rl000003" (error 11, Resource temporarily unavailable)).

源数据库与目标数据库的加密定义不一致，或目标端未定义。

8、WARNING OGG-01753  Cannot unregister EXTRACT PUMP1 from database because no database login was provided. You can manually unregister this roup later with the UNREGISTER EXTRACT command with LOGRETENTION. Issue DBLOGIN first.Deleted EXTRACT PUMP1.

由于未登录到数据库，无法删除。

9、ERROR   OGG-00919  Error in COLMAP clause.

源数据库与目标数据库表字段名不一致时，需要使用COLMAP指明同步的列，列名使用""括起来。