Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: trace files

Re: trace files

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Fri, 5 Mar 2004 10:11:37 +0000
Message-ID: <mLSJq4AZJFSARx3+@peterfinnigan.demon.co.uk>


Hi

are you saying that this session is just producing trace now or are you saying that if it logs off and then logs on again trace is set?

If the latter then set SQL*net trace before you log in and look at the trace and see what commands your application is sending to the server. That is look for any of the common ways to set Oracle trace. You can see how to set SQL*Net trace in a paper i wrote called "Detecting SQL injection in Oracle" on http://www.petefinnigan.com/orasec.htm and also I have just written a paper describing most of the ways to set trace in Oracle for your session or anothers - maybe you could have a look at that as well and see if any of the methods are used on you SQL*Net trace - is called "How to set trace for others sessions, for your own session and at instance level"
it's at http://www.petefinnigan.com/ramblings/how_to_set_trace.htm

One other thought, check the alert log and see if it is actually an error that is occurring and if that error is generating a trace file as well.

Hope this helps a bit

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
Received on Fri Mar 05 2004 - 04:11:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US