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" <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
