Re: Unable to enlist in a distributed transaction Error in COM+ with Oracle DB

[posted and mailed]

Hi Brian,

I have not "Enabled Network for DTS" on my database server. This is because we're not using the COM+ on that server, but instead on the Web/App server.

Also, my transactions are already running fine without enabling network for DTS. However, the problem still persists and occurs at irregular intervals.

Upon further investigation by my DBA, we came upon two bug articles in oracle knowledge base that quite closely described our symptoms. And we too employ transactions in a connection pool that also handles not transactional connections.

The few Bug Articles are:

- Bug No:3427477, dated: 06-FEB-2004 &
- Bug No:3610265, dated: 04-MAY-2004 &
- Bug No:3554534, dated: 05-APR-2004

I'm going to try the patch that has been issued by Oracle to address Bug No: 3427477. Will see how we go with it, keeping in mind the other work arounds that have been suggested by the other articles. Of course switching off connection pooling is not really an option! ;)

Thanx for the help you've rendered Brian! Appreciated it.

CricketWee

CricketWee <cricketwee_at_hotmail.com> wrote in news:6e5da006b43aaed721befafe263c6932_at_news.teranews.com:

> Nope, I don't believe we have DTS installed on the Windows 2003 server.  
> Will give it a go... ;)
> 
> CricketWee
> 
> "Brian Muth" <bmuth_at_mvps.org> wrote in
> news:eQx0ywlSEHA.2692_at_TK2MSFTNGP09.phx.gbl: 
> 

>>> Do you mean Oracle Services for MTS when you say DTS?
>>>
>>> I believe I have enabled Oracle Services for MTS on the database
>>> server. What puzzles me is that this behaviour is not consistent.
>>>
>>> Thanx for the advise anyway, will check again.
>>>
>>> CricketWee
>>>
>>> "Brian Muth" <bmuth_at_mvps.org> wrote in
>>> news:uyDHuFlSEHA.3140_at_tk2msftngp13.phx.gbl:
>>>
>>> > Have you enabled the DTS to have network access on the Windows 2003
>>> > Server? By default it is turned off. This typically causes the
>>> > complaint you describe.
>>> >
>>> > Brian
>>> >
>>> > "CricketWee" <cricketwee_at_hotmail.com> wrote in message
>>> > news:0faf08cbe5a603f792883ea5cdcc3fcb_at_news.teranews.com...
>>> >> I too have the same problem/behaviour when using distributed
>>> >> transaction with MS DTC.  More information about my environment:
>>> >>
>>> >> WebServer:
>>> >> - Windows 2000 Advance Server
>>> >> - Oracle Data Provider for .NET (9.2.0.4)
>>> >> - .NET Framework 1.1
>>> >> - COM+
>>> >>
>>> >> Database:
>>> >> - Windows 2003 Standard Edition
>>> >> - Oracle Database 9i
>>> >>
>>> >> Any pointers would be greatly appreciated.
>>> >>
>>> >> Regards,
>>> >> CricketWee
>>> >
>>> >
>>> >
>>>