Skip to content

Instantly share code, notes, and snippets.

@kralo
Created January 12, 2026 08:26
Show Gist options
  • Select an option

  • Save kralo/4b83552009a4cbd98dbefa53ce9733b2 to your computer and use it in GitHub Desktop.

Select an option

Save kralo/4b83552009a4cbd98dbefa53ce9733b2 to your computer and use it in GitHub Desktop.
Oracle Instantclient 12.2 enable diagnosis

If you have the instantclient "installed" and want to enable some diagnostic debug output, in the same folder as your tnsnames.ora create a file sqlnet.ora

echo %TNS_ADMIN%
c:\oracle\network\admin\

file contents (remove comment to make active):

#trace_level_client = admin
#trace_unique_client = on
#trace_file_client = sqlnet.trc
#trace_directory_client = c:\\oratraces
# the last seemed particularly important to specify own directory
#adr_base=off


Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment