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?