This discussion is archived
1 Reply Latest reply: Apr 24, 2013 9:39 PM by Rc-oracle RSS

Getting ORA-0600 internal error code, arguments: [kdlx_logmnr_decompress

926611 Newbie
Currently Being Moderated
Hi,

We are getting this error for the capture process:
ORA-00600: internal error code, arguments: [kdlx_logmnr_decompress : incorrect unit length passed], [16120], [6225], [0], [22044], [], [], [], [], [], [], []
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process

That is aborting capture queue whenever we restart. I tried by re-installing Oracle but after sometime again this issue arises.
I am new to replication thing, so don't have too much idea about this error. Following is trace file log of the error :

*** 2013-02-06 17:04:07.311
ORA-00600: internal error code, arguments: [kdlx_logmnr_decompress : incorrect unit length passed], [16120], [6225], [0], [22044], [], [], [], [], [], [], []


*** 2013-02-06 17:04:51.995

*** 2013-02-06 17:04:52.033
Begin knlcDumpCapCtx:*******************************************
Error 600 : ORA-00600: internal error code, arguments: [kdlx_logmnr_decompress : incorrect unit length passed], [16120], [6225], [0], [22044], [], [], [], [], [], [], []

Capture Name: GENEVA1$CAP : Instantiation#: 2

*** 2013-02-06 17:04:52.033
++++ Begin KNST dump for Sid: 1059 Serial#: 171
Init Time: 01/31/2013 14:55:49
++++Begin KNSTCAP dump for : GENEVA1$CAP
Capture#: 1 Logminer_Id: 1 State: CREATING LCR [ 02/06/2013 17:04:06]
Capture_Message_Number: 0x0000.045b8dd0 [73108944]
Capture_Message_Create_Time: 02/06/2013 17:04:05
Enqueue_Message_Number: 0x0000.045b8dc8 [73108936]
Enqueue_Message_Create_Time: 02/06/2013 17:04:05
Total_Messages_Captured: 4544100
Total_Messages_Created: 963971 [ 02/06/2013 17:04:06]
Total_Messages_Enqueued: 987271 [ 02/06/2013 17:04:06]
Total_Full_Evaluations: 10970
Elapsed_Capture_Time: 52593362 Elapsed_Rule_Time: 59
Elapsed_Enqueue_Time: 0 Elapsed_Lcr_Time: 1937
Elapsed_Redo_Wait_Time: 0 Elapsed_Pause_Time: 0
Apply_Name : APPLY$_GENEVA1_137
Apply_DBLink : GENEVA2
Apply_Messages_Sent: 0
++++End KNSTCAP dump
++++ End KNST DUMP
+++ Begin DBA_CAPTURE dump for: GENEVA1$CAP
Capture_Type: LOCAL
Version: 11.2.0.1.0
Source_Database: GENEVA1
Use_Database_Link: NO
Logminer_Id: 1 Logfile_Assignment: IMPLICIT
Status: ENABLED
First_Scn: 0x0000.041c5812 [68966418]
Start_Scn: 0x0000.041c5812 [68966418]
Captured_Scn: 0x0000.045b6bea [73100266]
Applied_Scn: 0x0000.045b56cd [73094861]
Last_Enqueued_Scn: 0x0000.045b8dc8 [73108936]
Capture_User: STRMADMIN
Queue: STRMADMIN.GENEVA1$CAPQ
Rule_Set_Name[+]: "STRMADMIN"."RULESET$_13"
Negative_Rule_Set_Name: "STRMADMIN"."RULESET$_38"
Checkpoint_Retention_Time: 60
+++ End DBA_CAPTURE dump
+++ Begin DBA_CAPTURE_PARAMETERS dump for: GENEVA1$CAP
PARALLELISM = 1 Set_by_User: NO
STARTUP_SECONDS = 0 Set_by_User: NO
TRACE_LEVEL = 0 Set_by_User: NO
TIME_LIMIT = -1 Set_by_User: NO
MESSAGE_LIMIT = -1 Set_by_User: NO
MAXIMUM_SCN = 0xffff.ffffffff [281474976710655] Set_by_User: NO
WRITE_ALERT_LOG = TRUE Set_by_User: NO
DISABLE_ON_LIMIT = FALSE Set_by_User: NO
DOWNSTREAM_REAL_TIME_MINE = TRUE Set_by_User: NO
MESSAGE_TRACKING_FREQUENCY = 2000000 Set_by_User: NO
SKIP_AUTOFILTERED_TABLE_DDL = TRUE Set_by_User: NO
SPLIT_THRESHOLD = 1800 Set_by_User: NO
MERGE_THRESHOLD = 60 Set_by_User: NO
+++ End DBA_CAPTURE_PARAMETERS dump
+++ Begin DBA_CAPTURE_EXTRA_ATTRIBUTES dump for: GENEVA1$CAP
+++ End DBA_CAPTURE_EXTRA_ATTRIBUTES dump
++ LogMiner Session Dump Begin::
SessionId: 1 SessionName: GENEVA1$CAP
Start SCN: 0x0000.00000000 [0]
End SCN: 0x0000.00000000 [0]
Processed SCN: 0x0000.045b94b4 [73110708]
Prepared SCN: 0x0000.045b94b4 [73110708]
Read SCN: 0x0000.045b94b6 [73110710]
Spill SCN: 0x0000.041c5812 [68966418]
Resume SCN: 0x0000.00000000 [0]
Branch SCN: 0x0000.00000000 [0]
Branch Time: 01/01/1988 00:00:00
ResetLog SCN: 0x0000.000e6c20 [945184]
ResetLog Time: 01/31/2013 12:40:10
DB ID: 1299957605 Global DB Name: GENEVA1
krvxvtm: Enabled threads: 1
Current Thread Id: 1, Thread State 0x01
Current Log Seqn: 695, Current Thrd Scn: 0x0000.045b94b6 [73110710]
Current Session State: 0x800, Current LM Compat: 0xb200000
Flags: 0x3fa802d0, Real Time Apply is On
+++ Additional Capture Information:
Capture Flags: 266245
Logminer Start SCN: 0x0000.041c5812 [68966418]
Enqueue Filter SCN: 0x0000.041c5812 [68966418]
Low SCN: 0x0000.045b8dd0 [73108944]
Capture From Date: 01/01/1988 00:00:00
Capture To Date: 01/01/1988 00:00:00
Restart Capture Flag: NO
Ping Pending: NO
Buffered Txn Count: 0
-- Xid Hash entry --
Begin knlcDumpLobHash for XID: xid: 0x000e.007.00000453
Lcr Count: 5 Flags: 82
NO LCRs BUFFERED
TAG is null
End knlcDumpXidHash
-- LOB Hash entry --
Begin knlcDumpLobHash:
Xid: Dumping Lob Hash Key-->
xid: 0x000e.007.00000453 segcol:9 intcol:0 objn:76707 objv:1 thread:1
rba: 0x0002b6.00005b29.0130 <--Done Dumping Lob Hash Key
Offset: 32241 Sequence: 5 Long_Flag: FALSE
gld2status: 213 lau boundary: FALSE
Buffered LCR dump:
Dumping lcr 0x7f415e15e0e8 : type 0
Dumping internal row LCR
(xid,scn,instnum,scnseq,flags,time,compat,compat_num)
=(0x000e.007.00000453,0x0000.045b8dc7,0,0,0x0, 02/06/2013 17:04:05,9.2.0.0.0,0)
header null flags = 0Xf7f0
gdbnm=0x7f415e15db68, GENEVA1
tag is null
UBA = 0X3.c0056b.7.18.1.12bcf
tde key id=0
Message tracking: null
Header extra: null
child_xid (null)
(lid_scn,lid_lid_scn_sqn,lcr_sqn,thread_id)=(0x0000.045b8dc7,3,1,1)
parent_xid (null)
Duration based allocation:DUR:10
(obj#,ver,opnum)=(76707,1,9)
offset = 0, size = 0, dml_id = 0, flags = 0x0
knglrowx: flags=0x0, seq#=0, thread=0, userdata=0, RBA= rba: 0x000000.00000000.0000 knglrowx: srccsetid=0, flags2=0x0
knglrowx: sys_part_nm (null)
Old column count 0
New column count 11
segcol = 1, intcol = 1, flags 0, flags3 0 knglcolx: null
allocsz=2 dtytyp=2 csetform=0 ptr=0x7f415e15d318
(dty, kncdty, acl, csf, csi, ind)=(2,0,2,0,0,0)
value = 10
segcol = 2, intcol = 2, flags 0, flags3 0 knglcolx: null
allocsz=51 dtytyp=1 csetform=0 ptr=0x7f415e15d2b8
(dty, kncdty, acl, csf, csi, ind)=(1,0,51,0,0,0)
value = putGetBytes8MBData_06_02_2013_17_04_619210585076288
segcol = 3, intcol = 3, flags 0, flags3 0 knglcolx: null
allocsz=2 dtytyp=2 csetform=0 ptr=0x7f415e15d288
(dty, kncdty, acl, csf, csi, ind)=(2,0,2,0,0,0)
value = 1
segcol = 4, intcol = 4, flags 0, flags3 0 knglcolx: null
allocsz=2 dtytyp=2 csetform=0 ptr=0x7f415e15d258
(dty, kncdty, acl, csf, csi, ind)=(2,0,2,0,0,0)
value = 56
segcol = 5, intcol = 5, flags 0, flags3 0 knglcolx: null
allocsz=2 dtytyp=2 csetform=0 ptr=0x7f415e15d228
(dty, kncdty, acl, csf, csi, ind)=(2,0,2,0,0,0)
value = 1
segcol = 6, intcol = 6, flags 0, flags3 0 knglcolx: null
allocsz=11 dtytyp=180 csetform=0 ptr=0x7f415e15d1f8
(dty, kncdty, acl, csf, csi, ind)=(180,0,11,0,0,0)
value = 2013-02-06 11:34:05.582000000
segcol = 7, intcol = 7, flags 0, flags3 0 knglcolx: null
allocsz=7 dtytyp=180 csetform=0 ptr=0x7f415e15d1c8
(dty, kncdty, acl, csf, csi, ind)=(180,0,7,0,0,0)
value = 1970-01-01 00:00:00
segcol = 8, intcol = 8, flags 0, flags3 0 knglcolx: null
allocsz=11 dtytyp=180 csetform=0 ptr=0x7f415e15d198
(dty, kncdty, acl, csf, csi, ind)=(180,0,11,0,0,0)
value = 2013-02-06 11:34:05.582000000
segcol = 9, intcol = 9, flags 1, flags3 0 knglcolx: null
allocsz=0 dtytyp=23 csetform=0 ptr=(nil)
LOB DATA
segcol = 10, intcol = 10, flags 0, flags3 0 knglcolx: null
allocsz=0 dtytyp=23 csetform=0 ptr=(nil)
value = NULL
segcol = 11, intcol = 11, flags 0, flags3 0 knglcolx: null
allocsz=2 dtytyp=2 csetform=0 ptr=0x7f415e15d168
(dty, kncdty, acl, csf, csi, ind)=(2,0,2,0,0,0)
value = 1
End knlcDumpLobHash
-- No TRIM LCR --
Unsupported Reason: Unknown
++++++++++++ Dumping Current LogMiner Lcr: +++++++++++++++
++ LCR Dump Begin: 0x15b44d160 - lob_write
op: 10, Original op: 10, baseobjn: 76707, objn: 76707, objv: 1
DF: 0x00020803, DF2: 0x00002010, MF: 0x00040000, MF2: 0x00000040
PF: 0x00000000, PF2: 0x00000000
MergeFlag: 0x03, FilterFlag: 0x09
Id: 0, iotPrimaryKeyCount: 0, numChgRec: 1
NumCrSpilled: 0
RedoThread#: 1, rba: 0x0002b6.00005ba1.017c
scn: 0x0000.045b8dd0, (scn: 0x0000.045b8dd0, scn_sqn: 5, lcr_sqn: 1)xid: 0x000e.007.00000453, parentxid: 0x000e.007.00000453, proxyxid: 0x0000.000.00000000
ncol: 11 newcount: 1, oldcount: 0
LUBA: 0x3.c0056b.7.1b.12bcf
GroupThreadId: 1, GroupRba: rba: 0x0002b6.00005b29.0130
LOB info: length: 6225, LOB offset: 0, LOB CodePoint Offset: 0
LOB ID: 0x0001000cc333
Filter Flag: KEEP
++ KRVXOA Dump Begin:
Object Number: 76707 BaseObjNum: 76707 BaseObjVersion: 1
Object Name: GENEVA_OWNER1.GNV_AST_PLD_56 Type: 2
User Cols: 11, Int Cols: 11, Kernel Cols: 11
Tab Flag: 0x40000001, Trig Flags: 0x00, OBJ$ Flags: 0x00
Property: 0x20040820, Attribute: 0x1c7f
Unsupported Columns: 0x0
End knlcDumpCapCtx:*********************************************

Please help me out to get rid of this issue.

Thanks,
Heshang

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points