1 Reply Latest reply: Apr 24, 2013 11:39 PM by Rc-Oracle RSS

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

    926611
      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