oracle排错工具oerr

在oracle日志文件中经常遇到一些错误代码，可以通过oerr工具来很好的辅助查看代码错误信息

方法：

1。  office:idsadm 9> oerr ora 30012

30012, 00000, "undo tablespace '%s' does not exist or of wrong type"

// *Cause:   the specified undo tablespace does not exist or of the

//           wrong type.

// *Action:  Correct the tablespace name and reissue the statement.

office:idsadm 10> cd /

office:idsadm 11> oerr ora 30012

30012, 00000, "undo tablespace '%s' does not exist or of wrong type"

// *Cause:   the specified undo tablespace does not exist or of the

//           wrong type.

// *Action:  Correct the tablespace name and reissue the statement.

2.oerr位于$ORACLE_HOME/bin目录下，切换到oracle的管理用户下可以直接使用该工具（如果不行，可检查环境变量是否设置正确）