第一次碰到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的会话。