Windows: Intermittent TNS-12560 Error Connecting From Remote Client (Doc ID 793526.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Net Services - Version 9.2.0.7 to 11.2.0.4 [Release 9.2 to 11.2]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Microsoft Windows Server 2003 (64-bit Itanium)Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)Microsoft Windows (32-bit)

Symptoms

Remote client connections are intermittently failing with TNS-12560 TNS: protocol adapter error

An Oracle net client trace shows the following error stack:

[24-FEB-2009 13:50:31:984] nioqper: ns main err code: 12560
[24-FEB-2009 13:50:31:984] nioqper: ns (2) err code: 0
[24-FEB-2009 13:50:31:984] nioqper: nt main err code: 530
[24-FEB-2009 13:50:31:984] nioqper: nt (2) err code: 55
[24-FEB-2009 13:50:31:984] nioqper: nt OS err code: 0
[24-FEB-2009 13:50:31:984] niomapnserror: entry


The error 55 is a Winsock error code that can be translated to mean:

"WSAENOBUFS 55 10055 
No buffer space available. An operation on a socket could not be performed 
because the system lacked sufficient buffer space."




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