Oracle.ManagedDataAccess.Core 2.18.3 Slow to open first connection

39ffaabb-586b-487a-86c1-2c61a8d847d4

Hi,

Im seeing a very slow response on Connection.Open() in .NET code on windows and in docker.  Both take approx 8 seconds to open a conneciton for the first time.  Subsequent attempts (made without restarting the app) take only 5ms or so.

Has anyone else experienced this or can give any advice?

Ive tried to recreate using the old standard .net oracle lib and connection open was very fast

//ConnectionString == "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1532))(CONNECT_DATA=(SID=xxx)));User ID=xxxx;Password=xxxx;"

OracleConnection _connectionObject = new OracleConnection(this.ConnectionString);

_connectionObject.Open()

Any help greatly appreciated!

Alex Keh-Oracle

It's possible that ODP.NET is first trying to use EZ Connect to connect, fails, then moves on to TNS. I've seen another customer hit this error. That customer resolved the problem by turning off EZConnect in the sqlnet.ora file since they weren't using it. Once that was done, the multi-second delay went away. Can you check whether you have EZConnect set in your sqlnet.ora file? You can just remove it if it's there.