ORA-600[kcbgtcr_1a] While Running Streams Replication With a Large Number Of Tables
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 serverProblem 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.
The function stack for OERI:kcbgtcr_1a shows a problem reading a data block
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