The steps to sql*net trace on the Oracle client side and the attention points

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.