Windows: Intermittent ORA-12560 Reported for Remote Connections or Over Oracle Net
Last updated on MAY 08, 2017
Applies to:Oracle Net Services - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.2]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
Microsoft Windows (32-bit)
Client connections from Windows Platform
Oracle client connections randomly fails with ORA-12560. At the same time other clients are connecting fine to the same server / RDBMS.
Other sessions on the same client, opened before or after the connection failure can still work.
Oracle Net Client trace show the connection failing, is not getting off the client.
(3480) [29-JUN-2009 14:36:40:332] ntt2err: entry
(3480) [29-JUN-2009 14:36:40:332] ntt2err: soc 824 error - operation=1, ntresnt=538, ntresnt=65, ntresnt=0
(3480) [29-JUN-2009 14:36:40:332] ntt2err: exit
(3480) [29-JUN-2009 14:36:40:441] nttcni: exit
(3480) [29-JUN-2009 14:36:40:441] nttcon: exit
(3480) [29-JUN-2009 14:36:40:441] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt=538, nt=65, nt=0; ora=0, ora=0, ora=0
Oracle Net is attempting to use the socket (824) allocated to the connection and this errors with nt=65, which is WSAEHOSTUNREACH 65 10065
No route to host. A socket operation was attempted to an unreachable host.
This happens before connection handshake with the TNS listener / RDBMS is even attempted.
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