oerr是oracle在unix上的查找ora错误的小工具，极其方便。
命令格式为：oerr ora 错误编号
命令格式为：oerr ora 错误编号
1 .先看看OERR 的位置
$ which oerr
/oradev2/app/oracle/product/10.2.0/bin/oerr
$ which oerr
/oradev2/app/oracle/product/10.2.0/bin/oerr
2.看OERR 的使用方法
$ 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.
$ oerr ora 7300
$ 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.
$ oerr ora 7300
3.随便测试一个ORA 的错误
$ oerr ora 3200
03200, 00000, "the segment type specification is invalid"
// *Cause: segment type is not TABLE, INDEX, or CLUSTER
// *Action: use a correct segment type
$ oerr ora 3200
03200, 00000, "the segment type specification is invalid"
// *Cause: segment type is not TABLE, INDEX, or CLUSTER
// *Action: use a correct segment type
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/751371/viewspace-678147/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- #奋斗故事#我在魔都的IT经历
- ASH内存强制Flush日志解决一例
- Linux 6.2 安装Oracle 10g ORA-27125:unable to create shared memory segment
- HP UNIX 11.23 Itanium 64 for oracle 9i
- 2014年第1季度Oracle PSU更新(For 10.2.0.4+版本)
- Oracle 11g opiodr aborting process unknown ospid (***) as a result of ORA-28
- ORACLE 11.2 RAC EXPDP ORA-31693: 表数据对象 ORA-31617: 无法打开要写入的转储文件
- 常用的Linux可插拔认证模块（PAM）应用举例
- ORA-04030: out of process memory when trying to allocate **bytes (sort subheap)
- Oracle OS Watcher 工具 使用详解
