Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ORA-02396 Connection idle timeout

587376Mar 15 2010 — edited Mar 18 2010
I 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2010
Added on Mar 15 2010
10 comments
17,597 views