OGG错误集

Oracle Net Services 配置:

1. Xlib: connection to \Xlib: No protocol specified Error: null

解决: 切换到root用户执行一下：xhost local:oracle 将listener.ora和tnames.ora中带host改成ip

GGSCI (ogg1) 35> delete trandata test.demo

2. Database error 54 (ORA-00054: resource busy and acquire with NOWAIT specified, SQL ALTER TABLE \\ /* 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 inval id 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 \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 \ 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 available 13. 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

17. ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, treplcq.prm: Error mapping from XF_OGG_TEST.PRE_BUS_ITEMFACT_S to XF_OGG_TEST.PRE_BUS_ITEMFACT_S. 数据不一致

18. ERROR OGG-01028 Oracle GoldenGate Delivery for Oracle, treplcq.prm: Incompatible record in ./dirdat/CQ000067, rba 4779 (getting header). 19. ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, treplcq.prm: PROCESS ABENDING. 队列文件读取错误【discard文件详细信息】

20. SQL error 1403 mapping XF_OGG_TEST.PRE_BUS_ITEMFACT_S to XF_OGG_TEST.PRE_BUS_ITEMFACT_S. 数据不一致【discard文件详细信息】

21. ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, treplvj.prm: Bad column index (3) specified for table GGS.DEMO2, max columns = 3 表结构不一致

22. ERROR OGG-01044 Oracle GoldenGate Capture for Oracle, spumpbj.prm: The trail './dirdat/CQ' is not assigned to extract 'SPUMPBJ'. Assign the trail to the extract with the command \未添加所要投递队列的名称，或者添加错误

23. ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, spumpbj.prm: OCI Error during OCIServerAttach (status = 12514-ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).

24. GGSCI (ogg1) 16> add trandata mytest.demo; ERROR: No viable tables matched specification ogguser权限不足

25. ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory export LD_LIBRARY_PATH=$ORACLE_HOME/lib环境变量未引入 vi .bash_profile ---. .bash_profile source .bash_profile

26．ERROR 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.1]

Applies to:

Oracle GoldenGate - Version: 6.0.0 and later [Release: 6.0.0 and later ] Information in this document applies to any platform. Solution

Issue:

Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed

Solution 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 transaction

Solution 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.1] Applies to: Oracle GoldenGate - Version: 10.0.0.0 and later [Release: 10.0.0 and later ] Information in this document applies to any platform. Goal How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10) Solution This 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 RBA

here is from source side.

view source print?

01.GGSCI (RACD1.localdomain.com) 6> INFO RMTTRAIL * 02.

03.Extract Trail: ./dirdat/DE

04.Extract: RACDE 05.Seqno: 1 06.RBA: 1049

07.File Size: 10M 08.

09.Extract Trail: ./dirdat/DP 10.Extract: RACDP 11.Seqno: 0 12.RBA: 4499

13.File Size: 10M

some output from ggserr.log

1.2012-10-17 19:47:58 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT RACDP starting.

2.2012-10-17 19:47:58 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP starting.

3.2012-10-17 19:47:59 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP started.

4.2012-10-17 19:48:04 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, racdp.prm: Socket buffer size set to 27985 (flush size 27985).

5.--This is the error....

6.2012-10-17 19:48:04 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, racdp.prm: Failed to open target trail file ./dirdat/DP000000, at RBA 4499.

7.2012-10-17 19:48:04 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, racdp.prm: PROCESS ABENDING.

I had trailfile missing on Target side, which DATAPUMP was looking for.

view source print?

1.TEST:/u00/app/gghome/dirdat :TEST$ll 2.total 12

3.-rw-rw-rw- 1 oracle oinstall 1167 Aug 2 09:49 XP000000 4.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.localdomain.com) 11> ALTER EXTRACT RACDP ETROLLOVER 02.

03.2012-10-17 19:54:30 INFO OGG-01520 Rollover

performed. For each affected output trail of Version 10 or higher format,after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically. 04.EXTRACT altered. 05. 06.

07.GGSCI (RACD1.localdomain.com) 12> INFO RMTTRAIL * 08.

09.Extract Trail: ./dirdat/DE 10.Extract: RACDE 11.Seqno: 1 12.RBA: 1049

13.File Size: 10M 14.

15.Extract Trail: ./dirdat/DP 16.Extract: RACDP 17.Seqno: 1 18.RBA: 0

19.File Size: 10M 20. 21. 22.

23.GGSCI (RACD1.localdomain.com) 13> START RACDP 24.

25.Sending START request to MANAGER ... 26.EXTRACT RACDP starting 27. 28.

29.GGSCI (RACD1.localdomain.com) 14> info all 30.

31.Program Status Group Lag Time Since Chkpt 32.

33.MANAGER RUNNING

34.EXTRACT RUNNING RACDE 00:00:00 00:00:01 35.EXTRACT RUNNING RACDP 00:00:00 00:00:02 36. 37.

38.2012-10-17 19:55:20 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT RACDP starting.

39.2012-10-17 19:55:20 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP starting.

40.2012-10-17 19:55:31 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP started.

41.2012-10-17 19:55:39 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, racdp.prm: Socket buffer size set to 27985 (flush size 27985).

42.2012-10-17 19:55:40 INFO OGG-01052 Oracle GoldenGate

Capture for Oracle, racdp.prm: No recovery is required for target file ./dirdat/DP000001, at RBA 0 (file not opened).

43.2012-10-17 19:55:40 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, racdp.prm: Output file ./dirdat/DP is using 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). UPDATE\= :a2,

\

2013-04-25 07:59:50 WARNING OGG-01004 Aborted grouped transaction on'HX_FP.FP_PZHDXX', Database error 14402 (OCI Error ORA-14402: updatingpartition key column would cause a partition change (statu

s = 14402). UPDATE\\

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). U

PDATE\\

2013-04-25 07:59:50 WARNING OGG-01003 Repositioning to rba 355778 in seqno 83. Source Context :

SourceModule :[er.errors]

SourceID :[/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/app/er/errors.cpp]

SourceFunction :[take_rep_err_action(short, int32_t, const char *, extr_ptr_def *,std_rec_hdr_def *, char *, file_def *, bool)] SourceLine : [623]

2013-04-25 07:59:50 ERROR OGG-01296 Error mapping fromHX_FP.FP_PZHDXX to HX_FP.FP_PZHDXX.

WARNNING OGG-00869根据官方的 Error Reference 中的描述，专指OGG遇到了特定的数据库错误，可以忽略。 OGG-00869: {0}

Cause: 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 默认情况下处于禁用状态，从而导致报该错误。 [oracle@prod ~]$ oerr ora 14402

14402, 00000, \ // *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 355778 Reading forward from RBA 355778 Logdump 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.627

IOType : 15 (x0f) OrigNode : 255 (xff) TransInd : . (x00) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 950 AuditPos : 915048500 Continued : N (x00) RecCount : 1 (x01)

2013/04/24 20:33:00.010.627 FieldComp Len 91 RBA 355778 Name: HX_FP.FP_PZHDXX

After Image: Partition 4 G b

0000 0022 0000 4232 3742 3133 35354146 3646 3430 | ...\ 3945 3839 3145 3142 4238 4144 36383837 4438 000c | 9E891E1BB8AD6887D8.. 000d 0000 3135 3030 3931 3030 30303000 1000 1500 | ....15009100000..... 0032 3031 332d 3034 2d32 343a 32303a33 333a 3030 | .2013-04-24:20:33:00 0011 0007 0000 3135 3030 39 | ......15009 Column 0 (x0000), Len 34 (x0022) Column 12 (x000c), Len 13 (x000d) Column 16 (x0010), Len 21 (x0015) Column 17 (x0011), Len 7 (x0007)

执行的 update 语句为：

UPDATE HX_FP.FP_PZHDXX SET SWJG_DM = ‘15009100000’,XGRQ= ‘2013-04-24:20:33:00’,SJGSDQ= ‘15009’ WHERE HDQCUUID = ‘B27B1355AF6F409E891E1BB8AD6887D8’

其中SJGSDQ 正是HX_FP.FP_PZHDXX 表的分区键。

针对这种修改分区表分区键的操作导致的 replicat 进程挂起，metalink 上给出的建议为在应用设计时尽量避免这种操作，启用该表的 row movement便可临时解决这一问题。 SQL> alter table HX_FP.FP_PZHDXX enablerow movement; Table altered.

GGSCI (bjsczjdbzsj01) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING

JAGENT STOPPED

EXTRACT RUNNING EZJTS_TS 00:00:00 00:00:02 EXTRACT RUNNING PZJTS_TS 00:00:00 00:00:03 REPLICAT ABENDED RFP_ZJ3 00:00:00 12:21:37 REPLICAT RUNNING RFX_ZJ3 00:00:00 00:00:07 REPLICAT RUNNING RGZ_ZJ5 00:00:00 00:00:02 REPLICAT RUNNING RNSTS_ZJ 00:00:00 00:00:03 REPLICAT RUNNING RNS_ZJ2 00:00:00 00:00:01 REPLICAT RUNNING RSB_ZJ4 00:00:00 00:00:04 GGSCI (bjsczjdbzsj01) 3> start RFP_ZJ3 Sending START request to MANAGER ... REPLICAT RFP_ZJ3 starting GGSCI (bjsczjdbzsj01) 4> info all

Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT STOPPED

EXTRACT RUNNING EZJTS_TS 00:00:00 00:00:05 EXTRACT RUNNING PZJTS_TS 00:00:00 00:00:06 REPLICAT RUNNING RFP_ZJ3 00:00:00 00:00:00 REPLICAT RUNNING RFX_ZJ3 00:00:00 00:00:00 REPLICAT RUNNING RGZ_ZJ5 00:00:00 00:00:03 REPLICAT RUNNING RNSTS_ZJ 00:00:00 00:00:06 REPLICAT RUNNING RNS_ZJ2 00:00:00 00:00:09

本文来源：https://www.bwwdw.com/article/nhq6.html