Remote Oracle Net connections hang at Authentication point or end with ORA-3135
(Doc ID 1302367.1)
Last updated on JANUARY 16, 2025
Applies to:
Oracle Net Services - Version 11.1.0.7 and laterOracle Database - Enterprise Edition - Version 8.0.3.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
Information in this document applies to any platform.
Symptoms
Something may occur where there is a connectivity problem between clients or servers and a remote Database such as a Standby or DR site.
What happens with a SQL*Plus test is that any attempt to connect results in a hang while a local loopback on the Database server using the same TNS connect string and listener works fine.
For example, on the remote client or server:
sqlplus <username>/<password>@Remote_sid --> hangs
On the local Database:
sqlplus <username>/<password>@Remote_sid --> connects
An interesting fact is when the wrong username or password is deliberately given (for test purposes), then the ORA-1017 is returned, indicating that the Listener has, in fact, located a Database and handed off the client connection.
A similar situation can occur but instead of hanging, the Client may abort with an ORA-3135 error.
Changes
This may be a new installation but no changes have been observed from an Oracle standpoint
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 |
| Changes |
| Cause |
| Solution |
| References |