My Oracle Support Banner

When Trying to Use TransactionOption Set To Required Resulted In Error "Unable To Enlist In The Transaction" (Doc ID 754248.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Services for Microsoft Transaction Server - Version 10.2.0.1 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.