2 Replies Latest reply: Apr 26, 2010 7:51 AM by 769120 RSS

    Unable to enlist in a distributed transaction

    576410
      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