维护数据库中经常遇到问题，查错很麻烦，有时候只能看到错误代码，现在介绍一个实用的命令 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.
[oracle@oracle11g ~]$ oerr ora 6512 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 0009100091, 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转载于:https://www.cnblogs.com/seven-dba/archive/2012/12/25/4354933.html
相关资源：JAVA上百实例源码以及开源项目