\u5ba2\u623711.2.0.2 RAC for Solaris10\u4e0a\u7684\u9519\u8bef\u3002
\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n
2012-05-04 22:00:04.768000 +08:00\r\nBegin automatic SQL Tuning Advisor run for special tuning task \"SYS_AUTO_SQL_TUNING_TASK\"\r\n2012-05-04 22:00:17.279000 +08:00\r\nErrors in file \/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_j002_5730.trc (incident=231810):\r\nORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_231810\/orcl1_j002_5730_i231810.trc\r\n2012-05-04 22:01:38.428000 +08:00\r\nDumping diagnostic data in directory=[cdmp_20120504220138], requested by (instance=1, osid=5730 (J002)), summary=[incident=231810].\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nSweep [inc][231810]: completed\r\nSweep [inc2][231810]: completed<\/pre>\n\u67e5\u8be2\u8be6\u7ec6\u4fe1\u606f\uff1a<\/p>\n
$ more \/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_231810\/orcl1_j002_5730_i231810.trc\r\nDump file \/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_231810\/orcl1_j002_5730_i231810.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/oracle\/product\/11.2.0\/dbhome_1\r\nSystem name: SunOS\r\nNode name: racdb1\r\nRelease: 5.10\r\nVersion: Generic_142900-14\r\nMachine: sun4u\r\nInstance name: orcl1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 129\r\nUnix process pid: 5730, image: oracle@racdb1 (J002)\r\n\r\n\r\n*** 2012-05-04 22:00:17.299\r\n*** SESSION ID:(25.62649) 2012-05-04 22:00:17.299\r\n*** CLIENT ID:() 2012-05-04 22:00:17.299\r\n*** SERVICE NAME:(SYS$USERS) 2012-05-04 22:00:17.299\r\n*** MODULE NAME:(DBMS_SCHEDULER) 2012-05-04 22:00:17.299\r\n*** ACTION NAME:(ORA$AT_SQ_SQL_SW_6463) 2012-05-04 22:00:17.299\r\n \r\nDump continued from file: \/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_j002_5730.trc\r\nORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], []\r\n\r\n========= Dump for incident 231810 (ORA 600 [qkaffsindex5]) ========\r\n\r\n*** 2012-05-04 22:00:17.319\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- Current SQL Statement for this session (sql_id=c9nhsv0f2b021) -----\r\n\/* 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\r\n, SEQ_NUM\r\n----- PL\/SQL Stack -----\r\n----- PL\/SQL Call Stack -----\r\n object line object\r\n handle number name\r\n9e289c2e0 11816 package body SYS.DBMS_SQLTUNE_INTERNAL\r\n9f7693938 7 SYS.WRI$_ADV_SQLTUNE\r\n9e86e5c88 587 package body SYS.PRVT_ADVISOR\r\n9e86e5c88 2655 package body SYS.PRVT_ADVISOR\r\n5a34f0858 241 package body SYS.DBMS_ADVISOR\r\n9e5ef9668 821 package body SYS.DBMS_SQLTUNE\r\n9e8456960 4 anonymous block\r\n\r\n----- Call Stack Trace -----\r\ncalling call entry argument values in hex \r\nlocation type point (? means dubious value) \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst1()+96 CALL skdstdst() FFFFFFFF7FFD27F0 ?\r\n 100670460 ? 000000000 ?\r\n 00000000A ? 000000001 ?\r\n 10BD552E0 ?\r\nksedst()+60 CALL ksedst1() 000000000 ? 000000001 ?\r\n 00010C1D1 ? 00010C000 ?\r\n 10C1CA000 ? 00010C1CA ?\r\ndbkedDefDump()+2032 CALL ksedst() 000000000 ? 10B21A000 ?\r\n 10B21AA90 ? 10C1D2000 ?\r\n 00010B000 ? 00010C1D2 ?\r\ndbgexPhaseII()+1800 PTR_CALL dbkedDefDump() 000000003 ? 000000002 ?\r\n 10A6ABAA8 ? 0000014B0 ?\r\n 10C1C9000 ? 000000003 ?\r\ndbgexProcessError() CALL dbgexPhaseII() 10C373D30 ?\r\n+1248 FFFFFFFF7A632830 ?\r\n FFFFFFFF7FFD7548 ?\r\n 0018E0000 ? 10A6A2D98 ?\r\n 000001C00 ?\r\ndbgePostErrorKGE()+ CALL dbgeExecuteForError 10ADCBBDD ?\r\n1320 () FFFFFFFFFEC0B62D ?\r\n 001050000 ?\r\n FFFFFFFF7FFD9CF8 ?\r\n 001060000 ? 000000028 ?\r\ndbkePostKGE_kgsf()+ CALL dbgePostErrorKGE() 10C1CA3E0 ? 000000000 ?\r\n44 FFFFFFFF7A632830 ?\r\n 000000000 ? 000000258 ?\r\n 00010C000 ?\r\nkgerinv_internal()+ CALL kgeadse() 10C1CA3E0 ?\r\n72 FFFFFFFF7A63ADC0 ?\r\n 000000258 ? 000002868 ?\r\n 10A6A3000 ? 00010A6A3 ?\r\nkgerinv()+40 CALL kgerinv_internal() 10C1CA3E0 ? 004EA2360 ?\r\n 10B77E7B0 ? 000000258 ?\r\n 000000000 ? 000000000 ?\r\nkgeasnmierr()+28 CALL kgerinv() 10C1CA3E0 ?\r\n FFFFFFFF7A63ADC0 ?\r\n 10B77E7B0 ? 000000000 ?\r\n FFFFFFFF7FFDB0C0 ?\r\n 000001400 ?\r\nqkaffsindex()+7648 CALL kgeasnmierr() 10C1CA3E0 ?\r\n FFFFFFFF7A63ADC0 ?\r\n 10B77E7B0 ? 000000000 ?\r\n 10C1CA000 ? 00010C1D1 ?\r\nqkatab()+4060 CALL qkaffsindex() FFFFFFFF7A03ACB8 ?<\/pre>\n\u9519\u8bef\u53d1\u751f\u5728SQL_TUNING\u7684\u8fc7\u7a0b\u4e2d\uff0c\u90a3\u4e48\u591a\u534a\u662fOracle\u7684bug\u3002\u67e5\u8be2MOS\uff0c\u679c\u7136\u53d1\u73b0\u6587\u6863Bug 12869386 : DBMS_SQLTUNE.EXECUTE_TUNING_TASK REPORTS ORA-600 [QKAFFSINDEX5]\u8bb0\u5f55\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0c\u4e0d\u8fc7Oracle\u76ee\u524d\u867d\u7136\u786e\u8ba4\u4e86\u8fd9\u4e2abug\uff0c\u4f46\u662f\u8fd8\u6ca1\u6709\u63d0\u4f9b\u660e\u786e\u7684\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u7684\u65b9\u6848\u3002
\n\u597d\u5728\u95ee\u9898\u53d1\u751f\u5728SQLTUNE\u529f\u80fd\u4e0a\uff0c\u5373\u4f7f\u5931\u8d25\u5bf9\u4e8e\u6570\u636e\u5e93\u7684\u8fd0\u884c\u4e5f\u6ca1\u6709\u5f71\u54cd\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u623711.2.0.2 RAC for Solaris10\u4e0a\u7684\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a 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], [], [], [], [], [], [], [], … Continue reading