Re: SQL*NET Tracing

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sat, 28 Feb 2004 13:43:21 +0100
Message-ID: <c1q2a9$gv0$1@news3.tilbu1.nb.home.nl>

Jaffery wrote:

> Hi Pete
>
> Thanks for your information?
> With regards to my problem,would you have a tracing script that I can use?
>
> Thanks
>
> David
>
>
>
>
>
>
>
> ews:<H3KBlqANs5PARx4E_at_peterfinnigan.demon.co.uk>...
>

>>>With regards to an Oracle database, I like to ask how we do SQL* NET tracing.
>>>Where should I find the SQL*Net Tracing files?
>>>
>>>Thanks
>>>
>>>David
>>
>>Hi David,
>>
>>Have a look at a paper I wrote last year called "Detecting SQL Injection
>>in Oracle" - there is an example of using SQL*Net trace in there. Its at
>>http://www.petefinnigan.com/orasec.htm
>>
>>hth
>>
>>kind regards
>>
>>Pete

Find sqlnet.ora (%OH%\network\admin would be the standard location) Edit it, add/modify:
trace_level_client = (either numeric, or string) String values = OFF ( == 0), USER ( == 4), ADMIN (==10), SUPPORT (==16)

trace_directory_client (where do you want the trace file to be)

trace_file_client (fully qualified trace name)

What is allowed and possible is also documented in the sqlnet.ora file you can find in the SAMPLE subdirectory of the above standard directory

-- 

Regards,
Frank van Bortel

Received on Sat Feb 28 2004 - 06:43:21 CST