星期二, 五月 15, 2007

oerr的使用方法

[oracle@odex1 ~]$ 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.
[oracle@odex1 ~]$ which oerr
/u01/oracle/ora920/bin/oerr
[oracle@odex1 ~]$ oerr ora 6000
06000, 00000, "NETASY: port open failure"
// *Cause: Autologin unable to open port
// *Action: Check log file for OS-specific error code
[oracle@odex1 ~]$ oerr ora 600
00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause: This is the generic internal error number for Oracle program
// exceptions. This indicates that a process has encountered an
// exceptional condition.
// *Action: Report as a bug - the first argument is the internal error number
[oracle@odex1 ~]$

[oracle@odex1 ~]$ oerr ora 1102
01102, 00000, "cannot mount database in EXCLUSIVE mode"
// *Cause: Some other instance has the database mounted exclusive or shared.
// *Action: Shutdown other instance or mount in a compatible mode.
[oracle@odex1 ~]$

没有评论: