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指明同步的列，列名使用""括起來。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/429786/viewspace-1265732/，如需轉載，請註明出處，否則將追究法律責任。