How to configure DTC to support oracle transactions
(1)Make sure you have MDAC 2.6, sp2 higher and make sure you have oracle client (we have lot of problems with oracle 8i client,We recommend to use oracle client 9i or higher)
((2)Make sure Network service account has read access to oracle client dlls.
http://support.microsoft.com/default.aspx?scid=kb;en-us;816633
(2)Enable Xa transactions in MSDTC
http://support.microsoft.com/?id=817066
(3)Make sure xadll, mtxoci value is set to mtxoci.dll
Key name HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL
MTXOCI=C:\WINDOWS\system32\mtxoci.dll
(4)
Update Oracle Client software registry keys.
If you use Oracle 8.1.7 or 9i Client software, modify the values of the following registry keys to make sure they match those that are specified as follows:
Client (windows 2003/Windowx xp/windows 2000)
For 8.1.7:
=========
[HKEY_LOCAL_MACHINE\SOFTWARE
\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"
For 9i:
======
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
How to test:
===========
(1)Make sure you are able to run simple query with oracle (without using any transactions)
(2)Make sure you enabled xa option in DTC and configure all oracle client settings like we discussed above
(3)If you want trouble shoot more, you can enable mtxoci trace to trouble shoot MSDTC/oracle problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;301293
More info:
=========
http://support.microsoft.com/kb/244661/en-us
http://support.microsoft.com/kb/264012/en-us
http://support.microsoft.com/kb/193893/en-us
