ORA-600(kjbrref:pkey)错误

客户数据库碰到这个ORA-600错误，导致实例崩溃。

[@more@]

详细错误信息为：

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。

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

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