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

Re: no trace files generated at all

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 18 Aug 2004 19:27:49 +0200
Message-ID: <p847i0t7lbdrlpq0vm7p8d24es5ed6505h@4ax.com>


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 DBA
Received on Wed Aug 18 2004 - 12:27:49 CDT

Original text of this message

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