My Oracle Support Banner

Integrated Replicat Abended Due To ORA-600 [knalkdLodCfGrpCols:numcols] (Doc ID 2462593.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Symptoms

Integrated Replicat failing due to ORA-600 at the handling error routine.

Database alert log gets the error for the apply server (AS) slave process:

<sid>_as03_<pid>.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label:    RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME:    /odb/ods01/orabin/product/12.2.0.1.0_012018_0
System name: Linux
Node name: localhost
Release: 3.10.0-862.11.6.el7.x86_64
Version: #1 SMP Fri Aug 10 16:55:11 UTC 2018
Machine: x86_64
Instance name: tst01
Redo thread mounted by this instance: 1
Oracle process number: 127
Unix process pid: 60903, image: oracle@localhost (AS03)


*** 2018-10-04T10:00:03.322160-04:00
*** SESSION ID:(1583.2715) 2018-10-04T10:00:03.322190-04:00
*** CLIENT ID:() 2018-10-04T10:00:03.322195-04:00
*** SERVICE NAME:(SYS$USERS) 2018-10-04T10:00:03.322202-04:00
*** MODULE NAME:(GoldenGate) 2018-10-04T10:00:03.322208-04:00
*** ACTION NAME:(OGG$RFFAG201 - Apply Server) 2018-10-04T10:00:03.322213-04:00
*** CLIENT DRIVER:() 2018-10-04T10:00:03.322218-04:00

DDE: Problem Key 'ORA 600 [knalkdLodCfGrpCols:numcols]' was flood controlled (0x4) (incident: 362302)
ORA-00600: internal error code, arguments: [knalkdLodCfGrpCols:numcols], [0], [], [], [], [], [], [], [], [], [], []

*** 2018-10-04T10:00:03.327900-04:00
ORA-00600: internal error code, arguments: [knalkdLodCfGrpCols:numcols], [0], [], [], [], [], [], [], [], [], [], []

*** 2018-10-04T10:00:03.328071-04:00
ORA-00600: internal error code, arguments: [knalkdLodCfGrpCols:numcols], [0], [], [], [], [], [], [], [], [], [], []
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00600: internal error code, arguments: [knalkdLodCfGrpCols:numcols], [0], [], [], [], [], [], [], [], [], [], []

when digging into the rdbms trace, one can identify the affected replicated object:

ORA-26808: Apply process OGG$RFFAG201 died unexpectedly.
ORA-00600: internal error code, arguments: [knalkdLodCfGrpCols:numcols], [0], [], [], [], [], [], [], [], [], [], [] SQL UPDATE /*+  RESTRICT_ALL_REF_CONS  */ "SCOTT"."TIMELINE" x SET x."EVENT_ID" = :a1,x."MNEMONIC_ID" = :a2,x."PRE_START_BY" = :a30,x."PRE_END_BY" = :a31,x."PRE_NA" = :a32,x."PRE_START_DATE" = :a33,x."PRE_END_DATE" = :a34,x."FAIL_START_BY" = :a35,x."FAIL_END_BY" = :a36,x."FAIL_NA" = :a37,x."FAIL_START_DATE" = :a38,x."FAIL_END_DATE" = :a39,x."MIS_START_BY" = :a40,x."MIS_END_BY" = :a41,x."MIS_NA" = :a42,x."MIS_START_DATE" = :a43,x."MIS_END_DATE" = :a44,x."LOB_START_BY" = :a45,x."LOB_END_BY" = :a46,x."LOB_NA" = :a47,x."LOB_START_DATE" = :a48,x."LOB_END_DATE" = :a49,x."TURNOVER_START_BY" = :a50,x."TURNOVER_END_BY" = :a51,x."TURNOVER_NA" = :a52,x."TURNOVER_START_DATE" = :a53,x."TURNOVER_END_DATE" = :a54,x."CDRTS$ROW" = :a55 WHERE x."TIMELINE_ID" = :b0
Aborting transaction on /odb/ods01/nfs_0708/GF0_FFA/12.3.0.4/dirdat/PFFAG201/rt beginning at seqno 13 rba 995214
                        error at seqno 13 rba 995214
Problem replicating SCOTT.TIMELINE to SCOTT.TIMELINE
Mapping problem with unified update record (target format)...

 

Changes

 Implemented integrated replicat.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.