Linux/Uninx下Oracle的oerr工具的使用

Linux/Uninx下Oracle的oerr工具的使用

oerr是oracle在unix上的查找ora错误的小工具，极其方便。
命令格式为：
oerr ora 错误编号
例如要查看ora-01578的错误描述：

[oracle@linusfay-up ~]$ oerr ora 01578

01578, 00000, "ORACLE data block corrupted (file # %s, block # %s)"
// *Cause:  The data block indicated was corrupted, mostly due to software
//          errors.
// *Action: Try to restore the segment containing the block indicated. This
//          may involve dropping the segment and recreating it. If there
//          is a trace file, report the errors in it to your ORACLE
//          representative.