RE: Tracing invalid rowid ora-01410

  • From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>
  • To: sac@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 27 Jul 2006 09:24:56 -0700 (PDT)

Thanks all.

I was able to generate trace file with the following:

SQL> alter system set events '1410 trace name
errorstack level 3';

Deepak

--- oracle-l-bounce@xxxxxxxxxxxxx wrote:

> The message file is:
> $ORACLE_HOME/rdbms/mesg/oraus.msg
> I only mention it because I have been led to believe
> that you can trace
> any of those events/messages.
> OBVIOUS WARNING: Be careful with some of those -
> Oracle has stated that
> you should only set them with direction from Oracle
> Support
> 
> 
> -----Original Message-----
> From: Schultz, Charles 
> Sent: Thursday, July 27, 2006 10:16 AM
> To: 'sharmakdeep_oracle@xxxxxxxxx';
> oracle-l@xxxxxxxxxxxxx
> Subject: RE: Tracing invalid rowid ora-01410
> 
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Deepak Sharma
> Sent: Thursday, July 27, 2006 9:58 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Tracing invalid rowid ora-01410
> 
> How do we force the generation of a trace file
> whenever an error
> (invalid rowid ora-01410) happens in the database.
> Right now only some
> of the ORA-01410 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 
--
//www.freelists.org/webpage/oracle-l


Other related posts: