Windows: Intermittent TNS-12560 Error Connecting From Remote Client
(Doc ID 793526.1)
Last updated on JANUARY 22, 2020
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
[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."
No buffer space available. An operation on a socket could not be performed
because the system lacked sufficient buffer space."
Cause
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
| Symptoms |
| Cause |
| Solution |