《OGG错误集》由会员分享，可在线阅读，更多相关《OGG错误集（12页珍藏版）》请在金锄头文库上搜索。
1、Oracle Net Services 配置:1. Xlib: connection to :0.0 refused by serverXlib: No protocol specifiedError: null解决: 切换到root用户执行一下：xhost local:oracle将listener.ora和tnames.ora中带host改成ipGGSCI (ogg1) 35 delete trandata test.demo2. Database error 54 (ORA-00054: resource busy and acquire with NOWAIT specified, S
2、QL ALTER TABLE TEST.DEMO DROP SUPPLEMENTAL LOG GROUP GGS_DEMO_48269 /* GOLDENGATE_DDL_REPLICATION */).解决：清楚对demo表的占用即可3. 2013-09-05 09:50:54 ERROR OGG-01161 Bad column index (3) specified for table GGS.DEMO2, max columns = 3.表结构不一致原因4. Switching to next trail file ./dirdat/VJ000045 at 2013-09-05 14:
3、23:54 due to EOF, with current RBA 2245 队列文件捕捉错误5. 2013-09-05 14:23:54 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 45, rba 1989 (aborted 0 records).队列文件错误6. 2013-09-09 14:07:15 ERROR OGG-01028 Incompatible record (logical EOF) in ./dirdat/VB000010, rba 1469.队列文件出错，队列文件絮乱7. 2
4、013-09-10 12:56:47 ERROR OGG-00664 OCI Error beginning session (status = 12705-ORA-12705: Cannot access NLS data files or invalid environment specified).8. 2013-09-10 12:56:47 ERROR OGG-01668 PROCESS ABENDING.编码双引号为中文状态9. 2013-10-14 09:16:04 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extb
5、am.prm: Getting attributes for ASM file +dcods/yyjc/archivelog/2_36623_810668564.dbf, SQL : (15056) ORA-15056: additional error message ORA-15173: entry 2_36623_810668564.dbf does not exist in directory archivelog ORA-06512: at SYS.X$DBMS_DISKGROUP, line 201 ORA-06512: at line 1Not able to establish
6、 initial position for sequence 36623, rba 28767248.2013-10-14 09:16:04 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extbam.prm: PROCESS ABENDING.数据库归档丢失10. 2013-09-15 09:48:37 ERROR OGG-00360 WHERE cannot be used with PASSTHRU.过滤条件有where不能用passthru修改ogg配置参数过后必须要从新启动该进程11. 2013-09-16 22:58:3
7、1 ERROR OGG-00446 Unable to lock file /ogghome/dirchk/SPUMPCQ.cpe (error 11, Resource temporarily unavailabl Lock currently held by process id (PID) 2562. ERROR OGG-01668 PROCESS ABENDING.进程名称不一致，和添加远程队列不一致12. 2013-09-25 09:50:23 ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034:
8、ORACLE not available13. ORA-27101: shared memory realm does not exist数据库实例为启动14. ERROR OGG-00014 Oracle GoldenGate Delivery for Oracle, treplbj.prm: Unrecognized parameter: EPLICAT. Parameter could be misspelled or unsupported.参数错误15. ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, treplcq.pr
9、m: Table XF_OGG_TEST.ECP_CONPERF_RECEIVED does not exist in target database.不存在这个表，参数错误16. WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, treplcq.prm: OCI Error ORA-00001: unique constraint (XF_OGG_TEST.PK_PRE_BUS_ITEMFACT_S) violated (status = 1), SQL add trandata mytest.demo;ERROR: No vi
10、able tables matched specificationogguser权限不足25. ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directoryexport LD_LIBRARY_PATH=$ORACLE_HOME/lib环境变量未引入vi .bash_profile -. .bash_profile source .bash_profile26ERROR OGG-00868 no data found ret
11、rieving if to ignore this object 异构文件生成过程中报错。用户下面没有某张表。表所在用户填写错误。27. OGG-01028 encountered commit SCN 0.234946815 (234946815) that is not greater thanthe highest SCN already processed 0.234946819解决办法:Document searched :OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed ID 957112.1Applies to:Oracle GoldenGate - Version: 6.0.0 and later
