This discussion is archived
2 Replies Latest reply: Apr 26, 2010 5:51 AM by 769120 RSS

Unable to enlist in a distributed transaction

576410 Newbie
Currently Being Moderated
Hi,

I'm using distributed transaction with Oracle 10g and ODP.Net. After some days the software throws the following exception:

Oracle.DataAccess.Client.OracleException Unable to enlist in a distributed transaction at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()

After that, 'ORA-02049 timeout: distributed transaction waiting for Lock' will occur.

How can I debug this problem? Why is a transaction locking? Where can I enable debug settings int the database or for the OPC.Net Client? How can I kill the locking distributed transaction based on v$transaction view? Right now, I have to restart my software and this is very annoying and expensive.

Need urgendly help
thx
johannes