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