Home > packet writer > oracle error code ora-12571

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

 

Related content

database error 12571

Database Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Packet Writer Failure Oracle g a li li a href Ora- Tns packet Writer Failure Toad a li li a href Sqlnet Expire time a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support SPAN Development Implementation Consulting StaffConsulting PricesHelp Wanted relatedl Oracle PostersOracle Books Oracle Scripts Ion Excel-DB oracle error ora- encountered Don Burleson Blog P TD TR TBODY FORM td ora- intermittent ORA- TNS packet

error 12571

Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Intermittent a li li a href Ora Tns Packet Writer Failure g a li li a href Ora- a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware relatedl SupportRemote Support SPAN Development Implementation Consulting ora- tns packet writer failure g StaffConsulting PricesHelp Wanted Oracle PostersOracle Books Oracle Scripts Ion p h id Ora- Intermittent p Excel-DB Don Burleson Blog P TD TR TBODY FORM td ora- tns packet writer failure

error 12571 oracle

Error Oracle table id toc tbody tr td div id toctitle Contents div ul li a href Oracle Error Ora- Encountered a li li a href Ora- Tns Packet Writer Failure Oracle g a li li a href Sqlnet Expire time a li li a href Ora- a li ul td tr tbody table p on December ORA- TNS packet writer failure This is one of the hardest problems I've come across in relatedl my career and take us a whopping months to p h id Oracle Error Ora- Encountered p resolve The issue wasn't really causing any serious problems

error code 12571

Error Code table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Packet Writer Failure g a li li a href Opitsk Network Error Occurred While Two-task Server Trying Tosend Break Error Code a li ul td tr tbody table p Posts Joined -September relatedl Member No Hello I have a server on which ora- tns packet writer failure g a couple of services are running So now and then I cannot get ora- intermittent connection to the Oracle database anoymore Only a server reboot solves the issue for a couple of days

error ora 12571 tns packet writer failure

Error Ora Tns Packet Writer Failure table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns packet Writer Failure Toad a li li a href Ora Tns Packet Writer Failure g a li li a href Ora- a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support SPAN Development Implementation Consulting StaffConsulting PricesHelp relatedl Wanted Oracle PostersOracle Books Oracle Scripts Ion ora- intermittent Excel-DB Don Burleson Blog P TD TR TBODY ora- tns packet writer failure oracle g FORM

ora 12571 error

Ora Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Intermittent a li li a href Ora Tns Packet Writer Failure g a li li a href Sqlnet Expire time a li li a href Ora- a li ul td tr tbody table p Topic Error messages Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export import and relatedl migration Installation upgrades and patches Oracle performance p h id Ora- Intermittent p problems and tuning Oracle security Oracle DBA tools MySQL ora- tns packet writer failure oracle g

oracle error ora-12571

Oracle Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Intermittent a li li a href Ora- Tns packet Writer Failure Toad a li li a href Ora- a li li a href Ora- a li ul td tr tbody table p Last updated November - am UTC Category Database Version Whilst you are here check out some content from the AskTom team On Loading and Extents Latest Followup You Asked relatedl Tom I got this error very often recently when i p h id Ora- Intermittent p go to Oracle

oracle error tns packet writer failure

Oracle Error Tns Packet Writer Failure table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns packet Writer Failure g a li li a href Ora- a li li a href Ora- a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support SPAN Development Implementation Consulting StaffConsulting PricesHelp Wanted Oracle PostersOracle Books Oracle Scripts Ion Excel-DB relatedl Don Burleson Blog P TD TR TBODY ora- tns packet writer failure g FORM td ORA- TNS packet writer failure tips Oracle

oracle sql error 12571

Oracle Sql Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Intermittent a li li a href Ora- Tns packet Writer Failure g a li li a href Ora- a li ul td tr tbody table p on December ORA- TNS packet writer failure This is one of the hardest problems I've come across in my career and take relatedl us a whopping months to resolve The issue wasn't ora- tns packet writer failure g really causing any serious problems on our website but it was a very p h id Ora-

packet writer error

Packet Writer Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Packet Writer Failure Oracle g a li li a href Ora- Intermittent a li li a href Ora- a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support SPAN Development Implementation Consulting StaffConsulting PricesHelp Wanted relatedl Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don ora- tns packet writer failure g Burleson Blog P TD TR TBODY FORM td p h id Ora- Tns Packet Writer Failure