Few days ago, there was a strange problem I came across in my site. The site was down displaying " TNS listener couldnt be found" and on analyzing, we found that there were already 150 connections to database and hence has to increase the connections to 300. But this dint solve the problem? There were both active and inactive connections to database wherein inactive connections were not getting closed automatically. Ideally speaking, they should be closed if there is no transaction or query procession done.
On further analysing, a new issue was known to me that .Net Data provider when connected to Oracle, keeps the connections inactive or idle connections. A workaround for this issue recommended by Microsoft was to kill the asp.net worker processes manually, but even this couldnt be an ideal solution.
This problem was fixed in Oracle Data Provided Provided by Oracle Corporation which works with .Net Framework with service Pack 2.
Hope this helps you too.
