When Trying to Use TransactionOption Set To Required Resulted In Error "Unable To Enlist In The Transaction"

(Doc ID 754248.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Services for Microsoft Transaction Server - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
z*OBSOLETE: Microsoft Windows Server 2003
z*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows XP
z*OBSOLETE: Microsoft Windows Server 2003 R2 (32-bit)
z*OBSOLETE: Microsoft Windows Vista (32-bit)
z*OBSOLETE: Microsoft Windows Server 2008 (32-bit)
Microsoft Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003Microsoft Windows Vista (32-bit)Microsoft Windows Server 2003 R2 (32-bit)Microsoft Windows Server 2008 (32-bit)
Sql Server 2005
Sql Server Buisness Intelligence Development Studio 2005

Symptoms

***Checked for relevance on 20-Jun-2011***

-- Problem Statement:
Oracle Services for MTS version 10.2.0.3.0
Oracle Client version 10.2.0.1.0
Oracle Database version 10.2.0.3.0

Attempting to use the Oracle Provider for OLEDB with the TransactionOption set to Required results in the error:

Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8004D00A.



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