"New Transaction Cannot Enlist In The Specified Transaction Coordinator." wtih ORAOLEDB and Distributed Transaction Promotion

(Doc ID 1553764.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version 11.2.0.1 and later
Generic Windows
***Checked for relevance on 29-Nov-2016***

Symptoms

Using the Oracle Provider for OLE DB may result in the following error if the option "Enable Promotion of Distributed Transactions" is enabled in the Linked Server properties

"The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "<LINKED_SERVER_NAME>" was unable to begin a distributed transaction. OLE DB provider "OraOLEDB.Oracle" for linked server "<LINKED_SERVER_NAME>" returned message "New transaction cannot enlist in the specified transaction coordinator. ".

 


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