Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: no trace files generated at all
On 18 Aug 2004 06:33:41 -0700, amstelchen_at_gmx.at (Michael John) wrote:
>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
No apparently 28112 is an end-user error. Actually IIRC all errors beyond 20000 are self-generated errors.
You can generate a trace file for any error using alter session set events '<error number> errorstack context forever, level 1', IIRC. Search for 'errorstack' on Metalink.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Aug 18 2004 - 12:27:49 CDT