Oracle Sql Error 12571
Contents |
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 resolve. The issue wasn't ora-12571 tns packet writer failure 11g really causing any serious problems on our website, but it was a very
Ora-12571 Intermittent
annoying problem that we spent a ton of time resolving. I want anyone else experiencing this problem to see the solution, ora-12571 tns packet writer failure oracle 10g 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 solution. Question/Problem We have multiple web servers that ora 12571 tns packet writer failure toad 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 failure at Oracle.DataAccess.Client.OracleException.HandleErrorHelper messages. The new Linux Oracle Database Server is on
Ora-12571: Tns:packet Writer Failure 10g
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 show dropped packets or anything leading us to believe there is a network problem. Also, like I say, those TNS:packet writer failure messages oc
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 sqlnet expire_time 10 security Oracle DBA tools MySQL database Real Application Clusters ora-12570 (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business
Ora-12751
Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database https://garethhooper.com/2011/12/11/ora-12571-tnspacket-writer-failure-one-of-the-hardest-problems-ive-had-to-resolve/ 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 tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored http://searchoracle.techtarget.com/answer/Solutions-for-ORA-12571-TNS-Packet-writer-failure procedures XML PL/SQL Fusion View All Oracle and BEA Application Server 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
Last updated: February 05, 2016 - 1:14 am UTC Category: Database � Version: 12g Whilst you are here, check out some content from the AskTom team: Qualify names of variables inside SQL statements! (an ode to fine-grained dependency) Latest Followup https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9526141800346795558 You Asked Dear Mr. Tom My Client has around 100 users…they frequently get the below http://stackoverflow.com/questions/7151175/ora-12571-tnspacket-writer-failure-with-asp-net problem ORA-12571 : TNS packet Writer Failure May I know what is the reason behind this? Can u please help coming out of this, Pls help us… Regards Anees and we said... Lots of possible causes here, mostly related to getting information correctly back and forth across the network. Examples include: - a firewall is getting in packet writer the way - host name resolution failing - multiple process colliding on the same port number - somewhere in the infrastructure there is a timeout, so (for example) a network router may drop inactive connections - anti-virus software (typically includes a software firewall). You can see where I'm heading - something is stopping us from successfully sending information between the db and the client across sqlnet. Reviews Write a Review So how to packet writer failure Trace this end to end February 04, 2016 - 3:45 pm UTC Reviewer: A reader Is there a way to trace this end to end. Starting from user application session to DB to Os to Network back to the Os --> DB --> application. Or whatever path it takes as part of the complete workflow. The complete cycle end to end ? What tools to use ? Does OEM offer anything or any other combination of tools or scripts ? Followup February 05, 2016 - 1:14 am UTC Yeah, these kinds of problems are nasty to solve. The network guys will say its the server, the server guys will say its the db, and the db guys will say its the network :-) Some good info here on how to setup SQL Net trace. http://juliandyke.com/Diagnostics/Trace/NetTrace.php Note - the trace files can be verbose ! It may be the best bet to get as much tracing info as you can, then ask for assistance from Support to dig through it. Hope this helps. Set Screen Reader Mode On Integrated Cloud Applications and Platform Services About Oracle Contact Us Legal Notices Terms of Use Your Privacy Rights All information and materials provided here are provided "as-is"; Oracle disclaims all express and implied warranties, including, the implied warran
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 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12571: TNS:packet writer failure with ASP.NET up vote 6 down vote favorite My development team is experiencing numerous ORA-12571: TNS:packet writer failure errors using ASP.NET 3.5 and 4.0 against Oracle 11g. These errors are inconsistent as to when they occur, and are generated by numerous applications. This exception happens while calling random stored procedures, packets, and inline SQL statements. The Oracle 11 client is installed on the web server. Some applications use Microsoft System.Data.OracleClient to connect to Oracle, and some use the .NET components provided by oracle (ODP.NET). Both data access objects come up with the same error. There are other non .NET applications that run on a different web server, but use the same database server. The apps do not have any such issues. My initial thinking is that there is something configured incorrectly on the web server with the Oracle client. Has anyone else received this error? What did you do to fix it? ORA-12571: TNS:packet writer failure Stack Trace: at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle stateme