Oracle+ogg-00664,OGG错误集.docx

OGG错误集

Oracle Net Services 配置: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.demoDatabase error 54 (ORA-00054: resource busy and acquire with NOWAIT specified, SQL ALTER TABLE "TEST"."DEMO" DROP SUPPLEMENTAL LOG GROUP "GGS_DEMO_48269" /* GOLDENGATE_DDL_REPLICATION */).解决：清楚对demo表的占用即可2013-09-05 09:50:54 ERROR OGG-01161 Bad column index (3) specified for table GGS.DEMO2, max columns = 3.表结构不一致原因Switching to next trail file ./dirdat/VJ000045 at 2013-09-05 14:23:54 due to EOF, with current RBA 2245队列文件捕捉错误2013-09-05 14:23:54 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 45, rba 1989 (aborted 0 records).队列文件错误2013-09-09 14:07:15 ERROR OGG-01028 Incompatible record (logical EOF) in ./dirdat/VB000010, rba 1469.队列文件出错，队列文件絮乱2013-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).2013-09-10 12:56:47 ERROR OGG-01668 PROCESS ABENDING.编码双引号为中文状态2013-10-14 09:16:04 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extbam.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 initial position for sequence 36623, rba2013-10-14 09:16:04 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extbam.prm: PROCESS ABENDING.数据库归档丢失2013-09-15 09:48:37 ERROR OGG-00360 WHERE cannot be used with PASSTHRU.过滤条件有where不能用passthru修改ogg配置参数过后必须要从新启动该进程2013-09-16 22:58:31 ERROR OGG-00446 Unable to lock file "/ogghome/dirchk/SPUMPC