Local Connections Using TCP Fail With TNS-12543 or TNS-12535 to 220.127.116.11 Database
Last updated on AUGUST 25, 2017
Applies to:Oracle Net Services - Version 18.104.22.168 and later
1. With a new installation of Oracle Database 22.214.171.124 local TCP connections fail when connecting through the Listener:
/home/oracle> sqlplus sys/manager@DEVORCL as sysdba
SQL*Plus: Release 126.96.36.199.0 Production on Thu Jun 4 08:16:53 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ORA-12543: TNS:destination host unreachable
2. Tnsping with the same alias also fails with a TNS-12535 or timeout:
TNS Ping Utility for 64-bit Windows: Version 188.8.131.52.0 - Production on 24-SEP-2015 11:35:49
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Attempting to contact (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.60.60)(PORT = 1521))
TNS-12535: TNS:operation timed out
3. Even though the Database is up and running and the Listener is on the "default" port of 1521, the listener status shows that dynamic registration is not working.
$ lsnrctl status LISTENER
LSNRCTL for Linux: Version 184.108.40.206.0 - Production on 24-SEP-2015 14:10:31
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(port=1521)))
STATUS of the LISTENER
Version TNSLSNR for Linux: Version 220.127.116.11.0 - Production
Start Date 24-SEP-2015 14:07:38
Uptime 0 days 0 hr. 2 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /u00/app/oracle/product/18.104.22.168/ora/network/admin/listener.ora
Listener Log File /u00/app/oracle/diag/tnslsnr/ora/listener/alert/log.xml
Listening Endpoints Summary...
The listener supports no services
The command completed successfully
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