ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Reported By M00x And Shadow Processes

Reported By M00x And Shadow Processes

原创 Linux操作系统 作者:bearcanfly123 时间:2011-11-04 11:24:39 0 删除 编辑
ORA-00600: internal error code, arguments: [kcblin_3], [103], [1040384], [8192], [8193], [312], [616], [], [], [], [], []
 
The issue was caused by a wrong database configuration related to memory parameters. There was implemented Automatic Memory Management of SGA and PGA through MEMORY_TARGET and in the same time there were set manual values for PGA workareas:

For example:
memory_target =
sort_area_size =
hash_area_size =
workarea_size_policy = "MANUAL"
 
In PFILE/SPFILE remove:

sort_area_size =
hash_area_size =
workarea_size_policy = "MANUAL"

and restart the instance with modified parameters file.

The manual values were ignored (even if set) but they caused ORA-600 [kcblin_3] errors.

Removing the above parameters fixed the errors.

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

下一篇: greenplum 4.22配置
请登录后发表评论 登录
全部评论

注册时间:2011-06-27

  • 博文量
    16
  • 访问量
    80017