My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.