Re: no trace files generated at all

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 19 Aug 2004 14:17:42 +0200
Message-ID: <cg25d4$6v6$1@news5.tilbu1.nb.home.nl>

Sybrand Bakker wrote:

> 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.

Nope - just -20000 thru -20999

> 
> 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.
> 

It's just what it says: a policy error.
Looks like a policy is in place, probably enforced by a on-logon trigger. I'd look there (as SYS) for starters.
Also - an invalid (policy) function may cause this error; see if all functions/procedures are valid

-- 

Regards,
Frank van Bortel

Received on Thu Aug 19 2004 - 07:17:42 CDT