ORA-600 [4257] Hit Using Distributed Transactions (Doc ID 1940770.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Alert log reports ORA-600 [4257] for distibuted transactions like:

Errors in file /opt/oracle/diag/rdbms/btv/BTV1/trace/BTV1_ora_8193.trc  (incident=107521):
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/btv/BTV1/incident/incdir_107521/BTV1_ora_8193_i107521.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Error 600 trapped in 2PC on transaction 8.16.4226. Cleaning up.
Error stack returned to user:
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Errors in file /opt/oracle/diag/rdbms/btv/BTV1/trace/BTV1_ora_8193.trc  (incident=107522):
ORA-00603: ORACLE Server-Session mit schwerwiegendem Fehler beendet
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/btv/BTV1/incident/incdir_107522/BTV1_ora_8193_i107522.trc
Fri Aug 15 08:39:08 2014
Dumping diagnostic data in directory=[cdmp_20140815083908], requested by (instance=1, osid=8193), summary=[incident=107521].
Fri Aug 15 08:39:09 2014
Sweep [inc][107522]: completed
Sweep [inc][107521]: completed
Sweep [inc2][107521]: completed
opiodr aborting process unknown ospid (8193) as a result of ORA-603
Fri Aug 15 08:39:13 2014
DISTRIB TRAN BTV.08cde4b5.8.16.4226
 is local tran 8.16.4226 (hex=08.10.1082)
 insert pending committed tran, scn=1967864150588 (hex=1ca.2dd7fa3c)
Fri Aug 15 08:39:13 2014
DISTRIB TRAN BTV.08cde4b5.8.16.4226
 is local tran 8.16.4226 (hex=08.10.1082))
 delete pending committed tran, scn=1967864150588 (hex=1ca.2dd7fa3c)


The call stack from the trace file includes function like:

... ktldbl_noredo ktldbl kssdel ktdrls ktcddb k2lfor k2sfor k2send xctctl xctCommitTxn ... OR ... ktldbl_withredo <- ktldbl <- kssdel <- ktdrls <- ktcddb <- k2lfor <- k2sfor ...

 

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