Local Connections Using TCP Fail With TNS-12543 or TNS-12535 to 11.2.0.4 Database (Doc ID 2017460.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Net Services - Version 11.2.0.4 and later
Linux x86-64

Symptoms

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

 

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

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 4 08:16:53 2015

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

ERROR:
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 = 10.10.60.60)(PORT = 1521))"

TNS Ping Utility for 64-bit Windows: Version 11.2.0.4.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 11.2.0.4.0 - Production on 24-SEP-2015 14:10:31

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.60.60)(port=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.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
SNMP                      OFF
Listener Parameter File   /u00/app/oracle/product/11.2.0.4/ora/network/admin/listener.ora
Listener Log File         /u00/app/oracle/diag/tnslsnr/ora/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.60.60)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

  


 

 

 

Changes

 This is likely a new installation.

 

Cause

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