Oracle Error Code Ora-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 really causing any serious problems on oracle error ora-12571 encountered our website, but it was a very annoying problem that we spent a ton of
Ora-12571 Intermittent
time resolving. I want anyone else experiencing this problem to see the solution, so I posted it on Experts Exchange and this blog. ora-12571 tns packet writer failure oracle 10g 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 are load balanced. Each web server connects to our Oracle Database Server through a
Ora-12571: Tns:packet Writer Failure Toad
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 the same subnet as the Solaris Oracle 9i Server, and the path the network traffic takes is identical. What is ora 12571 tns packet writer failure 10g 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 occur during times of less website traffic. Does anyone have any idea why we are getting those TNS:packet writer failure messages? Answer/Solution We finally discovered the cause of the problem. What was happening is that in periods of inactivity the database connectio
Last updated: November 25, 2004 - 10:15 am UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: I Love Backups and APIs, a.k.a., Test Delete Processes VERY THOROUGHLY Latest Followup You Asked Tom:
Sqlnet Expire_time 10
I got this error very often recently. when i go to Oracle8i error messages
Ora-12570
release 8.1.5 A67785-01 i found that error between 12495 and 12700 is missing. i was wondering why, also why did i got ora-12751 this message? Regards, and we said... Error: ORA-12571 / TNS-12571 Text: TNS:packet writer failure --------------------------------------------------------------------------- Cause: An error occurred during a data send. Action: Not normally visible to the user. For further details, turn on tracing https://garethhooper.com/2011/12/11/ora-12571-tnspacket-writer-failure-one-of-the-hardest-problems-ive-had-to-resolve/ and reexecute the operation. If error persists, contact Oracle Customer Support. (the last part of that Action being perhaps the most important)... As for the 'missing' messages -- I see them in http://download-east.oracle.com/docs/cd/F49540_01/DOC/server.815/a67785/tnsus.htm#1000527 those are TNS, not ORA, maybe you looked in the wrong section? Reviews Write a Review ora - 12571 December 11, 2003 - 3:44 am UTC Reviewer: apl from india i am getting this error ora - https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1024831278407 12571 tns:packet writer failure i got this error only in one client machine. Rest of the client machines can connect to the server. My client machine o/s is windows 2000. i can ping to the server. but i am not getting tnsping thanking You Followup December 11, 2003 - 6:07 am UTC please contact support for an issue like this. December 11, 2003 - 1:46 pm UTC Reviewer: A reader I wish Oracle Support was as efficient/effective as Tom. Maybe some info about this issue could help anyone... March 23, 2004 - 1:13 pm UTC Reviewer: Sven Bleckwedel from Santos, SP - Brasil Hi, " symptom: Errors appear in alert file symptom: FATAL ERROR IN TWO-TASK SERVER: symptom: ERROR = 12571 symptom: trace file generated symptom: Database operations continue successfully cause: The most common cause for the above error is an ungraceful disconnection of a session from the oracle db while the db is currently running a dml statement issued by that session. The error is recorded when oracle attempts to reply back to the session with the results of the dml and cannot access the session. Overall database operations are usually not affected. An ungraceful disconnection could cause by but is not limited to any of the following: - the client machine crashed
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://stackoverflow.com/questions/7151175/ora-12571-tnspacket-writer-failure-with-asp-net 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, packet writer 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 packet writer failure 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 statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRec