ORA-600(kjrpar:noalloc)错误

由于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.2、11.1.0.7和10.2.0.5可以避免这个错误。

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

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

 

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

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