What is the difference between "ORA-12571: TNS packet writer failure" and "ORA-03135: connection lost contact"?

oracle odp.net tns ora-12571
Philippe picture Philippe · Apr 16, 2010 · Viewed 12.5k times · Source

I am working in an environment where we get production issues from time to time related to Oracle connections. We use ODP.NET from ASP.NET applications, and we suspect the firewall closes connections that have been in the connection pool too long.

Sometimes we get an "ORA-12571: TNS packet writer failure" error, and sometimes we get "ORA-03135: connection lost contact."

I was wondering if someone has run into this and/or has an understanding of the difference between the 2 errors.

Answer

Achille picture Achille · Apr 17, 2010

Using a mobile phone analogy:

  • ORA-12571 (Failure) Means call is dropped.
  • ORA-03135 (Connection Lost) Other party hung up.

Related questions

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle …

Read More
ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g server, using version 10.1.0.301 of the ODAC/ODP.Net drivers. After a long period of inactivity (a few hours), the application, …

Read More
Can you use Microsoft Entity Framework with Oracle?

Is it possible to use Microsoft Entity Framework with Oracle database?

Read More