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

Posted by Philippe on Stack Overflow See other posts from Stack Overflow or by Philippe
Published on 2010-04-16T19:36:24Z Indexed on 2010/04/16 22:13 UTC
Read the original article Hit count: 866

Filed under:
|
|
|
|

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.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about tns