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 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


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

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

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.


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

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