Multiple Txn Branches across Multiple App Servers / Txns Hang : ora-2049 and ora-2051 errors (Doc ID 868530.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
checked for currency of 23-Aug-12


Symptoms

XA Environment with :
- Microsoft Distributed Transaction Coordinator service / MSDTC
- Oracle Services for Microsoft Transaction Server / OraMTS

Client Applications are periodically encountering :
ORA-02049: timeout: distributed transaction waiting for lock

Contention is also observed in the view :
gv$session_wait shows sessions waiting "enq: DX - contention"

Errors observed in Alert.log file :
ORA-02049: timeout: distributed transaction waiting for lock
Wed Mar 4 10:52:53 2009
Error 2051 trapped in 2PC on transaction 5.37.1155677. Cleaning up.
Wed Mar 4 10:52:53 2009
Error stack returned to user:
ORA-02051: another session in same transaction failed
Wed Mar 4 10:52:53 2009
Error 2051 trapped in 2PC on transaction 117.2.572. Cleaning up.

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