1.查询该命令的位置
[oracle@db11g1 ~]$ which oerr
/u01/app/oracle/product/11.2/db_1/bin/oerr
[oracle@db11g1 ~]$ oerr
Usage: oerr facility error
Facility 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 01555
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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26390465/viewspace-1793127/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
