Shulou(Shulou.com)06/01 Report--

Oerr can query the meaning of short error messages on Linux and UNIX operating systems, which can assist in troubleshooting Oracle faults.

How to use 1.oerr

[oracle@BJS ~] $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.

two。 Use the which command to query the location of the oerr tool

Secooler@testdb / home/oracle$ which oerr

/ u01/app/oracle/product/10.2/db10g/bin/oerr

3. Take a look at the contents of this script file.

Secooler@testdb / home/oracle$ vi / u01/app/oracle/product/10.2/db10g/bin/oerr

82 Msg_File=$ORACLE_HOME/$Component/mesg/$ {Facility} us.msg in script

It seems to imply that all the retrieved information comes from these * .msg files.

4. Use the find command to find the msg file in the ORACLE_HOME directory

[oracle@NcDbEmulator 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

[oracle@NcDbEmulator mesg] $cd / oracle/app/oracle/dbhome/rdbms/mesg/

[oracle@NcDbEmulator 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

Files in .msb format are binary files.

From the above files in msg format, you can see the types of error messages that oerr can query. For example:

Oraus.msg corresponds to ORA error

$oerr lrm 112

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 may occur when using the directory parameter incorrectly when using expdp.

$oerr exp 91

00091, 00000, "Exporting questionable statistics."

/ / * Cause: Export was able export statistics, but the statistics may not be

/ / usuable. The statistics are 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 that only non-questionable statistics will be imported

/ / and all questionable statistics will 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 may occur when using EXP and IMP

There are many other errors that OERR can retrieve, including CLSR, OCI, TNS, UDE, and so on. But these are not stated in the official Oracle documentation.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.