Error 12571 Oracle

on December 11, 2011 ORA-12571: TNS:packet writer failure. This is one of the hardest problems I've come across in my career and take us a whopping 16 months to

Oracle Error Ora-12571 Encountered

resolve. The issue wasn't really causing any serious problems on our website, but ora-12571 intermittent it was a very annoying problem that we spent a ton of time resolving. I want anyone else experiencing

Ora-12571 Tns Packet Writer Failure Oracle 10g

this problem to see the solution, so I posted it on Experts Exchange and this blog. Below is the subsequent question I posted on Experts Exchange, and 16 months later the actual ora-12571: tns:packet writer failure toad solution. Question/Problem We have multiple web servers that are load balanced. Each web server connects to our Oracle Database Server through a firewall and load balancer. Everything was working correctly when our Oracle Database Server was Solaris 8 running Oracle 9i. Since we migrated to Oracle Enterprise Linux 64-bit 5.4 (RHEL 5) running Oracle 11G update 2 (11.2.0.1.0), we are now seeing ORA-12571: TNS:packet writer ora 12571 tns packet writer failure 10g failure at Oracle.DataAccess.Client.OracleException.HandleErrorHelper messages. The new Linux Oracle Database Server is on the same subnet as the Solaris Oracle 9i Server, and the path the network traffic takes is identical. What is particularly strange about it is that it happens most (if not exclusively) at times where our website traffic is low. For example, on our busiest day of the month website traffic wise, we went without a TNS:packet writer failure error for 17 hours (7:00am until midnight). Yet as soon as we went into the early hours of the morning (where are website traffic is low or lower), those errors came back. When we get one of those errors, the website visitor can just wait 1 -3 secs and refresh the page and everything works correctly. Here’s some other info: Web servers are running IIS 6, Oracle ODP Net 10.2.0.1.0. Web server connection string (excluding username, p/w, server, port) is ;Persist Security Info=False;Connection Timeout=30;Connection Lifetime=120;Enlist=False;Pooling=True;Max Pool Size=25;Min Pool Size=5;Incr Pool Size=1;Decr Pool Size=1 On the Database Server listener.ora connect_timeout=10 - no other listener parameters explicitly set. sqlnet.ora - no parameters explicitly set Network port stats on Server and switch do not sho

Topic Error messages Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA

Sqlnet Expire_time 10

tools MySQL database Real Application Clusters (RAC) Applications View All Enterprise ora-12570 and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards

Ora-12751

(JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup https://garethhooper.com/2011/12/11/ora-12571-tnspacket-writer-failure-one-of-the-hardest-problems-ive-had-to-resolve/ and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server http://searchoracle.techtarget.com/answer/Solutions-for-ORA-12571-TNS-Packet-writer-failure Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q Solutions for "ORA-12571: TNS Packet writer failure" byDon Burleson Sections Share this item with your network: Related Expert Q&A Developer 6 error when connecting to application ... – SearchOracle Problems with Oracle appl

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company http://stackoverflow.com/questions/2655666/what-is-the-difference-between-ora-12571-tns-packet-writer-failure-and-ora-0 Business Learn more about hiring developers or posting ads with us Stack Overflow Questions http://stackoverflow.com/questions/19978413/ora-12571-tns-packet-writer-failure Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What is the difference between “ORA-12571: TNS packet writer failure” and “ORA-03135: connection lost contact”? up vote 2 down vote favorite packet writer 4 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 packet writer failure the difference between the 2 errors. oracle odp.net tns ora-12571 share|improve this question edited Apr 16 '10 at 20:02 Peter Lang 34.9k17103128 asked Apr 16 '10 at 19:36 Philippe 2,4272334 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted Using a mobile phone analogy: ORA-12571 (Failure) Means call is dropped. ORA-03135 (Connection Lost) Other party hung up. share|improve this answer answered Apr 16 '10 at 23:41 Achille 35128 add a comment| up vote 3 down vote My understanding is that 3135 occurs when a connection is lost. This doesn't tell you why the connection was lost, though. It may have been terminated by the server because the server failed to recieve a response to a probe for a certain amount of time, and assumed that the connection was dead. Or (I'm not sure about this) the exact reverse of that: the client failed to recieve a probe response from the server for a certain amount of time, so it assumed the connection was lost. The "certain amount of time" is cotrolled by SQLNET.EXPIRE_TIME=[minutes] in sqlnet.ora. As for 12571, my (again vague) understanding is that there was a sudden failure to send a packet during communication with the server, and that this is typically caused by some software or hardware interfering with the connection

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12571 TNS packet writer failure up vote 1 down vote favorite What is the reason behind this error and how could I solve this problem?? If possible please provide me good explanations. asp.net oracle tns share|improve this question edited Nov 14 '13 at 13:09 शेखर 11.9k113071 asked Nov 14 '13 at 13:06 Aneez 1617 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote This error can occur that has an alias name greater than 25 characters in the file tnsnames.ora. Try decreasing the size of the alias to resolve this problem. Other topic solution If the following error occurs during while committing data to the database, it indicates a network error during data transmission and may be attributed to using an older version of the Oracle client which does not match the version of the Oracle database. Check the version of the Oracle database as well as the version of Oracle client on the local machine. Consistent version between the Oracle database and Oracle client may help resolve this error. share|improve this answer edited Nov 14 '13 at 13:23 answered Nov 14 '13 at 13:17 Andrew Paes 848310 add a comment| up vote 0 down vote This is know as an antivirus issue (Panda or MacAfee). Look here share|improve this answer answered Nov 14 '13 at 13:29 i100 2,519711 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged asp.net oracle tns or ask your own question. asked 2 years ago viewed 6686 times active 2 years ago Related 11Oracle ORA-12154: TNS: Could not resolve service name Error?0Oracle Pro*C ORA-125471What does error ORA-12571 (TNS:packet writer failure) mean in a Web Service?2What is the difference between “ORA-12571: TNS packet writer failure” and “ORA-03135: connection lost contact”?6ORA-12571: TNS:packet writer fai