| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tracing invalid rowid ora-01410
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_at_yahoo.com'; oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deepak Sharma
Sent: Thursday, July 27, 2006 9:58 AM
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 27 2006 - 10:55:13 CDT
 |
 |