[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
>
>
>
