Attempting to run a trace for a SQL*Net connection generated through TOAD.
A database connection can be made, but no trace file is generated.
TRACE OPTIONS when on:
TRACE_LEVEL_CLIENT = ADMIN
TRACE_DIRECTORY_CLIENT=C:\TNS_LOGS
TRACE_FILENO_CLIENT=3
Verify which connection and SQLNet.ora file Toad is using to connect.
- In Toad's connection window, select the client to use, then go to the ellipse/browse button to the right of the client drop down and check the Oracle Home and paths associated to the client selected.
Add the following to the SQLNet.ora file associated to the client that is being used to connect in Toad.
DIAG_ADR_ENABLED=ON
ADR_BASE=C:\TESTLOG
-- DIAG_ADR_ENABLED can set to OFF if preferred.
-- ADR_BASE is a user-defined location.
