Oracle.ManagedDataAccess.Core 2.18.3 Slow to open first connection — oracle-tech

    Forum Stats

  • 3,715,657 Users
  • 2,242,821 Discussions
  • 7,845,481 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Oracle.ManagedDataAccess.Core 2.18.3 Slow to open first connection

39ffaabb-586b-487a-86c1-2c61a8d847d4
edited March 2019 in ODP.NET

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!

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited March 2019

    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.

Sign In or Register to comment.