My Oracle Support Banner

Intermittent TNS-12570 on Application server (Doc ID 556964.1)

Last updated on JANUARY 22, 2020

Applies to:

Oracle Net Services - Version to [Release 9.2 to 10.2]
z*OBSOLETE: Microsoft Windows Server 2003
Microsoft Windows Server 2003


Client application was working fine before. Lately, intermittent errors in the application TNS-12570 started to occur. When the errors occur, the application has to reconnect. Clients are able to work some period of time but after 3-4 hrs the problem starts and the clients get disconnected from the application server. And in the application server event viewer you can see oracle TNS packet reader failure error. After restating the Application server client application works fine and after some time again the error reproduces. 

The Application server sqlnet log shows the below stack:

        ns main err code: 12570 
        TNS-12570: TNS:packet reader failure
        ns secondary err code: 12560
        nt main err code: 530
        TNS-00530: Protocol adapter error
        nt secondary err code: 55
        nt OS err code: 0


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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.