By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,190 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,190 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
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



Jul 19 '05 #3

P: n/a
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

Jul 19 '05 #4

P: n/a
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



Jul 19 '05 #5

P: n/a
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


Jul 19 '05 #6

P: n/a
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
>
>
>



Jul 19 '05 #7

P: n/a
[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
>
>
>




Jul 19 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.