My Oracle Support Banner

ORA-00600: Internal Error Code, Arguments: [ktsf_rsp2], [5466240], [489591], During Distributed Transaction (Doc ID 2514548.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

ORA-00600: internal error code, arguments: [ktsf_rsp2], [5466240], [489591], [], [], [], [], [], [], [], [], []

Process trace file associated with the error will show;

 

temp table undo in distributed txn - unsupported...................................**
************ dump undo block **********
Dump of buffer cache at level 3 for pdb=3 tsn=2 rdba=838917651
Dump redo command(s):
ALTER SYSTEM DUMP REDO DBA MIN 200 56851 DBA MAX 200 56851 CON_ID 3
DUMP REDO
Opcodes *.*
DBAs (file#, block#):
(200, 56851) .
SCNs: scn: 0x0000000000000000 thru scn: 0xffffffffffffffff

 

Main Stack:  
ktsf_rsp1 <- kdoiur <- kcoubk <- ktundo <- kturCurrBackoutOneChg <- kturAbortTxnMain
 <- kturAbortTxn <- ktcAbortTxn_new <- ktcAbortTxn <- ktdabt <- k2labo <- k2send <- kpotxcap
  <- kpotxen <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real

 

Second argument of the error represents the  temp object.  In this case it is  5466240 and will show in the incident trace as below;

 

* Rec #0x37  slt: 0x10  objn: 144412(0x0002341c)  objd: 5466240  tblspc: 4(0x00000004)
*       Layer:  11 (Row)   opc: 1   rci 0x36  
Undo type:  Regular undo    User Undo Applied  Last buffer split:  No
Temp Object:  Yes

 

Changes

 

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.