How To Configure DTC to Support Oracle Transactions

  • Article

 

Applies To: Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server Technical Preview, Windows Vista

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

How To Enable MTXOCI.dll Tracing in Windows NT and Windows 2000
INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider
PRB: Connectivity Issue with MDAC and Oracle8i
Information about using Oracle with Microsoft Transaction Server and COM+ components