ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(kjrpar:noalloc)错误

ORA-600(kjrpar:noalloc)错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-02-29 23:21:09 0 删除 编辑

由于ORA-4031引发的ORA-600错误。

 

 

告警日志中错误如下:

Sat Jan 28 06:07:49 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc:
ORA-12012: error on auto execute of job 66
ORA-04031: unable to allocate 6592 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP")
Sat Jan 28 06:08:15 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc:
ORA-12012: error on auto execute of job 87
ORA-04031: unable to allocate 6592 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP")
Sat Jan 28 06:08:50 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc:
ORA-12012: error on auto execute of job 66
ORA-04031: unable to allocate 6592 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP")
Sat Jan 28 06:09:50 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc:
ORA-12012: error on auto execute of job 66
ORA-04031: unable to allocate 6592 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP")
Sat Jan 28 06:10:15 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc:
ORA-12012: error on auto execute of job 87
ORA-04031: unable to allocate 6592 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP")
Sat Jan 28 06:10:51 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_j000_21874.trc:
ORA-12012: error on auto execute of job 66
ORA-04031: unable to allocate 6592 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL MPCODE","PKR: PL_UEP")
Sat Jan 28 06:11:34 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lmd0_24470.trc:
ORA-00600: internal error code, arguments: [kjrpar:noalloc], [1], [385], [0x1066F8850], [0x956F0C4C0], [0x94A9BE408], [], []
Sat Jan 28 06:11:35 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lmd0_24470.trc:
ORA-00600: internal error code, arguments: [kjrpar:noalloc], [1], [385], [0x1066F8850], [0x956F0C4C0], [0x94A9BE408], [], []
Sat Jan 28 06:11:35 2012
Trace dumping is performing id=[cdmp_20120128061135]
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lmd0_24470.trc:
ORA-00600: internal error code, arguments: [kjrpar:noalloc], [1], [385], [0x1066F8850], [0x956F0C4C0], [0x94A9BE408], [], []
Sat Jan 28 06:11:41 2012
LMD0: terminating instance due to error 482
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_pmon_24462.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lms2_24480.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lms5_24505.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lmon_24468.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lms3_24492.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lms0_24472.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lms4_24496.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lms1_24476.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_cjq0_24533.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_ckpt_24527.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:41 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_mman_24509.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:42 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_dbw0_24511.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:42 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lck0_24724.trc:
ORA-00482: LMD* process terminated with error
Sat Jan 28 06:11:42 2012
Errors in file /export/home/OracleHomes/admin/jykfdb/bdump/jykfdb1_lgwr_24517.trc:
ORA-00482: LMD* process terminated with error

根据MOS描述,这个ORA-600的错误源于ORA-4031错误:ORA-600[kjrpar:noalloc] Error Raised in the LMD Process [ID 864377.1]。升级到11.211.1.0.710.2.0.5可以避免这个错误。

虽然导致错误的本质是ORA-4031,但是当前的这个错误引发了LMD进程的异常退出,并最终导致数据库的崩溃,因此对于当前的数据库而言,这个错误的严重程度甚至更甚于ORA-4031

从数据库的初始化参数进行分析,这个数据库的共享池配置确实不足,因此在短时间无法升级的情况下,增大共享池的内存设置是目前避免这个问题的最好办法。

 

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

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10352060