ITPub博客

首页 > 数据库 > Oracle > ORA-600(kjbrref:pkey)错误

ORA-600(kjbrref:pkey)错误

原创 Oracle 作者:yangtingkun 时间:2012-11-27 23:46:57 0 删除 编辑

客户数据库碰到这个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.211.2.0.3Oracle11.2.0.2.811.2.0.3.1fixed了这个bug

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

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

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10438403