由于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。
从数据库的初始化参数进行分析，这个数据库的共享池配置确实不足，因此在短时间无法升级的情况下，增大共享池的内存设置是目前避免这个问题的最好办法。
Pingback: ORA-600(1616)和ORA-569错误 | yangtingkun