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

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Net Services - Version: 9.2 to 10.2
Microsoft Windows Server 2003

Symptoms

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

Changes

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms