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 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).

Reply via email to