Local Connections Using TCP Fail With TNS-12543 or TNS-12535 to Database

(Doc ID 2017460.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Net Services - Version and later
Linux x86-64


1. With a new installation of Oracle Database local TCP connections fail when connecting through the Listener:


/home/oracle> sqlplus sys/manager@DEVORCL as sysdba

SQL*Plus: Release 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:


tnsping "(ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))"

TNS Ping Utility for 64-bit Windows: Version - Production on 24-SEP-2015 11:35:49

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Attempting to contact (ADDRESS = (PROTOCOL = TCP)(HOST = = 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 - Production on 24-SEP-2015 14:10:31

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version - 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
SNMP                      OFF
Listener Parameter File   /u00/app/oracle/product/
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