Reported By M00x And Shadow Processes

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

转载于:http://blog.itpub.net/25223017/viewspace-710216/