客户数据库碰到这个ORA-600错误，导致实例崩溃。
详细错误信息为：
Fri Nov 23 23:38:46 2012 minact-scn: Master returning AS live inst:2 has inc# mismatch instinc:4 cur:6 errcnt:0 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms1_2097994.trc (incident=1520217): ORA-00600: internal error code, arguments: [kjbrref:pkey], [7232], [107], [249516], [0], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_1520217/orcl1_lms1_2097994_i1520217.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Fri Nov 23 23:38:55 2012 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms0_2032456.trc (incident=1520209): ORA-00600: internal error code, arguments: [kjbrref:pkey], [192], [191], [249516], [0], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_1520209/orcl1_lms0_2032456_i1520209.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Fri Nov 23 23:38:55 2012 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms3_2359346.trc (incident=1520233): ORA-00600: internal error code, arguments: [kjbrref:pkey], [192], [187], [249516], [0], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_1520233/orcl1_lms3_2359346_i1520233.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Fri Nov 23 23:38:56 2012 Dumping diagnostic DATA IN directory=[cdmp_20121123233855], requested BY (instance=2, osid=2623306 (LMS1)), summary=[incident=920114]. Dumping diagnostic DATA IN directory=[cdmp_20121123233857], requested BY (instance=1, osid=2097994 (LMS1)), summary=[incident=1520217]. Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms3_2359346.trc: ORA-00600: internal error code, arguments: [kjbrref:pkey], [192], [187], [249516], [0], [], [], [], [], [], [], [] LMS3 (ospid: 2359346): terminating the instance due TO error 484 Fri Nov 23 23:39:00 2012 ORA-1092 : opitsk aborting process Fri Nov 23 23:39:00 2012 License high water mark = 128 System state dump requested BY (instance=1, osid=2359346 (LMS3)), summary=[abnormal instance termination]. System State dumped TO trace file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_diag_1638792.trc Instance TERMINATED BY LMS3, pid = 2359346 USER (ospid: 3539564): terminating the instance Instance TERMINATED BY USER, pid = 3539564 |
在ORA-600错误出现之前，出现了minact-scn: Master returning as live inst的信息，说明数据库出现了DRM。显然这个问题和DRM有直接关联。
根据MOS的文档Bug 12834027 – ORA-600 [kjbmprlst:shadow] / ORA-600 [kjbrasr:pkey] with RAC read mostly locking [ID 12834027.8]，这个问题方式在RAC环境是read-mostly object locking导致的，而解决方案就是禁止DRM或禁止read-mostly object locking：将”_gc_read_mostly_locking”隐含参数设置为FALSE。
这个问题确认影响的版本为11.2.0.2和11.2.0.3，Oracle在11.2.0.2.8和11.2.0.3.1中fixed了这个bug。