问题描述
客户11.2.0.2 RAC for Solaris10上的错误。
错误信息为:
2012-05-04 22:00:04.768000 +08:00 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" 2012-05-04 22:00:17.279000 +08:00 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_5730.trc (incident=231810): ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_231810/orcl1_j002_5730_i231810.trc 2012-05-04 22:01:38.428000 +08:00 Dumping diagnostic DATA IN directory=[cdmp_20120504220138], requested BY (instance=1, osid=5730 (J002)), summary=[incident=231810]. USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Sweep [inc][231810]: completed Sweep [inc2][231810]: completed
专家解答
查询详细信息:
$ more /oracle/diag/rdbms/orcl/orcl1/incident/incdir_231810/orcl1_j002_5730_i231810.trc Dump file /oracle/diag/rdbms/orcl/orcl1/incident/incdir_231810/orcl1_j002_5730_i231810.trc Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production WITH the Partitioning, REAL Application Clusters, OLAP, DATA Mining AND REAL Application Testing options ORACLE_HOME = /oracle/product/11.2.0/dbhome_1 System name: SunOS Node name: racdb1 Release: 5.10 Version: Generic_142900-14 Machine: sun4u Instance name: orcl1 Redo thread mounted BY this instance: 1 Oracle process NUMBER: 129 Unix process pid: 5730, image: oracle@racdb1 (J002) *** 2012-05-04 22:00:17.299 *** SESSION ID:(25.62649) 2012-05-04 22:00:17.299 *** CLIENT ID:() 2012-05-04 22:00:17.299 *** SERVICE NAME:(SYS$USERS) 2012-05-04 22:00:17.299 *** MODULE NAME:(DBMS_SCHEDULER) 2012-05-04 22:00:17.299 *** ACTION NAME:(ORA$AT_SQ_SQL_SW_6463) 2012-05-04 22:00:17.299 Dump continued FROM file: /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_5730.trc ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], [] ========= Dump FOR incident 231810 (ORA 600 [qkaffsindex5]) ======== *** 2012-05-04 22:00:17.319 dbkedDefDump(): Starting incident DEFAULT dumps (flags=0x2, level=3, mask=0x0) ----- Current SQL Statement for this session (sql_id=c9nhsv0f2b021) ----- /* SQL Analyze(25,1) */ SELECT MENU_ID,MENU_NAME,PROV_CODE FROM VA_MENU WHERE STATUS = :1 AND (PROV_CODE = '098' OR PROV_CODE = :2 ) ORDER BY PROV_CODE DESC , SEQ_NUM ----- PL/SQL Stack ----- ----- PL/SQL Call Stack ----- object line object handle NUMBER name 9e289c2e0 11816 package body SYS.DBMS_SQLTUNE_INTERNAL 9f7693938 7 SYS.WRI$_ADV_SQLTUNE 9e86e5c88 587 package body SYS.PRVT_ADVISOR 9e86e5c88 2655 package body SYS.PRVT_ADVISOR 5a34f0858 241 package body SYS.DBMS_ADVISOR 9e5ef9668 821 package body SYS.DBMS_SQLTUNE 9e8456960 4 anonymous block ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedst1()+96 CALL skdstdst() FFFFFFFF7FFD27F0 ? 100670460 ? 000000000 ? 00000000A ? 000000001 ? 10BD552E0 ? ksedst()+60 CALL ksedst1() 000000000 ? 000000001 ? 00010C1D1 ? 00010C000 ? 10C1CA000 ? 00010C1CA ? dbkedDefDump()+2032 CALL ksedst() 000000000 ? 10B21A000 ? 10B21AA90 ? 10C1D2000 ? 00010B000 ? 00010C1D2 ? dbgexPhaseII()+1800 PTR_CALL dbkedDefDump() 000000003 ? 000000002 ? 10A6ABAA8 ? 0000014B0 ? 10C1C9000 ? 000000003 ? dbgexProcessError() CALL dbgexPhaseII() 10C373D30 ? +1248 FFFFFFFF7A632830 ? FFFFFFFF7FFD7548 ? 0018E0000 ? 10A6A2D98 ? 000001C00 ? dbgePostErrorKGE()+ CALL dbgeExecuteForError 10ADCBBDD ? 1320 () FFFFFFFFFEC0B62D ? 001050000 ? FFFFFFFF7FFD9CF8 ? 001060000 ? 000000028 ? dbkePostKGE_kgsf()+ CALL dbgePostErrorKGE() 10C1CA3E0 ? 000000000 ? 44 FFFFFFFF7A632830 ? 000000000 ? 000000258 ? 00010C000 ? kgerinv_internal()+ CALL kgeadse() 10C1CA3E0 ? 72 FFFFFFFF7A63ADC0 ? 000000258 ? 000002868 ? 10A6A3000 ? 00010A6A3 ? kgerinv()+40 CALL kgerinv_internal() 10C1CA3E0 ? 004EA2360 ? 10B77E7B0 ? 000000258 ? 000000000 ? 000000000 ? kgeasnmierr()+28 CALL kgerinv() 10C1CA3E0 ? FFFFFFFF7A63ADC0 ? 10B77E7B0 ? 000000000 ? FFFFFFFF7FFDB0C0 ? 000001400 ? qkaffsindex()+7648 CALL kgeasnmierr() 10C1CA3E0 ? FFFFFFFF7A63ADC0 ? 10B77E7B0 ? 000000000 ? 10C1CA000 ? 00010C1D1 ? qkatab()+4060 CALL qkaffsindex() FFFFFFFF7A03ACB8 ?
错误发生在SQL_TUNING的过程中,那么多半是Oracle的bug。查询MOS,果然发现文档Bug 12869386 : DBMS_SQLTUNE.EXECUTE_TUNING_TASK REPORTS ORA-600 [QKAFFSINDEX5]记录了这个问题,不过Oracle目前虽然确认了这个bug,但是还没有提供明确的解决这个问题的方案。
好在问题发生在SQLTUNE功能上,即使失败对于数据库的运行也没有影响。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。