OGG错误集.doc

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, SQL 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: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. 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).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, 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, 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:31 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: 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.prm: 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 viable 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 retrieving 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 Release: 6.0.0 and later Information in this document applies to any platform.SolutionIssue:Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processedSolution Overview:This error occurs shortly after a transaction is written to the idle node but does not yet appear in the redo log when the current transaction is processed. This transaction will have a higher SCN than the previous transactionSolution Details:In an Oracle RAC environment, Extract has a coordinator thread. This thread assembles the operations that are generated on each of the RAC nodes into SCN order. Before starting to assemble the transactions, Extract waits for a short time after Oracle writes the transaction to the redo log. If a node has been idle with no transactions, Extract waits the number of milliseconds specified in the Extract parameter THREADOPTIONS MAXCOMMITPROPAGATIONDELAY (default 3 seconds). Waiting ensures that there are no new transactions on the idle node before writing the current transactions to the trail.How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10) ID 987379.1Applies to:Oracle GoldenGate - Version: and later Release: 10.0.0 and later Information in this document applies to any platform.GoalHow to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)SolutionThis applies for Oracle GoldenGate Version 10 and above only using Version 10 formatted trail and NOT using the RMTTRAIL or EXTTRAIL FORMAT RELEASE parameter.28 OGG-01496 Failed to open target trail file-投递进程My Datapump was abending after start, because It was looking for MISSING remote trailfile at perticular RBA , that trailfile was deleted.If you want to reposition extract please visit.Re-position Extract at particular RBAhere is from source side.view sourceprint?01.GGSCI (RACD1.) 6 INFO RMTTRAIL *02.03.Extract Trail: ./dirdat/DE04.Extract: RACDE05.Seqno: 106.RBA: 104907.FileSize: 10M08.09.Extract Trail: ./dirdat/DP10.Extract: RACDP11.Seqno: 012.RBA: 449913.FileSize: 10Msome output from ggserr.log1.2012-10-17 19:47:58 INFO OGG-00975 Oracle GoldenGate ManagerforOracle, mgr.prm: EXTRACT RACDP starting.2.2012-10-17 19:47:58 INFO OGG-00992 Oracle GoldenGate CaptureforOracle, racdp.prm: EXTRACT RACDP starting.3.2012-10-17 19:47:59 INFO OGG-00993 Oracle GoldenGate CaptureforOracle, racdp.prm: EXTRACT RACDP started.4.2012-10-17 19:48:04 INFO OGG-01226 Oracle GoldenGate CaptureforOracle, racdp.prm: Socket buffersizesetto27985 (flushsize27985).5.-This is the error.6.2012-10-17 19:48:04 ERROR OGG-01496 Oracle GoldenGate CaptureforOracle, racdp.prm: Failedtoopentarget trail file ./dirdat/DP000000,atRBA 4499.7.2012-10-17 19:48:04 ERROR OGG-01668 Oracle GoldenGate CaptureforOracle, racdp.prm: PROCESS ABENDING.I had trailfile missing on Target side, which DATAPUMP was looking for.view sourceprint?1.TEST:/u00/app/gghome/dirdat :TEST$ll2.total 123.-rw-rw-rw- 1 oracle oinstall 1167 Aug 2 09:49 XP0000004.drwxr-xr-x 14 oracle oinstall 4096 Oct 17 16:10 .5.drwxrwxr-x 2 oracle oinstall 4096 Oct 17 16:52 .So i did this below on Source side and start datapump successfully.GGSCI (RACD1.) 11ALTEREXTRACT RACDP ETROLLOVER02.03.2012-10-17 19:54:30 INFO OGG-01520 Rollover performed.Foreach affectedoutputtrailofVersion 10orhigher format,afterstarting the source extract, issueALTEREXTSEQNOforthat trails reader (either pump EXTRACT or REPLICAT) to move the readers scantothe new trail file; it willnothappen automatically.04.EXTRACT altered.05.06.07.GGSCI (RACD1.) 12 INFO RMTTRAIL *08.09.Extract Trail: ./dirdat/DE10.Extract: RACDE11.Seqno: 112.RBA: 104913.FileSize: 10M14.15.Extract Trail: ./dirdat/DP16.Extract: RACDP17.Seqno: 118.RBA: 019.FileSize: 10M3.GGSCI (RACD1.) 13 START RACDP24.25.Sending START requesttoMANAGER .26.EXTRACT RACDP starting27.28.29.GGSCI (RACD1.) 14 infoall30.31.Program StatusGroupLagTimeSince Chkpt32.33.MANAGER RUNNING34.EXTRACT RUNNING RACDE 00:00:00 00:00:0135.EXTRACT RUNNING RACDP 00:00:00 00:00:0012-10-17 19:55:20 INFO OGG-00975 Oracle GoldenGate ManagerforOracle, mgr.prm: EXTRACT RACDP starting.39.2012-10-17 19:55:20 INFO OGG-00992 Oracle GoldenGate CaptureforOracle, racdp.prm: EXTRACT RACDP starting.40.2012-10-17 19:55:31 INFO OGG-00993 Oracle GoldenGate CaptureforOracle, racdp.prm: EXTRACT RACDP started.41.2012-10-17 19:55:39 INFO OGG-01226 Oracle GoldenGate CaptureforOracle, racdp.prm: Socket buffersizesetto27985 (flushsize27985).42.2012-10-17 19:55:40 INFO OGG-01052 Oracle GoldenGate CaptureforOracle, racdp.prm:Norecoveryisrequiredfortarget file ./dirdat/DP000001,atRBA 0 (filenotopened).43.2012-10-17 19:55:40 INFO OGG-01478 Oracle GoldenGate CaptureforOracle, racdp.prm:Outputfile ./dirdat/DPisusing format RELEASE 10.4/11.1.29 Replicat 进程遇 OCI Error ORA-14402 错误解决办法生产环境发票管理库到总局主数据库 Replicat 进程因报如下错误 Abended：2013-04-25 07:59:50 WARNING OGG-00869 OCI Error ORA-14402: updating partition keycolumn would cause a partition change (status = 14402). UPDATEHX_FP.FP_PZHDXX SET SWJG_DM =:a1,XGRQ = :a2,SJGSDQ = :a3 WHEREHDQCUUID = :b0.2013-04-25 07:59:50 WARNING OGG-01004 Aborted grouped transaction onHX_FP.FP_PZHDXX, Database error 14402 (OCI Error ORA-14402: updatingpartition key column would cause a partition change (status = 14402). UPDATEHX_FP.FP_PZHDXX SET SWJG_DM = :a1,XGRQ= :a2,SJGSDQ = :a3 WHERE HDQCUUID = :b0).2013-04-25 07:59:50 WARNING OGG-01003 Repositioning to rba 355778 in seqno 83.2013-04-25 07:59:50 WARNING OGG-01154 SQL error 14402 mapping HX_FP.FP_PZHDXX toHX_FP.FP_PZHDXX OCI Error ORA-14402: updating partition key column would causea partition change (status = 14402). UPDATEHX_FP.FP_PZHDXX SET SWJG_DM =:a1,XGRQ = :a2,SJGSDQ = :a3 WHERE HDQCUUID= :b0.2013-04-25 07:59:50 WARNING OGG-01003 Repositioning to rba 355778 in seqno 83.Source Context :SourceModule :er.errorsSourceID :/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/app/er/errors.cppSourceFunction :take_rep_err_action(short, int32_t, const char *, extr_ptr_def *,std_rec_hdr_def *, char *, file_def *, bool) SourceLine : 6232013-04-25 07:59:50 ERROROGG-01296 Error mapping fromHX_FP.FP_PZHDXX to HX_FP.FP_PZHDXX.WARNNING OGG-00869根据官方的 Error Reference 中的描述，专指OGG遇到了特定的数据库错误，可以忽略。OGG-00869: 0Cause:The specified database error occurred, but can be ignored.Action:Contact Oracle Support only if a problem persists.但在本例中，replicat 进程遇到的数据库错误为OCI ErrorORA-14402: updating partition key column would cause a partition change，显然无法忽略。ORA-14402 错误一般是由于 update 操作更改了分区表的分区键的值触使该行迁移到其他的分区中。而表的 row movement 默认情况下处于禁用状态，从而导致报该错误。oracleprod $ oerr ora 1440214402, 00000, updating partition keycolumn would cause a partition change/ *Cause:An UPDATE statement attempted to change the value of a partition/key column causing migration of the row to another partition/ *Action: Do not attempt to update apartition key column or make sure that/the new partition key is within the range containing the old/partition key.Replicat 进程报错时正在修改的记录为：Logdump 7 pos 355778Reading forward from RBA 355778Logdump 8 n_Hdr-Ind : E(x45) Partition :. (x04)UndoFlag : .(x00) BeforeAfter: A(x41)RecLength : 91(x005b) IO Time : 2013/04/24 20:33:00.010.627IOType : 15(x0f) OrigNode :255 (xff)TransInd : .(x00) FormatType : R(x52)SyskeyLen : 0(x00) Incomplete : .(x00)AuditRBA : 950 AuditPos : 915048500Continued : N(x00) RecCount :1 (x01)2013/04/24 20:33:00.010.627 FieldComp Len 91 RBA 355778Name: HX_FP.FP_PZHDXXAfter Image:Partition 4 G b0000 0022 0000 4232 3742 3133 35354146 3646 3430 | .B27B1355AF6F403945 3839 3145 3142 4238 4144 36383837 4438 000c | 9E891E1BB8AD6887D8.000d 0000 3135 3030 3931 3030 30303000 1000 1500 | 0032 3031 332d 3034 2d32 343a 32303a33 333a 3030 | .2013-04-24:20:33:000011 0007 0000 3135 3030 39 | .15009Column 0 (x0000), Len 34 (x0022)Column 12 (x000c), Len 13 (x000d)Column 16 (x0010), Len 21 (x0015)Column 17 (x0011), Len 7 (x0007)执行