Unable To Initiate A Distributed Transaction From Sql Server on Windows 2003 SP1

(Doc ID 336893.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version: 9.2.0.8 and later   [Release: 9.2 and later ]
Microsoft Windows (32-bit)
Microsoft Windows Server 2003
Checked for relevance on 16-May-2007

Symptoms


On MS SQL Server a Linked Server to the Oracle Database using OLE DB cannot initiate a Distributed Transaction returning this error:

Server: Msg 7391, Level 16, State 1, Line 5
The operation could not be performed because the OLE DB provider 'MSDAORA' was
unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction
returned 0x8000d048]."

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