Locations of tnsnames.ora

During a recent troubleshooting, we came across a requirement where we wanted to know what all locations does Oracle searches tnsnames.ora ? So writing this quick post for the analysis that we did and the results we reached during this exercise. You might already aware of tnsnames.ora in path defined by TNS_ADMIN variable and default…

ORA-12502 TNS-12502 TNS:listener received no CONNECT_DATA from client

TNS:listener received no CONNECT_DATA from clientCause: No CONNECT_DATA was passed to the listener.Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. Below is the sample entry of tnsnames.ora:- #When using SERVICE_NAME in CONNECT_DATA componentorcl.example.com = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.example.com)(PORT =…