How to troubleshoot msdtc transaction failure issue with linked Oracle server on Windows 2008

We introduced how to make MSDTC transaction function work with linked Oracle server on Windows 2003 before. For Windows 2008/Windows 7, to make the settings work, we need to consider more factors, I’d like to share as below: a. Install Application Server Role on Windows 2008, for details please  check: http://blogs.msdn.com/b/asiatech/archive/2011/03/01/how-to-troubleshoot-msdtc-communication-failure-1.aspx b. Install Oracle Services…

0

How to troubleshoot MSDTC communication failure (II)

After elaborating the check list of MSDTC configuration and setup on Win2003 and Win2008, in this article, we will continue discussing on how to fix below MSDTC communication errors from different parts, including check Firewall and Dynamic Ports allocation: New transaction cannot enlist in the specified transaction coordinator. Enlist of MSDTC transaction failed: Result Code…

0

How to troubleshoot MSDTC communication failure (I)

MSDTC is used in distributed environment, because many factors were involved, when MSDTC communication got failure, such as: New transaction cannot enlist in the specified transaction coordinator. Enlist of MSDTC transaction failed: Result Code = 0x8004d00e Error 8004d00a. Distributed Transaction error error 0x8004D025 (XACT_E_PARTNER_NETWORK_TX_DISABLED) 0x8004D01B (The Transaction Manager is not available.) We generally have three…

0

How to configure "RPC over HTTP" for DCOM communication in Windows 2003

Background RPC-over-HTTP enables client programs to use the Internet to execute procedures provided by server programs on distant networks. RPC over HTTP tunnels its calls through an established HTTP port. Thus, its calls can cross network firewalls on both the client and server networks. RPC over HTTP routes its calls to the RPC proxy located…

1

Troubleshooting and Administrating MSDTC (Microsoft Distributed Transaction)

    Administration   1. How does client communicate with MSDTC Cluster?   2. Understanding MSDTC communication from network layer traffic   Cluster   1. How to configure individual MSDTC resource with SQL cluster application in SQL Server 2008 Failover Cluster   2.  How to configure shared MSDTC resource for Windows 2008 Failover Cluster  …

0

How to troubleshoot MSDTC transaction failure issue with linked Oracle Server on Win2003

In enterprise environments, customers sometimes need to set MSDTC transaction to work with remote Oracle target server. Because the cross-product setup is complicated, sometimes we may face Transaction Failure issue when updating data to a linked Oracle database, for example:   Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be…

0

How to troubleshoot the “Red Arrow” issue in Component Services ( I )

In distributed environment, when we meet problems to call DCOM components or COM+ application, the first thing is to open the Components Manager to check or reconfigure COM+/DCOM settings.  However,  it is possible that when we open the Component Services, a “Red Arrow” displays on the “My Computer” node:    If we try to expand…

4

How to configure shared MSDTC resource for Windows 2008 Failover Cluster

  In this document, I’d like to give you some brief ideas about how to configure MSDTC resource in Windows 2008 Failover cluster environment. I suppose you have successfully setup windows failover cluster. If you haven’t, please refer to the following articles to setup.   http://www.mssqltips.com/tip.asp?tip=1687 http://www.mssqltips.com/tip.asp?tip=1698   Environment:    Windows 2008 SP2 Failover Cluster…

2

How to configure individual MSDTC resource with SQL cluster application in SQL Server 2008 Failover Cluster

  In the Windows 2008 Failover Cluster environment, we recommend the “Incoming Caller Authentication Required” security setting for the MSDTC service. I’ll describe how to create the private MSDTC cluster resource for the SQL instance. Environment: Windows 2008 SP2 Failover Cluster SQL Server 2008 Step 1: Install the SQL Server cluster Since this step is…

6