My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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
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.