Troubleshooting Listener Startup or Connection Hang issues in 11g.
Since 11g Oracle resolves hostnames directly by querying DNS rather than from /etc/hosts, this can introduce delays in establishing a connection to the remote database server. This could be observed in the strace for a SQL*Plus connection:- As you can see from the above trace that after reading the nsswitch.conf, library “libnss_dns.so” is loaded, and…