TNS-12514

This post details how to resolve listener connection issues when DB & listener are started but still connect fails with following errors:- ORA-12505 TNS:listener could not resolve SID given in connect descriptor TNS-12505 TNS:listener could not resolve SID given in connect descriptor ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor TNS-12514 TNS:listener could…

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…

Oracle Database Internal Mechanism

Tag Archives: ORA-12514

Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514

Troubleshooting Listener Startup or Connection Hang issues in 11g.