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-12547: TNS:lost contact

This is a quick note to cover ORA-12547: TNS:lost contact error, I would try to include all possible causes of ORA-12547: TNS:lost contact error so that this post itself could assist you in sorting the issue. ORA-12547: TNS:lost contact error could be due to any of the following reasons:- Incorrect permissions on the ORACLE executable.…