Oracle Client trace not generating

oracletrace

I'm using Oracle Client 12.1.0.2 and I need to generate client trace because im unable to connect my sql developer to the database server. However, i'm unable to generate the trace.

Here is my sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
TRACE_LEVEL_CLIENT = 16 
TRACE_FILE_CLIENT = client
TRACE_DIRECTORY_CLIENT = 'D:\app\client\product\12.1.0\client_1\network\admin'
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON
DIAG_ADR_ENABLED=OFF

I have the rights to write in the folder but unable to generate the logs.

I tried the same with net manager also.

But no luck.

Best Answer

Add following line to sqlnet.ora:

adr_base=off

You should be able to find your traces then. Without it, all client traces go to %userprofile%\oracle\oradiag_%username% folder.

Related Question