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"
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.
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博客 ” ,链接:http://blog.itpub.net/25223017/viewspace-710216/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25223017/viewspace-710216/