Search This Blog

Wednesday, October 5, 2011

TNS-12570: TNS:packet reader failure

Intermittent TNS-12570 on Application server [ID 556964.1]
OS: Windows
11gr2.
Fatal NI connect error 12570, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production
opiodr aborting process unknown ospid (6528) as a result of ORA-609
  Time: 05-OCT-2011 16:31:55
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12570
    
TNS-12570: TNS:packet reader failure

Receiving above error in the alert.log file after that searched on metalink and found following solution:
The Database server sqlnet log shows :

ns main err code: 12637
        TNS-12637: Packet receive failed
        ns secondary err code: 12547
        nt main err code: 0
        nt secondary err code: 0
        nt OS err code: 0 
 

Changes

Recently Installed security update MS05-019 or Windows Server 2003 Service Pack 1 on the Appliction server..

Cause

This is due to the bug in the Microsoft Windows Server 2003 SP1.
Installing security update MS05-019 or Windows Server 2003 Service Pack 1 may cause network connectivity between clients and servers to fail
For more informaiton and for the fix refer the below URL:
http://support.microsoft.com/?kbid=898060

Solution

To resolve this problem, install security update 913446 (security bulletin MS06-007). For more information about how to obtain and install security update 913446, visit the following Microsoft Web site: 
http://www.microsoft.com/technet/security/bulletin/MS06-007.mspx

No comments: