MADHU@MICROSOFT BLOG

All About Distributed apps

How to configure DTC to support oracle transactions

How to configure DTC to support oracle transactions

  • Comments 1

 

 (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

 

Leave a Comment
  • Please add 8 and 1 and type the answer here:
  • Post
Page 1 of 1 (1 items)