Oracle oerr工具的使用

oerr可以在Linux和UNIX操作系统上查询简短的报错信息的含义，可以很好的辅助排查oracle故障。

1.查询该命令的位置

[oracle@db11g1 ~]$ which oerr/u01/app/oracle/product/11.2/db_1/bin/oerr

2.如何使用

[oracle@db11g1 ~]$ oerrUsage: oerr facility errorFacility is identified by the prefix string in the error message.For example, if you get ORA-7300, "ora" is the facility and "7300"is the error.  So you should type "oerr ora 7300".If you get LCD-111, type "oerr lcd 111", and so on.

3.oerr简单使用

[oracle@db11g1 ~]$ oerr ora 0155501555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"// *Cause: rollback records needed by a reader for consistent read are//         overwritten by other writers// *Action: If in Automatic Undo Management mode, increase undo_retention//          setting. Otherwise, use larger rollback segments