0 Replies Latest reply: Aug 28, 2012 1:53 PM by 921501 RSS

    ODP.NET connection staying active

      I am using ODP.NET 11g to connect to a third party DB with a web app running on IIS7. Occasionally (once a week or so) the connection will remain active indefinitely forcing me to restart the server. When I run the performance counters, I can see it happening in the NumberOfActiveConnections and NumberOfActiveConnectionPools. I am running all of the traces, but I don't see any obvious errors occurring.

      1. How can I restart the driver without doing a complete restart of the server? I've tried restarting IIS, the WWW Publishing Service, and the application pool, but it doesn't affect the connection.

      2. What should I be looking for in the trace files to figure out why this is happening?