The steps for Sql*net trace on the Oracle client side and the attention points
Reference article:
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\cl Ient_1
Steps for Sql*net Trace
First, add the parameters in the Sqlnet.ora file:
In the F:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora file, add the following:
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 the point:
1. Trace_directory_client's path to its own discretion
2. Above 8 parameters, each parameter must shelf write, namely: Do not start with a space
3. F:\oracle\product\10.2.0\client_1\network\trace do not write F:\oracle\product\10.2.0\client_1\network\trace\, that is to say: do not \ End
4. Start with # to indicate comments.
Second, start running the application (Sqlplus,plsql developer, etc.)
Attention:
The point of caution here is to avoid the following situations:
Before you start running Plsql Developer, Plsql Developer is in the log off state: There are plsql Developer programs in the Windows taskbar, but Plsql Developer is actually not connected to the database. In this state, Plsql Developer Enter the user name and password, although can be successfully logged into the database, but Sql*net trace is not generated log.
Be sure to follow the description below:
Use the newly opened Plsql developer to do sql*net trace, without the plsql developer that already exists in the Windows taskbar to log into the database (that is, without the plsql that already exists in the Windows taskbar) Developer do sql*net Trace. )
Third, close the tracking:
Open the F:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora file and use any of the following methods to turn off tracing:
(a) Trace_level_client = OFF
(b) Remove the tracing that you added in Sqlnet.ora parameters
(c) Add # to the front of the parameter and comment out the tracing parameters
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Steps for Sql*net trace on the Oracle client side and note points