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: ORA-00001 causes MTS (shared) server to di

Re: ORA-00001 causes MTS (shared) server to di

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 29 Apr 2004 21:25:47 +0200
Message-ID: <qjl29091v1r09vf6vc5o2dgtq9f6pnftea@4ax.com>


On Thu, 29 Apr 2004 18:52:09 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>Sybrand,
>
>Could you please elaborate on how this would help diagnose?
>
>Thanks
>
>On Wed, 28 Apr 2004 23:38:51 +0200, Sybrand Bakker
><sybrandb_at_hccnet.nl> wrote:
>
>>tOn Wed, 28 Apr 2004 20:55:53 GMT, andreyNSPAM_at_bookexchange.net
>>(NetComrade) wrote:
>>
>>>Don't know what else we can do, besides tracing every session, which
>>>is not feasible, given database traffic.
>>
>>
>>Try setting event '1 trace name errorstack level 3' in your init.ora
>>
>>
>>--
>>Sybrand Bakker, Senior Oracle DBA
>
>.......
>We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>remove NSPAM to email

It should dump the statement in error to the trace file, and the context it is called in.

It will fire only when you hit ora-0001. You can do this with any error number, BTW

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Apr 29 2004 - 14:25:47 CDT

Original text of this message

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