Windows: Intermittent ORA-12560 Reported for Remote Connections or Over Oracle Net (Doc ID 859058.1)

Last updated on MAY 08, 2017

Applies to:

Oracle Net Services - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
Microsoft Windows (32-bit)
Microsoft Windows
Client connections from Windows Platform

Symptoms

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:19:378] nttcni: trying to connect to socket 824.
(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[0]=538, ntresnt[1]=65, ntresnt[2]=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[0]=538, nt[1]=65, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

Oracle Net is attempting to use the socket (824) allocated to the connection and this errors with nt[1]=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.





.

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