RE: Catching errors on inserts[SOLVED!]

This was solved by the knowledgeable Charlie Mengler of the list

The problem was the "="
SQL> alter session set events='0001 trace name errorstack forever,level 10' ;

Took that off and it generated me a 14M trc file!! Not pretty but it worked....

Thanks to all who helped with this

Best regards bob

> Ok Im having a problem with this
>
> [from init.ora]
> user_dump_dest = D:\db_track2data\admin\LTRACK2\udump
>
> [recommended from a user on this list]
> select name, value
> from v$parameter
> where name like '%dump%' ;
>
> NAME VALUE
> ----------------------------------------------------------------
> ---------------------------------------
> background_dump_dest
> D:\db_track2data\admin\LTRACK2\bdump
> user_dump_dest
> D:\db_track2data\admin\LTRACK2\udump
> max_dump_file_size
> 204800
>
> 3 rows selected.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> I run
> SQL> alter session set events='0001 trace name errorstack forever,
> level 10' ;
> Session altered
>
> I run the 10K insert script which contains many errors
>
> No TRC file gets created in the above dir or any place for that matter
>
> I search for *.trc and "no files found"
> There must be a problem with my syntax in the alter session
> does anyone see a problem
>
> Thanks
> bob
>
> > check your init.ora setting for user_dump_dest (I believe).
> >
> > Anjo.
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, August 21, 2002 8: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
> > > > > SQL> 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: 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: 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).