ITPub博客

首页 > 数据库 > Oracle > ORA-600(ksxp_rm_check0)错误

ORA-600(ksxp_rm_check0)错误

原创 Oracle 作者:yangtingkun 时间:2013-07-04 23:54:42 0 删除 编辑

客户11.2.0.3 RACASM实例出现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<-dbgeExecuteForError()+72<-dbgePostErrorKGE()+2048<-dbkePostKGE_kgsf()+68<-kgeadse()+380<-kgerinv_internal()+48<-kgerinv()+48<-kgeasnmierr()+72<-IPRA.$ksxp_rm_check()+188<-ksxp_rm_check()+80<-ksliwat()+9376<-kslwaitctx()+180<-kmgs_immediate_req()+2396<-ksmasg()+144<-kghnospc()+632<-kghalo()+1964<-ksmdacnk()+276<-ksmdget()+628<-kssadpm()+324<-ksucrp()+904<-ksvrdp()+156<-opirip()+724<-opidrv()+608<-sou2o()+136<-opimai_real()+188<-ssthrdmain()+268<-main()+204<-__start()+112
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错误。至于当前ASMORA-4031错误,是由于11.2.0.3默认的MEMORY_TARGET不足导致的。

这个错误影响的版本为11.2.0.211.2.0.3Oracle12.1.0.1中以及将要发布的11.2.0.4中解决了这个问题。其实要避免这个错误的根源是给ASM实例的MEMORY_TARGET分配足够的空间,至少应分配1536M以上。

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

下一篇: ORA-7445(opipls)错误
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10438269