RE: Tracing invalid rowid ora-01410
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 27 Jul 2006 14:49:26 -0700 (PDT)
Try this:
alter system set events '1410 trace name errorstack
forever, level 3';
Thanks,
Sai
http://sai-oracle.blogspot.com
* To: <sharmakdeep_oracle@xxxxxxxxx>,
<oracle-l@xxxxxxxxxxxxx>
* Date: Thu, 27 Jul 2006 10:55:13 -0500
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
--
//www.freelists.org/webpage/oracle-l
__________________________________________________
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: