Steps and notes for SQL * Net trace on the Oracle client, oracletrace
Steps and notes for SQL * Net trace on the Oracle client
References:
How to Perform Client-Side Tracing of Programmatic Interfaces on Windows Platforms (Document ID 216912.1)
My environment:
Oracle Database Server: OEL5.4 32bit, Oracle Database 11.1.0.7 32bit
Oracle Database Client: Windows 7 64bit, Oracle Client 10.2.0.4 32bit, The ORACLE_CLIENT_HOME is located at: F: \ oracle \ product \ 10.2.0 \ client_1
SQL * Net trace steps
1. Add parameters to the sqlnet. ora file:
Add the following content to the F: \ oracle \ product \ 10.2.0 \ client_1 \ network \ admin \ sqlnet. ora file:
TRACE_UNIQUE_CLIENT = ONTRACE_LEVEL_CLIENT = 16TRACE_DIRECTORY_CLIENT = F:\oracle\product\10.2.0\client_1\network\traceTRACE_FILE_CLIENT = SQLNetTraceTRACE_TIMESTAMP_CLIENT = ON#DIAG_ADR_ENABLED = OFF#TRACE_FILELEN_CLIENT = 2048#TRACE_FILENO_CLIENT = 2
Note:
1. The TRACE_DIRECTORY_CLIENT path is random.
2. For the above eight parameters, each parameter must be written in the top case, that is, do not start with a space
3. F: \ oracle \ product \ 10.2.0 \ client_1 \ network \ trace should not be written as F: \ oracle \ product \ 10.2.0 \ client_1 \ network \ trace \, that is, do not end \
4. Comments starting.
2. Start running the application (sqlplus, PLSQL Developer, etc)
Note:
Note that the following situations must be avoided:
Before starting to run PLSQL Developer, PLSQL Developer is in the Log Off state, that is, there is a PLSQL Developer Program in the Windows taskbar, but PLSQL Developer is not actually connected to the database. In this state, PLSQL Developer can log on to the database smoothly after entering the user name and password, but SQL * Net trace does not generate logs.
Be sure to follow the descriptions below:
Use the newly opened PLSQL Developer for SQL * Net trace, and do not use PLSQL Developer in the Windows taskbar to log on to the database (I .e: you do not need to use PLSQL Developer in the Windows taskbar to execute SQL * Net trace .)
3. Disable tracking:
Open the F: \ oracle \ product \ 10.2.0 \ client_1 \ network \ admin \ sqlnet. ora file and use any of the following methods to disable tracking:
(A) TRACE_LEVEL_CLIENT = OFF
(B) remove the tracing parameters you added in sqlnet. ora.
(C) Add # At the beginning of the parameter and comment out tracing parameters.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.