Robert Hurlbut's Blog

Thoughts on .NET, Security, Architecture, Agility, and Databases.

Syndication

.Company / Other Sites / Other Blogs

.NET Links

.NET Local Boston Events

.NET User Groups in New England

Blogs - .NET

Blogs - Agile

Blogs - Architecture

Blogs - CLR

Blogs - Security

Blogs - SQL Server

Blogs - System.Transactions

Enterprise Services (COM+) Resources

Indigo Resources

Microsoft Security Resources

Presentation resources

Recommended Books

Rotor Resources

Security Resources

COM+/Enterprise Services, Distributed Transactions and Oracle - Problem Solved: oramts.dll

Continuing the saga, I was able to find someone at Oracle who could duplicate the problem we had been having, and it definitely was the MTS proxy file from Oracle.  In particular, its the oramts.dll file, part of the Oracle Services for MTS 9.2.0.4 package.  I found Oracle had noted it internally as a bug back in December, but it hasn't been updated in the above package.  I was pointed to a zipped version of the oramts.dll to download and install.  After installing (actually, replacing the old oramts.dll file with the new oramts.dll file), all of my distributed transactions using COM+, ES, ODP.NET, and Microsoft's Oracle Provider worked!

Updated:  A patch is available on MetaLink as patch #3252645.  Download the p3252645_9204_WINNT.zip file which contains oramts.dll and oramts.dbg, marked as version 9.2.0.4.1, fixing the following issue:  BRANCH IN TX GIVES: NEW TRANSACTION CANNOT ENLIST IN THE SPECIFIED COORDINATOR.  Obtain the patch if you are using Oracle Services for MTS 9.2.0.4 with OraOLEDB, ODP.NET, and/or Microsoft's System.Data.OracleClient .NET provider.

I am assuming the fix was something similar to what Florin mentioned to us (listed in Sam's post).

Published Wednesday, January 14, 2004 7:29 PM by RHurlbut
Filed under: , , ,

Comments

# re: COM+/Enterprise Services, Distributed Transactions and Oracle - Problem Solved: oramts.dll@ Thursday, January 15, 2004 5:13 AM

hmm, Oracle had this bug in there version 9.2.0.1.0 also (oct 2002), I downloaded the p2428356_9201_WINNT.zip file back then and everything worked like a charme. Why they didn't fix this in version 9.2.0.4 is beyond my comprehension :)
cheers @llan


by Allan Nielsen

# ES Distributed Transactions with Oracle - Mission Accomplished@ Thursday, January 15, 2004 5:57 PM

by TrackBack

# re: COM+/Enterprise Services, Distributed Transactions and Oracle - Problem Solved: oramts.dll@ Sunday, April 18, 2004 10:48 PM

You Say " I was pointed to a zipped version of the oramts.dll to download and install. ",But,How Can i get the updated zipped version of the oramts.dll?

by zhangtb

# re: COM+/Enterprise Services, Distributed Transactions and Oracle - Problem Solved: oramts.dll@ Monday, April 19, 2004 10:02 AM

I retrieved it from MetaLink (a paid subscription service provided by Oracle), but I had thought they have finally bundled it with the latest releases of the Oracle Services for MTS packages. If you check those, confirm that the version is for oramts.dll is 9.2.0.4.1.

by Robert Hurlbut

# Ramblings on Enterprise Services@ Sunday, May 16, 2004 10:46 AM

by TrackBack

# Ramblings on Enterprise Services@ Sunday, May 16, 2004 10:47 AM

by TrackBack