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

[Prashanth]

Hi,

We are facing some issues in COM+ deployment. We get system error
"Unable to enlist in a distributed transaction" . It has a very
inconsistant behaviour. On refreshing the screens couple of times, the
error disappears.Also it reappears abruptly giving an impression that
the transaction failed although the changes are commited to the
database.Please let me know if any of you have faced it before.

This is a .Net Application with Oracle DB, Uses distributed
Transaction (MSDTC).

Any pointers in getting this resolved will be highly appreciated.

Thanks
PrashanthG

[Oleh Mykytyuk]

What version of Windows do you use?

Best regards, Oleh

"Prashanth" <pr********@infy.com> wrote in message
news:5a**************************@posting.google.c om...

Hi,

We are facing some issues in COM+ deployment. We get system error
"Unable to enlist in a distributed transaction" . It has a very
inconsistant behaviour. On refreshing the screens couple of times, the
error disappears.Also it reappears abruptly giving an impression that
the transaction failed although the changes are commited to the
database.Please let me know if any of you have faced it before.

This is a .Net Application with Oracle DB, Uses distributed
Transaction (MSDTC).

Any pointers in getting this resolved will be highly appreciated.

Thanks
PrashanthG

[CricketWee]

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

"Oleh Mykytyuk" <mo*@bt-entel.kiev.ua> wrote in news:bntrgp$2q3g$1
@app0.visti.net:

What version of Windows do you use?

Best regards, Oleh

"Prashanth" <pr********@infy.com> wrote in message
news:5a**************************@posting.google.c om...

Hi,

We are facing some issues in COM+ deployment. We get system error
"Unable to enlist in a distributed transaction" . It has a very
inconsistant behaviour. On refreshing the screens couple of times, the
error disappears.Also it reappears abruptly giving an impression that
the transaction failed although the changes are commited to the
database.Please let me know if any of you have faced it before.

This is a .Net Application with Oracle DB, Uses distributed
Transaction (MSDTC).

Any pointers in getting this resolved will be highly appreciated.

Thanks
PrashanthG

[Brian Muth]

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" <cr********@hotmail.com> wrote in message
news:0f******************************@news.teranew s.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

[CricketWee]

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" <bm***@mvps.org> wrote in
news:uy**************@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" <cr********@hotmail.com> wrote in message
news:0f******************************@news.teranew s.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

[Brian Muth]

No. I mean DTS. Distributed Transaction Server. It must be enabled for
network access under Windows Server 2003. This is in your Add/Remove
Programs control panel applet under Windows Components, Application Server.
Make sure the checkbox is checked for Enable Network for DTS (IIRC).

Brian

"CricketWee" <cr********@hotmail.com> wrote in message
news:81******************************@news.teranew s.com...

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" <bm***@mvps.org> wrote in
news:uy**************@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" <cr********@hotmail.com> wrote in message
news:0f******************************@news.teranew s.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

[CricketWee]

Nope, I don't believe we have DTS installed on the Windows 2003 server.
Will give it a go... ;)

CricketWee

"Brian Muth" <bm***@mvps.org> wrote in
news:eQ**************@TK2MSFTNGP09.phx.gbl:

No. I mean DTS. Distributed Transaction Server. It must be enabled for
network access under Windows Server 2003. This is in your Add/Remove
Programs control panel applet under Windows Components, Application
Server. Make sure the checkbox is checked for Enable Network for DTS
(IIRC).

Brian

"CricketWee" <cr********@hotmail.com> wrote in message
news:81******************************@news.teranew s.com...

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" <bm***@mvps.org> wrote in
news:uy**************@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" <cr********@hotmail.com> wrote in message
> news:0f******************************@news.teranew s.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
>
>
>

[CricketWee]

[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 <cr********@hotmail.com> wrote in
news:6e******************************@news.teranew s.com:

Nope, I don't believe we have DTS installed on the Windows 2003 server.
Will give it a go... ;)

CricketWee

"Brian Muth" <bm***@mvps.org> wrote in
news:eQ**************@TK2MSFTNGP09.phx.gbl:

No. I mean DTS. Distributed Transaction Server. It must be enabled for
network access under Windows Server 2003. This is in your Add/Remove
Programs control panel applet under Windows Components, Application
Server. Make sure the checkbox is checked for Enable Network for DTS
(IIRC).

Brian

"CricketWee" <cr********@hotmail.com> wrote in message
news:81******************************@news.teranew s.com...

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" <bm***@mvps.org> wrote in
news:uy**************@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" <cr********@hotmail.com> wrote in message
> news:0f******************************@news.teranew s.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
>
>
>