Getting ORA-02396 Connection idle timeout
587376Mar 15 2010 — edited Mar 18 2010I am getting ORA-02396 Connection idle timeout when I try to get a connection from the connection pool.
I have a windows service running that uses ODP pooling. I am certain that after each query connection is closed.
Here's my connection string:
CONNECTION LIFETIME=3600;CONNECTION TIMEOUT=60;DATA SOURCE=dev;DECR POOL SIZE=1;INCR POOL SIZE=1;MAX POOL SIZE=10;MIN POOL SIZE=0;PASSWORD=xxxxx;PERSIST SECURITY INFO=True;POOLING=True;USER ID=abcd;VALIDATE CONNECTION=True
I have tried to call
Oracle.DataAccess.Client.OracleConnection.ClearAllPools()
But I still see the connection when I do SELECT * FROM V$SESSION WHERE PROGRAM IS NOT NULL
The only way to make the connection dissapear is to stop the service completely, which is obviously unacceptable.
Is there a way to remove a connection from the pool AND insure it is disconnected from Oracle server?