OGG錯(cuò)誤集.docx

Oracle Net Services 配置:1. Xlib: connection to :0.0 refused by serverXlib: No protocol specifiedError: null解決: 切換到root用戶執(zhí)行一下：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.表結(jié)構(gòu)不一致原因4. Switching to next trail file ./dirdat/VJ000045 at 2013-09-05 14:23:54 due to EOF, with current RBA 2245 隊(duì)列文件捕捉錯(cuò)誤5. 2013-09-05 14:23:54 INFO OGG-01020 Processed extract process RESTART_ABEND record at seq 45, rba 1989 (aborted 0 records).隊(duì)列文件錯(cuò)誤6. 2013-09-09 14:07:15 ERROR OGG-01028 Incompatible record (logical EOF) in ./dirdat/VB000010, rba 1469.隊(duì)列文件出錯(cuò)，隊(duì)列文件絮亂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.編碼雙引號(hào)為中文狀態(tài)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.數(shù)據(jù)庫歸檔丟失10. 2013-09-15 09:48:37 ERROR OGG-00360 WHERE cannot be used with PASSTHRU.過濾條件有where不能用passthru修改ogg配置參數(shù)過后必須要從新啟動(dòng)該進(jìn)程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.進(jìn)程名稱不一致，和添加遠(yuǎn)程隊(duì)列不一致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數(shù)據(jù)庫實(shí)例為啟動(dòng)14. ERROR OGG-00014 Oracle GoldenGate Delivery for Oracle, treplbj.prm: Unrecognized parameter: EPLICAT. Parameter could be misspelled or unsupported.參數(shù)錯(cuò)誤15. ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, treplcq.prm: Table XF_OGG_TEST.ECP_CONPERF_RECEIVED does not exist in target database.不存在這個(gè)表，參數(shù)錯(cuò)誤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權(quán)限不足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環(huán)境變量未引入vi .bash_profile -. .bash_profile source .bash_profile26ERROR OGG-00868 no data found retrieving if to ignore this object 異構(gòu)文件生成過程中報(bào)錯(cuò)。用戶下面沒有某張表。表所在用戶填寫錯(cuò)誤。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-投遞進(jìn)程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 進(jìn)程遇 OCI Error ORA-14402 錯(cuò)誤解決辦法生產(chǎn)環(huán)境發(fā)票管理庫到總局主數(shù)據(jù)庫 Replicat 進(jìn)程因報(bào)如下錯(cuò)誤 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根據(jù)官方的 Error Reference 中的描述，專指OGG遇到了特定的數(shù)據(jù)庫錯(cuò)誤，可以忽略。OGG-00869: 0Cause:The specified database error occurred, but can be ignored.Action:Contact Oracle Support only if a problem persists.但在本例中，replicat 進(jìn)程遇到的數(shù)據(jù)庫錯(cuò)誤為OCI ErrorORA-14402: updating partition key column would cause a partition change，顯然無法忽略。ORA-14402 錯(cuò)誤一般是由于 update 操作更改了分區(qū)表的分區(qū)鍵的值觸使該行遷移到其他的分區(qū)中。而表的 row movement 默認(rèn)情況下處于禁用狀態(tài)，從而導(dǎo)致報(bào)該錯(cuò)誤。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 進(jìn)程報(bào)錯(cuò)時(shí)正在修改的記錄為：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)執(zhí)行