Enabling Trace On Oracle Client

Tracing produces a detailed sequence of statements that describe network events as they are run. Tracing an operation enables you to obtain more information about the internal operations of the components of Oracle Net Services than is provided in a log file.

Each Oracle Net Services component produces its own trace file. To enable tracing on the oracle client, the configuration file which needs to be modified is sqlnet.ora. This file can be found in ORACLE_HOME\network\admin directory.

Oracle Net Manager is a component/tool installed while installing Oracle client. It enables you to configure Oracle Net Services for an Oracle home on a local client or server host.

Below is a screenshot with the trace parameters set.

There are not many steps to be followed.

  1. Start Oracle Net Manager.
  2. In the navigator pane, expand Profile under the Local heading.
  3. From the list in the right pane, select General.
  4. Click the Tracing tab.
  5. Uncheck “Enable ADR”. ADR (automatic diagnostic repository) is a system wide tracing and logging central repository.  If this is not unchecked (i.e. DIAG_ADR_ENABLED parameter is set to ON) any tracing  parameters set are ignored.
  6. Specify the trace level (support indicates detailed tracing), directory and a file name.
  7. Choose Save Network Configuration from the File menu.
Once the configuration is saved, trace information would be generated in the specified directory.

Posted on August 13, 2011, in oracle and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: