Enlist Distributed transaction / Open generates ORA-02048

Enlist Distributed transaction / Open generates ORA-02048

Postby jesuissur » Tue 30 Nov 2010 14:57

Hi there,

We got a problem using distributed transaction through dotConnect for Oracle. When we set the Enlist to true in the connection string and open the connection under a TransactionScope, we got the following exception

Code: Select all
ORA-02048: attempt to begin distributed transaction without logging on


Code: Select all
   at Devart.Data.Oracle.bm.b(Int32 A_0)
   at Devart.Data.Oracle.aq.d(Int32 A_0)
   at Devart.Data.Oracle.aq.a(Guid A_0, IsolationLevel A_1)
   at Devart.Data.Oracle.OracleInternalConnection.BeginTransaction(Guid distributedIdentifier, IsolationLevel isolationLevel)
   at Devart.Common.s.a(Guid A_0)
   at Devart.Common.DbConnectionInternal.EnlistToDistributedTransactionInternal(Transaction transaction)
   at Devart.Common.DbConnectionInternal.EnlistToDistributedTransaction(Transaction transaction)
   at Devart.Common.DbConnectionInternal.c()
   at Devart.Common.DbConnectionInternal.i()
   at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
   at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
   at Devart.Common.DbConnectionBase.Open()
   at Devart.Data.Oracle.OracleConnection.Open()
   at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)


Do we have to install something specific on our clients and/or (Oracle) server to work with distributed transaction in Oracle?

Does someone has already use distributed transaction with dotConnect?

Thank you very much
Phil
jesuissur
 
Posts: 12
Joined: Wed 13 Oct 2010 14:28

Postby AndreyR » Thu 02 Dec 2010 12:25

Try to set the "Transaction Scope Local" connection string parameter to true. In some scenarios there is no need to open a distributed transaction, and local transaction is enough for the TransactionScope usage.
Please let us know if the error persists.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle