Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trace files
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