Export (0) Print
Expand All
5 out of 9 rated this helpful - Rate this topic

How To Configure DTC to Support Oracle Transactions

This topic describes how to configure MS Distributed Transaction Coordinator (MSDTC) to support Oracle transactions.

How To Configure MSDTC to Support Oracle Transactions

  1. Install MDAC 2.6 Service Pack 2 or later.

  2. Install Oracle Client 9i or later.

  3. Ensure that the Network service account has read access to the Oracle Client DLLs. For more information, see the knowledge base article about this.

  4. Enable XA transactions in MSDTC. For more information, see the knowledge base article about required registry entries.

  5. Using regedt32.exe, ensure that the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL contains the following entry:

    MTXOCI=C:\WINDOWS\system32\mtxoci.dll.
    
    
  6. If you are running a version of Windows prior to Windows 8, follow these steps. Otherwise, skip to step 7.

    For Oracle Client 8.1.7: Using regedt32.exe, ensure that the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI contains the following entries:

    "OracleXaLib"="oraclient8.dll"
    "OracleSqlLib"="orasql8.dll"
    "OracleOciLib"="oci.dll"
    
    
    For Oracle Client 9i: Using regedt32.exe, ensure that the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI contains the following entries:

    "OracleXaLib"="oraclient9.dll"
    "OracleSqlLib"="orasql9.dll"
    "OracleOciLib"="oci.dll"
    
    
  7. If you are running Windows 8: for Oracle Client 8.1.7 or Oracle Client 9i, use regedt32.exe to ensure that the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI contains the following entries:

    
    "OracleXaLibPath"=""%SystemRoot%\\System32""
    "OracleSqlLibPath"=""%SystemRoot%\\System32""
    "OracleOciLibPath"=""%SystemRoot%\\System32""
    
    

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.