Listener Startup or Connections Hang in 11g
(Doc ID 803838.1)
Last updated on JANUARY 20, 2025
Applies to:
Oracle Net Services - Version 11.1.0.7 to 12.1.0.2 [Release 11.1 to 12.1]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
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
HP-UX PA-RISC (64-bit)
Generic UNIX
Symptoms
Beginning with Oracle RDBMS release 11g, the listener functionality bypasses the /etc/hosts file when resolving hostnames to IPs and instead query the DNS server.
This can introduce some delay in establishing a connection to a remote host compared with 10g.
SQL*Plus and tnsping show this behavior but this delay can appear also when opening a dblink or anytime TCP connections are established by the Oracle Network layer.
This happens even if Name Server Switch configuration (nsswitch) specifies the hosts file prior to dns lookups:
Changes
Nothing was changed in the configuration of the OS, only the upgrade from Oracle 10g to 11g was done.
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 |