Local or Remote Connections to Database and Using TCP Fail With TNS-12543 or TNS-12535
(Doc ID 2017460.1)
Last updated on JANUARY 17, 2025
Applies to:
Oracle Net Services - Version 11.2.0.4 to 19.3.0.0.0 [Release 11.2 to 19]Oracle Database - Enterprise Edition - Version 19.23.0.0.0 to 19.23.0.0.0 [Release 19]
Gen 2 Exadata Cloud at Customer - Version N/A and later
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
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/<password>@MY_TNS_ALIAS 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:
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 = xx.yy.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=XX.XX.XX.XX)(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=XX.XX.XX.XX)(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
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 |
| References |