G
Guest
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it.
I have contacted Singapore Microsoft support regarding the problem .Unfortunately they are not able to help me and eventually direct me here
i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting
Hopefully Microsoft Experts here can help me up. Thx
Introduction
=================================================
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle
in our dotnet app. Currently we are using Microsoft.NET Framework 1.1
(VS.net IDE 2003) in our C# project.
Problem Description
=================================================
One thing I feel strange is that every time the ASPX application ended
(closed and disposed the connection object), the Oracle session
connection never killed.
These eventually bring us to oracle connections used up situation
Based on my experiment, The problem will not occur while running
Window app or ASPX app using IIS 6 (w3wp.exe) in Window 2003.
Since we r using the same data access base classes for Window and
Web apps, there is not possible for the error to happen alone in web App.
We did close and dispose the connection object as shown in oracle ODP.net
samples(in ' Using block ').
They do happen in WinXP pro and Win2k Pro for IIS 5.X (haven't tried
in win2k server).
I have checked the Oracle Enterprise Management Console which showing
that the aspnet_wp processes are running even closing up any ASPX web app
browser window and VS.net IDE 2003.
Some Temporary Solutions
==================================================
By referring to the Google forum, in order to kill this "Never ended"
oracle connections, what I need to do is to restart the WWW service in
Window Component Services.
But I do not think this is a practical solution in order to solve the
problem in real time.
By refering to discussion in Oracle OTN forum, some of the guys said
turning off the connnection pool will solve the problem. but again do u
think this is pratical in operating environment ?
I suspect this are some configuration errors in asp.net state
management or IIS settings. I tried to turn off the session in web.config
but the problem is still there. i wonder if i should do anything in the
processmodel setting in machine.config .
Finally
=======
Can any expert provide me a suggestion regarding the problem?
I strongly believe that there sure have a solution for it since many ppl have inplemented .Net framework project in win2k server for the past few years.
Hopefully my description is clear enough to well shape the problem.
Have a nice day. Thanks.
Best Regards,
Steve FOO
I have contacted Singapore Microsoft support regarding the problem .Unfortunately they are not able to help me and eventually direct me here
i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting
Hopefully Microsoft Experts here can help me up. Thx
Introduction
=================================================
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle
in our dotnet app. Currently we are using Microsoft.NET Framework 1.1
(VS.net IDE 2003) in our C# project.
Problem Description
=================================================
One thing I feel strange is that every time the ASPX application ended
(closed and disposed the connection object), the Oracle session
connection never killed.
These eventually bring us to oracle connections used up situation
Based on my experiment, The problem will not occur while running
Window app or ASPX app using IIS 6 (w3wp.exe) in Window 2003.
Since we r using the same data access base classes for Window and
Web apps, there is not possible for the error to happen alone in web App.
We did close and dispose the connection object as shown in oracle ODP.net
samples(in ' Using block ').
They do happen in WinXP pro and Win2k Pro for IIS 5.X (haven't tried
in win2k server).
I have checked the Oracle Enterprise Management Console which showing
that the aspnet_wp processes are running even closing up any ASPX web app
browser window and VS.net IDE 2003.
Some Temporary Solutions
==================================================
By referring to the Google forum, in order to kill this "Never ended"
oracle connections, what I need to do is to restart the WWW service in
Window Component Services.
But I do not think this is a practical solution in order to solve the
problem in real time.
By refering to discussion in Oracle OTN forum, some of the guys said
turning off the connnection pool will solve the problem. but again do u
think this is pratical in operating environment ?
I suspect this are some configuration errors in asp.net state
management or IIS settings. I tried to turn off the session in web.config
but the problem is still there. i wonder if i should do anything in the
processmodel setting in machine.config .
Finally
=======
Can any expert provide me a suggestion regarding the problem?
I strongly believe that there sure have a solution for it since many ppl have inplemented .Net framework project in win2k server for the past few years.
Hopefully my description is clear enough to well shape the problem.
Have a nice day. Thanks.
Best Regards,
Steve FOO