ORA-24756: transaction does not exist?

Question

Am doing a distributed update and I get this ORA-24756 error: DISTRIB TRAN bea1.67AA54355C4A74ECDEE0 is local tran 6.42.332492 (hex=06.2a.512cc) insert pending prepared tran, scn=8151148567799 (hex=769.d6509cf7) Wed Jan 30 16:45:02 EAT 2015 Errors in file /oradata/sfapdb/bdump/sfapdb_reco_2739.trc: ORA-24756: transaction does not exist oracle.jdbc.xa.OracleXAExceptionSQLException: ORA-24756: transaction does not exist. This error is from a failed two-phase commit I also found out there are some records (trans_id = "6.42.332492") in SYS.PENDING_TRANS$/ SYS.PENDING_SESSION$/dba_2pc_pending with "prepare" status. This transaction is launched from a Weblogic Server via JDBC.\\ How do I resolve this ORA-24756 error?

Answer 1

If this does not always happen and it is sporadic, it may not be a bug, most likely a network error.

There are many bugs associated with the ORA-44756 error, and there is always the likelihood that the root cause of the error was due to a network failure.

When Oracle makes a distributed update, he updates BOTH databases before committing the first update

When you lose connectivity between distributed updates you get entries in the dba_2pc_pending table.