Windows: Intermittent ORA-12560 Reported for Remote Connections or Over Oracle Net
(Doc ID 859058.1)
Last updated on JANUARY 20, 2025
Applies to:
Oracle Net Services - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]Oracle Database - Enterprise Edition - Version 19.15.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
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.
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
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 |