oracle 自帶錯誤提示工具oerr

參考：http://blog.csdn.net/frice/article/details/7317744

今天發現一個oracle自帶錯誤查詢工具
SQL>  !oerr ora 1555
01555, 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


該工具位於$ORACLE_HOME/bin/oerr
該工具所呼叫的錯誤資訊列表檔案為 $ORACLE_HOME/rdbms/mesg/oraus.msg
該工具不可用於windows上，經測試，9i,10g,11g,12c都有此工具。

可透過 sh -x oerr ora 1555 檢視指令碼執行過程
[oracle@oel6x64 mesg]$ sh -x oerr ora 1555
+ '[' '' = T ']'
+ '[' '!' /u01/app/oracle/12/db1 ']'
+ PERL_DIR=/u01/app/oracle/12/db1/perl
+ PERL_BIN=/u01/app/oracle/12/db1/perl/bin
+ export PERL_BIN
+ /u01/app/oracle/12/db1/perl/bin/perl /u01/app/oracle/12/db1/bin/oerr.pl ora 1555
01555, 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
+ exit 0