Location of sqlnet trace files in 11g

Topics about Databases, Backups, Tuning, Architecture, Systems Management, etc etc.

Location of sqlnet trace files in 11g

Postby bgrenn » Tue Jun 08, 2010 9:56 am

I don't know how many of you have traced sql.. It can be helpful to try to find out why an error is occuring or just verifying parameters (like DEFAULT_SDU_SIZE).

The way to accomplish this is to

1) create a new subdirectory in /tmp

2) Copy the files from $ORACLE_HOME/network/admin to /tmp/{mydir}

3) Set TNS_ADMIN to   /tmp/{mydir}

4) Put these lines in the sql.ora

trace_unique_client = on

Well in 11g, and the introduction of ADR, the trace file does NOT go to /tmp/{mydir} like it used to... it goes to


The only way to override this is to put in


here is a link that helped

Posts: 91
Joined: Mon Mar 16, 2009 11:47 am
Location: Rochester, NY

Return to DBA Topics

Who is online

Users browsing this forum: No registered users and 1 guest