STREAMS LOGMINER FAILS WITH ORA-00600 [KRVUATLA20] AFTER A DISTRIBUTED TRANSACTION FAILURE (Doc ID 1095490.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

A Streams Capture process fails with ORA-00600 [krvuatla20] after a distributed transaction failure where the distributed transaction goes from a collecting state to a collecting state as per the following alert.log errors:

Error 2056 trapped in 2PC on transaction 14.0.12098. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 14.0.12098 rolled back, some remote DBs may be in-doubt
ORA-02056: 2PC: k2gCheckGlobalCommit: bad two-phase command number 1 from coord
Wed Feb 24 15:55:10 2010
DISTRIB TRAN KN20C.c5d42f74.14.0.12098
is local tran 14.0.12098 (hex=0e.00.2f42)
insert pending collecting tran, scn=3017509 (hex=0.002e0b25)
Wed Feb 24 15:55:10 2010
DISTRIB TRAN KN20C.c5d42f74.14.0.12098
is local tran 14.0.12098 (hex=0e.00.2f42))
delete pending collecting tran, scn=3017509 (hex=0.002e0b25)


This is followed by the Capture process aborting with the following error message

Errors in file /u01/oracle/diag/rdbms/kn20c/kn20c2/trace/kn20c2_ms01_1994942.trc (incident=8585):
ORA-00600: internal error code, arguments: [krvuatla20], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/oracle/diag/rdbms/kn20c/kn20c2/incident/incdir_8585/kn20c2_ms01_1994942_i8585.trc
krvxerpt: Errors detected in process 49, role builder.
krvxmrs: Leaving by exception: 600

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms