Re: Catching errors on inserts

udump directory

Igor Neyman, OCP DBA
ineyman_at_perceptron.com   

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 21, 2002 2:43 PM

> It is in the session trace file not the alert log file.
>

Where would I find this file?

Many thanks in advance
bob
> Anjo.
>
>
> On Wednesday 21 August 2002 16:38, you wrote:
> > Gogala
> >
> > Thanks for the tip this seems like just what I'm
> looking for, however
> > I must be doing something wrong as no errors are getting
> written to my
> > <SID>alrt.log
> >
> > Im running oracle 8.16 server on win2kpro (this is a development
> > database)
> >
> > I just got around to running/testing this from my post last week
> >
> > I do
> > SQL> alter session set events='0001 trace name errorstack forever,
> > level 10';
> >
> > Session altered.
> >
> > Then I run the offending insert script which show errors
> being thrown
> >
> > I check the <SID>alrt.log in BDUMP dir and all it show are
> my regular
> > .ORA logs being written EG
> > Wed Aug 21 09:19:07 2002
> > Thread 1 advanced to log sequence 3240
> > Current log# 4 seq# 3240 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> > Thread 1 advanced to log sequence 3241
> > Current log# 1 seq# 3241 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> > Thread 1 advanced to log sequence 3242
> > Current log# 2 seq# 3242 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> > Thread 1 advanced to log sequence 3243
> >
> > Also checked the <SID>alrt.log in Oracle\home\database
> Nothing written
> > there
> >
> > What am I missing?
> >
> > > alter session set events='0001 trace name errorstack
> forever, level
> > > 10'; All "duplicate value" errors will then be trapped in the
> > > alert.log file. You can always substitute your own
> favorite error in
> > > place of 0001.
> >
> > Also If you have a extra min how can I substitute the error message?
> >
> > Thanks for your help
> >
> > Bob
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).