客戶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, sid=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功能上，即使失敗對於資料庫的執行也沒有影響。

ORA-600(qkaffsindex5)錯誤

相關文章