Oracle kill session is not valid1/6/2023 ![]() But I do not think this is a practical solution in order to solve the problem in real time. 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 ![]() 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 They do happen in WinXP pro and Win2k Pro for IIS 5.X (haven't tried in win2k server). ![]() We did close and dispose the connection object as shown in oracle ODP.net samples(in ![]() 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. 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 Problem Description = One thing I feel strange is that every time the ASPX applicationÄ®nded (closed and disposed the connection object), the Oracle session connection never killed. Currently we are using Microsoft.NET Framework 1.1 (VS.net IDE 2003) in our C# project. Thx :-) Introduction = We are using ODP.net (version 9.2.0.4.01) asÄata provider for Oracle in our dotnet app. I have been posting this question in google group and still no cannot find a suitable solution for it.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |