问题描述
第一次碰到Exadata上的bug。
数据库环境Exadata V2-2,数据库版本为11.2.0.2,错误信息为:
Wed Apr 25 11:32:35 2012 Errors IN file /u01/app/oracle/diag/rdbms/ods/orcl2/trace/orcl2_ora_9495.trc (incident=304808): ORA-00600: internal error code, arguments: [kffmXpGet], [145], [69784], [], [], [], [], [], [], [], [], [] ORA-03135: connection lost contact Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_304808/orcl2_ora_9495_i304808.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. opidcl aborting process UNKNOWN ospid (9495) AS a RESULT OF ORA-600 Wed Apr 25 11:32:36 2012 Dumping diagnostic DATA IN directory=[cdmp_20120425113236], requested BY (instance=2, osid=9495), summary=[incident=304808]. Wed Apr 25 11:32:36 2012 Sweep [inc][304808]: completed Sweep [inc2][304808]: completed Wed Apr 25 11:32:39 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_pmon_10797.trc (incident=302224): ORA-00600: internal error code, arguments: [kffmXpGet], [181], [87276], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_302224/orcl2_pmon_10797_i302224.trc Dumping diagnostic DATA IN directory=[cdmp_20120425113240], requested BY (instance=2, osid=10797 (PMON)), summary=[incident=302224]. USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_pmon_10797.trc: ORA-00600: internal error code, arguments: [kffmXpGet], [181], [87276], [], [], [], [], [], [], [], [], [] PMON (ospid: 10797): terminating the instance due TO error 472 Wed Apr 25 11:32:41 2012 opiodr aborting process UNKNOWN ospid (11248) AS a RESULT OF ORA-1092 Wed Apr 25 11:32:41 2012 opiodr aborting process UNKNOWN ospid (1967) AS a RESULT OF ORA-1092 Wed Apr 25 11:32:42 2012 ORA-1092 : opitsk aborting process Wed Apr 25 11:32:43 2012 License high water mark = 573 Instance TERMINATED BY PMON, pid = 10797 USER (ospid: 8755): terminating the instance Instance TERMINATED BY USER, pid = 8755
专家解答
由于ORA-600[kffmXpGet]错误的出现,最终出现了ORA-1092的错误,并致使opitsk进程退出,导致数据库实例崩溃。
Oracle在MOS文档Bug 12387467 instance crash by ORA-600 [kffmxpget]中描述了这个问题,确认影响的版本为11.2.0.1、11.2.0.2、11.2.0.3,Oracle在11.2.0.2 的Bundle Patch 16 for Exadata以及11.2.0.3 Bundle Patch 5 for Exadata中fixed了这个问题,Oracle计划在11.2.0.4和12.1中彻底Fixed该问题。
这个错误只会发生在Exadata中,因为导致错误的原因和Smart Scan有关。当会话执行Smart Scan操作时使用了Ctrl + C中止该操作,会导致PMON进程出现这个600错误。Oracle建议在执行数据文件的SHRINK操作前,中止并退出所有执行Exadata Smart Scan的会话。
最后修改时间:2019-04-14 11:01:54
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。