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


 

Comments (1)