Hi
We just converted our large Enterprise App over to the Managed Provider, we where using the native ODP.NET. We are using a RAC cluster on 11GR2 version.
We are getting "Connection request timed" out sometimes, it seems to get into this state and then fails lots. The same connection string is being used as what was with the native ODP.NET provider.
The connection string is:
Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = XXXX)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = tomsdev)));User ID=XXXXXX;Password=XXXXX;Pooling=true;Min Pool Size=1;Max Pool Size=5;Incr Pool Size=1;Decr Pool Size=5;Connection Lifetime=1;Connection Timeout=30
This is a fat client Windows application with single user at each instance of it so the pool size is set to 5.
Tracing gives this:
2016-06-17 12:54:52.153364 TID:1 (PUB) (ENT) OracleClientFactory.CreateConnection()
2016-06-17 12:54:52.154350 TID:1 (PUB) (ENT) OracleConnection.ctor()
2016-06-17 12:54:52.154350 TID:1 (PUB) (EXT) OracleConnection.ctor()
2016-06-17 12:54:52.154350 TID:1 (PUB) (EXT) OracleClientFactory.CreateConnection()
2016-06-17 12:54:52.154350 TID:1 (PUB) (ENT) OracleConnection.Open() (conid=54055579) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a)
2016-06-17 12:55:22.153108 TID:1 (PUB) (ERR) OracleConnection.Open() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out
at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, String affinityInstanceName, Boolean bForceMatch)
at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword)
at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
As stated the native ODP.NET works fine and without error, the managed provider seems to act differently.
Appreciate any advice and or help.
Regards
Daniel