it's $OH/rdbms/mesg/oraus.msg. No helpful info for that event though.
Cheers. Rhojel
On 7/27/06, Schultz, Charles <sac@(protected)> wrote: > > I am thinking any of the errors can be traced with: > event="<nnn> trace name errorstack level <x>" > Not sure what the level would be for this error, but you might be able > to start with 1. > > Now I just have to wait for someone to correct me if I am wrong. =) I > know there is a mesg file in $OH that describes all the events, but for > the life of me I cannot remember it. > > -- --Original Message-- -- > From: oracle-l-bounce@(protected) > [mailto:oracle-l-bounce@(protected)] On Behalf Of Deepak Sharma > Sent: Thursday, July 27, 2006 9:58 AM > To: oracle-l@(protected) > Subject: Tracing invalid rowid ora-01410 (See ora-01410.ora-code.com) > > How do we force the generation of a trace file whenever an error > (invalid rowid ora-01410 (See ora-01410.ora-code.com)) happens in the database. Right now only some > of the ORA-01410 (See ORA-01410.ora-code.com) show up in alert log, but not all. Is there a 'alter > system set event <nnn>' that can be done to achieve this? > > Thanks, > Deepak > > __ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- > http://www.freelists.org/webpage/oracle-l > > > -- > http://www.freelists.org/webpage/oracle-l > > >
it's $OH/rdbms/mesg/oraus.msg. No helpful info for that event though.<br><br >Cheers.<br>Rhojel<br><br><div><span class="gmail_quote">On 7/27/06, <b class= "gmail_sendername">Schultz, Charles</b> <<a href="mailto:sac@(protected)"> sac@(protected)</a>> wrote:</span><blockquote class="gmail_quote" style= "border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding -left: 1ex;">I am thinking any of the errors can be traced with:<br> event="<nnn> trace name errorstack level <x>"<br>Not sure what the level would be for this error, but you might be able<br>to start with 1.<br><br>Now I just have to wait for someone to correct me if I am wrong. =) I <br>know there is a mesg file in $OH that describes all the events, but for<br >the life of me I cannot remember it.<br><br>-- --Original Message-- --<br>From: <a href="mailto:oracle-l-bounce@(protected)">oracle-l-bounce@(protected) </a><br>[mailto:<a href="mailto:oracle-l-bounce@(protected)">oracle-l-bounce @(protected)</a>] On Behalf Of Deepak Sharma<br>Sent: Thursday, July 27, 2006 9:58 AM<br>To: <a href="mailto:oracle-l@(protected)">oracle-l@(protected) </a><br>Subject: Tracing invalid rowid ora-01410 (See ora-01410.ora-code.com)<br><br>How do we force the generation of a trace file whenever an error<br>(invalid rowid ora-01410 (See ora-01410.ora-code.com)) happens in the database. Right now only some<br>of the ORA-01410 (See ORA-01410.ora-code.com) show up in alert log, but not all. Is there a 'alter <br>system set event <nnn>' that can be done to achieve this?<br><br >Thanks,<br>Deepak<br><br>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<br >Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br><a href="http://mail.yahoo.com">http://mail.yahoo.com</a><br>--<br><a href= "http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage /oracle-l</a><br><br><br>--<br><a href="http://www.freelists.org/webpage/oracle -l"> http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br>
