oerr 命令的使用
维护数据库中经常遇到问题，查错很麻烦，有时候只能看到错误代码，现在介绍一个实用的命令 oerr 溢出错误
oerr是一个简单而使用的命令工具，linux/unix 都可以使用，此命令可以根据错误代码快速查询到该错误的概要描述，根据该描述定位问题原因，也可以到metlink上查询错误信息：
eg（溢出一个ora-600的错误）：
[oracle@oracle11g ~]$ oerr ora 600
00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause: This is the generic internal error number for Oracle program
// exceptions. It indicates that a process has encountered a low-level,
// unexpected condition. The first argument is the internal message
// number. This argument and the database version number are critical in
// identifying the root cause and the potential impact to your system.
//
// *Action: Visit My Oracle Support to access the ORA-00600 Lookup tool
// (reference Note 600.1) for more information regarding the specific
// ORA-00600 error encountered.
//
// An Incident has been created for this error in the Automatic
// Diagnostic Repository (ADR). When logging a service request, use
// the Incident Packaging Service (IPS) from the Support Workbench
// or the ADR Command Interpreter (ADRCI) to automatically package the
// relevant trace information (reference My Oracle Support Note 411.1).
//
// The following information should also be gathered to help determine
// the root cause:
// - changes leading up to the error
// - events or unusual circumstances leading up to the error
// - operations attempted prior to the error
// - conditions of the operating system and databases at the time
// of the error
//
// Note: The cause of this message may manifest itself as different
// errors at different times. Be aware of the history of errors that
// occurred before this internal error.
06512, 00000, "at %sline %s"
// *Cause: Backtrace message as the stack is unwound by unhandled
// exceptions.
// *Action: Fix the problem causing the exception or write an exception
// handler for this condition. Or you may need to contact your
// application administrator or DBA.
溢出一个rman的错误：
[oracle@oracle11g ~]$ oerr rman 1007
[oracle@oracle11g ~]$ oerr rman 1007
1007, 1, "at line %d column %d file: %s"
// *Cause: This is an informational message indicating the line
// and column where a syntax error was detected.
// *Action: No action is required.
溢出一个TNS的错误：
[oracle@cw ~]$ oerr TNS 12535
12535, 00000, "TNS:operation timed out"
// *Cause: The requested operation could not be completed within the time out
// period.
// *Action: Look at the documentation on the secondary errors for possible
// remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
// Turn on tracing to gather more information.
溢出一个EXP的错误：
[oracle@cw ~]]$ oerr exp 00091
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对错误的定位不够精准，具体问题还得具体分析。
--------------------------------------------------------------------------------------------
版权所有，转载请注明作者及原文链接，否则追究法律责任!
QQ: 584307876
作者: Seven
原文链接: http://blog.csdn.net/sunjiapeng/article/details/8433894
邮箱: seven_ginna@foxmail.com