Linux: Remote SQL*Plus and Tnspings with Timeouts While Loopback is Successful
Last updated on OCTOBER 19, 2016
Applies to:Oracle Net Services - Version 184.108.40.206.0 to 220.127.116.11 [Release 8.1.7 to 12.1]
Checked for relevance on 5-FEB-2010.
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.
The database server is either Linux x86 or x86-64 and this is likely a new installation.
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