ORA-600 [4257] Hit Using Distributed Transactions
(Doc ID 1940770.1)
Last updated on JUNE 17, 2021
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.3 and laterOracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Alert log reports ORA-600 [4257] for distibuted transactions like:
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_8193.trc (incident=107521):
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_107521/<instname>_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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_8193.trc (incident=107522):
ORA-00603: ORACLE Server-Session mit schwerwiegendem Fehler beendet
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_107522/<instname>_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 <GLOBAL_TRAN_ID>
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 <GLOBAL_TRAN_ID>
is local tran 8.16.4226 (hex=08.10.1082))
delete pending committed tran, scn=1967864150588 (hex=1ca.2dd7fa3c)
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_107521/<instname>_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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_8193.trc (incident=107522):
ORA-00603: ORACLE Server-Session mit schwerwiegendem Fehler beendet
ORA-00600: Interner Fehlercode, Argumente: [4257], [], [], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_107522/<instname>_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 <GLOBAL_TRAN_ID>
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 <GLOBAL_TRAN_ID>
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 |