ORA-600[kcbgtcr_1a] While Running Streams Replication With a Large Number Of Tables (Doc ID 1073024.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

This problem was observed on Oracle 11.1.0.7 64-bit on a IBM AIX 64-bit server

Problem description
Sudden occurrence of internal errors that persist over time while running Streams replication.

The alert log shows various errors:
ORA-00600: internal error code, arguments: [25026], [1159856135], [650189665], [], [], [], [], [],
ORA-00600: internal error code, arguments: [kcbgtcr_1a], [0], [0], [1], [805], [], [], [], [], [], [], []
ORA-600: internal error code, arguments: [733], [1398030792], [pga heap],[], [], [], []

The following are possible indicators of this bug
ORA-00600 [kcbgtcr_1a]
ORA-00600 [25026]
ORA-07445 [kdtBufRow()+0200]
ORA-07445 [kdtInsRow()+031c]
ORA-00600 [kcbzgb_2]
ORA-07445[kddiruGetUpdKauxu()+008c]

The trace file shows no failing statement

The function stack for OERI:25026 indicates the error occurred while getting a block.
kgeade <- kgeriv_int <- kgeriv <- kgesiv <- ksesic2
krtd2abh kcbgcur ktbgcur kdddgb kdusru
kauupd <- kddiruUpdate <- knasdaExecDML <- knasdaPDML <- knaspd
knasplcr <- knaspx <- knalsptxn

The function stack for OERI:kcbgtcr_1a shows a problem reading a data block
kcbgtcr ktrgtc2 kdifbk kddirxFetchByKey1 kddirxFetchByKey


The values in the ORA-600[25026] are very large (e.g.  1159856135 which is the tablespase ID)
The values in the  ORA-600[kcbgtcr_1a] are very large (e.g. 1398030792 which is the tablespace ID).





Changes

This problem will probably be seen only when replication a large number of tables (100 or more)

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