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 -> no trace files generated at all

no trace files generated at all

From: Michael John <amstelchen_at_gmx.at>
Date: 18 Aug 2004 06:33:41 -0700
Message-ID: <8dbd6a8d.0408180533.6ebc32d5@posting.google.com>


Using Oracle9i EE 9.2.0.2.1, i get a "ORA-28112: failed to execute policy function".

So I was looking for a trace file, but there was nothing. user_dump_dest is correctly set in init.ora and v$parameter looks ok. According to v$parameter, these Parameters are set: trace_enabled = TRUE
sql_trace = FALSE

If I fire a
> alter session set sql_trace = true;

or similar, a
> sys.dbms_system.set_sql_trace_in_session(mysid,serial#,true);
nothing changes. I also tried
> alter session set events '10046 trace name context forever, level 1';
before.

Did I forget something important?

TIA,
mic Received on Wed Aug 18 2004 - 08:33:41 CDT

Original text of this message

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