Oerr Tool Usage Summary

Oerr can query the Linux and UNIX operating system short error message meaning, can be a good help to troubleshoot Oracle failure.

How to use 1.oerr
[email protected] ~]$ oerr ora 12571
12571, 00000, "Tns:packet writer failure"
//*cause:an error occurred during adatasend.
//*action:not normally visible to the user. For further details, turn
//On tracing and reexecute the operation. If error persists, contact
//Oracle Customer support.

2. Use the which command to query the location of the Oerr tool
[email protected]/home/oracle$ which Oerr
/u01/app/oracle/product/10.2/db10g/bin/oerr

< Span style= "Color:rgb (51,51,51); Line-height:26px;background-color:rgb (255,255,255); font-family: ' Courier New ';" >3. Take a look at the contents of this script file record
[email protected]/home/oracle$ vi/u01/app/oracle/product/10.2/db10g/bin/oerr

< Span style= "Color:rgb (51,51,51); Line-height:26px;background-color:rgb (255,255,255); font-family: ' Courier New ';" > script msg_file= $ORACLE _home/$Component/mesg/${facility}us.msg
It seems to imply that all of the retrieved information is from these *.msg files

< Span style= "Color:rgb (51,51,51); Line-height:26px;background-color:rgb (255,255,255); font-family: ' Courier New ';" > 4. Use the Find command in the Oracle_home directory to find the msg file

[Oracl[email protected] mesg]$ find $ORACLE _home-name MESG

/oracle/app/oracle/dbhome/network/mesg

/oracle/app/oracle/dbhome/has/mesg

/oracle/app/oracle/dbhome/usm/mesg

/oracle/app/oracle/dbhome/nls/mesg

/oracle/app/oracle/dbhome/racg/mesg

/oracle/app/oracle/dbhome/css/mesg

/oracle/app/oracle/dbhome/srvm/mesg

/oracle/app/oracle/dbhome/olap/mesg

/oracle/app/oracle/dbhome/oracore/mesg

/oracle/app/oracle/dbhome/plsql/mesg

/oracle/app/oracle/dbhome/ldap/mesg

/oracle/app/oracle/dbhome/sqlplus/mesg

/oracle/app/oracle/dbhome/ord/mesg

/oracle/app/oracle/dbhome/crs/mesg

/oracle/app/oracle/dbhome/odbc/mesg

/oracle/app/oracle/dbhome/xdk/mesg

/oracle/app/oracle/dbhome/mesg

/oracle/app/oracle/dbhome/precomp/mesg

/oracle/app/oracle/dbhome/slax/mesg

/oracle/app/oracle/dbhome/csmig/mesg

/oracle/app/oracle/dbhome/ctx/mesg

/oracle/app/oracle/dbhome/rdbms/mesg

/oracle/app/oracle/dbhome/opmn/mesg

[Email protected] mesg]$ cd/oracle/app/oracle/dbhome/rdbms/mesg/

[[email protected] mesg]$ ls *.msg

Amduus.msg dgmus.msg gimus.msg kfodus.msg kopus.msg nidus.msg oraus.msg sbtus.msg udius.msg

Asmcmdus.msg diaus.msg impus.msg kfsgus.msg kupus.msg ocius.msg qsmus.msg smgus.msg ulus.msg

Dbvus.msg expus.msg kfedus.msg kgpus.msg lcdus.msg opwus.msg rmanus.msg udeus.msg

The. MSB format file is a binary file.

From the above msg format file, you can see the type of error message that Oerr can query. For example:

Oraus.msg corresponds to the ora error,

$ oerr LRM 112

0, "Multiple values not allowed for parameter '%.*s '"

*cause:an attempt was made to specify multiple values for a parameter which

Can take only one value.

*action:do not specify more than one value for this parameter.

This is an error that could be caused by using the directory parameter when using EXPDP.

$ OERR Exp 91

00091, 00000, "exporting questionable statistics."

*cause:export was able Export statistics, but the statistics

Usuable. The statistics is questionable because one or more of

The following happened during Export:a row error occurred, client

Character set or Ncharset does not match with the server, a query

Clause was specified on export, only certain partitions or

Subpartitions were exported, or a fatal error occurred while

Processing a table.

*action:to Export non-questionable Statistics, change the client character

Set or Ncharset to match the server, export with no query clause,

Export Complete tables. If desired, import parameters can be

Supplied so then only non-questionable statistics'll be imported,

And all questionable statistics would be recalculated.

$ oerr Imp 17

00017, 00000, "following statement failed with ORACLE error%lu:"

*cause:import failed to execute the statement from the export file

Because of an Oracle error.

*action:look up the accompanying Oracle message in the ORA message

Chapters of this manual and take appropriate action.

This is an error that can occur when using exp and IMP

There are many errors that Oerr can retrieve, including CLSR, OCI, TNS, Ude, and so on. But these are not stated in Oracle's official documentation.

Oerr Tool Usage Summary