If you ever had tried to switch Oracle net trace than you know that it is quite straight forward to switch it on. You would say that I need to set the following parameters in the sqlnet.ora file:
TRACE_UNIQUE_CLIENT = on TRACE_LEVEL_CLIENT=16 TRACE_DIRECTORY_CLIENT = /tmp
It was true up until 11GR2. I hope this post will save you a bit of time. In order to see the trace files in the specified location you should specify yet another parameter:
Otherwise Oracle will create the trace files depending on type Client/Server in the following directories:
Client – OS Home dir/oradiag_os username/diag/clients/user_oradb/host_number/trace/
RDBMS – ORACLE_BASE/diag/rdbms/db_name/instance_name/trace/
The directories structure is part of 11G ADR – Automatic Diagnostic Repository. It looks like Oracle put a lot of efforts to build in ITIL principles in the RDBMS trace facility. Each trace file is associated with an incident. Incident … Well I think I better stop here as ADR is a big topic for a separate blog post or set of post. The messages I would like to pass to you this time are:
-1- If you don’t find Oracle Net flies in the directories where you expect those just set DIAG_ADR_ENABLED=OFF parameter in the relative sqlnet.ora file
-2- Oracle 11G trace/log functionality has build in ITIL principles. Be ready and aware about new great idea from Oracle DB software architects.
PS There is a utility called “adrci” that is part of 11G installation. This purpose of this utility is to centralize trace files management and help you report these to Oracle Support (or Pythian;).
All the Best in all your efforts,
Automatic Diagnostic Repository Command Interpreter (adrci) usage example:
[oradb@epa01 trace]$ adrci ADRCI: Release 184.108.40.206.0 - Production on Mon Oct 11 21:55:19 2010 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. ADR base = "/home/oradb/oradiag_oradb" adrci> SHOW TRACEFILE diag/clients/user_oradb/host_2533336231_76/trace/sqlnet.log diag/clients/user_oradb/host_2533336231_76/trace/ora_5589_3086898880.trc adrci>