Linux: Remote SQL*Plus and Tnspings with Timeouts While Loopback is Successful
(Doc ID 340661.1)
Last updated on JANUARY 20, 2025
Applies to:
Oracle Net Services - Version 8.1.7.4.0 to 12.1.0.2 [Release 8.1.7 to 12.1]Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Linux x86
Linux x86-64
Symptoms
The listener is running and appears to be functioning properly when using TCP loopback connections on the server. However, remote clients attempting to contact the server via TCP using either SQL*Plus or tnsping are failing with an ORA-12560. Remote client connections may also hang or throw a timeout error. TNS-12535.
A client trace file might reveal the following:
Consider this document for any of the following errors or conditions using SQL*Plus or Tnsping and when Linux is the platform where the database resides:
ORA-12560 TNS: Protocol adapter error
ORA-12535 TNS: Operation timed out
TNS-12535 TNS: Operation timed out
If remote clients using SQL*Plus hang indefinitely, this may be the problem.
Changes
The database server is either Linux x86 or x86-64 and this is likely a new installation.
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 |