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…

Oracle Listener Tracing & network troubleshooting

This article focuses on the Oracle Listener Tracing & Troubleshooting, in this article we would explore the parameters available to enable tracing on Oracle listener so that additional data is available to troubleshoot network related issues between client & server. To enable Listener tracing add following parameters to listener.ora:- TRACE_LEVEL_LISTENER=[0-16|USER|ADMIN|SUPPORT|OFF]#This parameter defines the level of…