ORA-600(ksxp_rm_check0)错误

客户11.2.0.3 RAC的ASM实例出现ORA-600[ksxp_rm_check0]错误。

[@more@]

错误信息如下：

Tue Jul 02 19:22:59 2013
Errors in file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_6488960.trc (incident=165804):
ORA-04031: unable to allocate 3000 bytes of shared memory ("shared pool","select INSTANCE_NUMBER , IN...","sga heap(1,0)","call")
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Jul 02 19:22:59 2013
ERROR: Unable to normalize symbol name for the following short stack (at offset 174):
dbgexProcessError()+180 Errors in file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_m000_22151498.trc (incident=186272):
ORA-00600: internal error code, arguments: [ksxp_rm_check0], [0x110A6FE08], [0], [0x700000059D65FD8], [], [], [], [], [], [], [], []
Incident details in: /u01/app/grid/diag/asm/+asm/+ASM2/incident/incdir_186272/+ASM2_m000_22151498_i186272.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Jul 02 19:23:01 2013
Process m000 died, see its trace file
Tue Jul 02 19:23:01 2013
Dumping diagnostic data in directory=[cdmp_20130702192301], requested by (instance=2, osid=22151498 (M000)), summary=[incident=186272].

从错误信息上判断，这个ORA-600错误和前面出现了ORA-4031应该有直接的关系。根据MOS文档Bug 12925089 - ORA-600 [ksxp_rm_check0] can occur on process startup [ID 12925089.8]，当一个进程启动时除非了ORA-4031错误，就可能会导致ORA-600[ksxp_rm_check()]的错误。而当前是m000进程启动出现了ORA-4031错误。至于当前ASM的ORA-4031错误，是由于11.2.0.3默认的MEMORY_TARGET不足导致的。

这个错误影响的版本为11.2.0.2和11.2.0.3，Oracle在12.1.0.1中以及将要发布的11.2.0.4中解决了这个问题。其实要避免这个错误的根源是给ASM实例的MEMORY_TARGET分配足够的空间，至少应分配1536M以上。

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

转载于:http://blog.itpub.net/4227/viewspace-1060672/