Tuesday, September 23, 2008

OERR Utility to Diagnosis the Problem

OERR Stands for Oracle Error.It is used to diagnosis the problem

oradev@aplerp4 # cd $ORACLE_HOME/bin
oradev@aplerp4 # oerr ora 00060
00060, 00000, "deadlock detected while waiting for resource"
// *Cause: Transactions deadlocked one another while waiting for resources.
// *Action: Look at the trace file to see the transactions and resources
// involved. Retry if necessary.

oradev@aplerp4 # oerr ora 01555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"
// *Cause: rollback records needed by a reader for consistent read are
// overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
// setting. Otherwise, use larger rollback segments

oradev@aplerp4 # oerr ora 1652
01652, 00000, "unable to extend temp segment by %s in tablespace %s"
// *Cause: Failed to allocate an extent for temp segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
// files to the tablespace indicated.
Srinivas Ramineni
Oracle Applications DBA

3 comments: