"New Transaction Cannot Enlist In The Specified Transaction Coordinator." wtih ORAOLEDB and Distributed Transaction Promotion
Last updated on JULY 05, 2017
Applies to:
Oracle Provider for OLE DB - Version 11.2.0.1 and laterGeneric 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