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.