ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oerr命令快速查看oracle错误信息

oerr命令快速查看oracle错误信息

原创 Linux操作系统 作者:fengfeng0821 时间:2010-06-09 15:14:38 0 删除 编辑

在操作系统里,执行oerr命令可以 快读查看oracle错误号的详细解释

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.

如:

db1:/home/oracle$oerr ora 04031
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"
// *Cause:  More shared memory is needed than was allocated in the shared
//          pool.
// *Action: If the shared pool is out of memory, either use the
//          dbms_shared_pool package to pin large packages,
//          reduce your use of shared memory, or increase the amount of
//          available shared memory by increasing the value of the
//          INIT.ORA parameters "shared_pool_reserved_size" and
//          "shared_pool_size".
//          If the large pool is out of memory, increase the INIT.ORA
//          parameter "large_pool_size". 
db1:/home/oracle$oerr imp 00016
00016, 00000, "required character set conversion (type %lu to %lu) not supported"
// *Cause:  Import could not convert the character format of the export file
//          into the native character format.
// *Action: Change the user character set by setting the NLS_LANG
//          environment variable to match the character set of the export file.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10244091/viewspace-664802/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-06-09

  • 博文量
    3
  • 访问量
    12715