告警日志出现ORA-600[ktspNextL1:4]错误。
错误信息如下：
Tue Jan 15 22:00:45 2012 Errors IN file /oracle/admin/orcl/bdump/orcl_j000_13722891.trc: ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], [] Tue Jan 15 22:01:10 2012 Trace dumping IS performing id=[cdmp_20120131220118] Tue Jan 15 22:01:10 2012 Errors IN file /oracle/admin/orcl/bdump/ orcl_j000_13722891.trc: ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], [] ORA-06512: at "SYS.PRVT_ADVISOR", line 1624 ORA-06512: at "SYS.DBMS_ADVISOR", line 186 ORA-06512: at "SYS.DBMS_SPACE", line 1500 ORA-06512: at "SYS.DBMS_SPACE", line 1566 ], [], [], [], [], [], [], [] |
详细TRACE文件如下：
*** 2012-01-15 22:00:45 2012 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], [] CURRENT SQL statement FOR this SESSION: INSERT INTO wri$_adv_objspace_trend_data SELECT timepoint, space_usage, space_alloc, quality FROM TABLE(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE')) ----- PL/SQL Call Stack ----- object line object handle NUMBER name 70000010d9a65e0 1834 package body SYS.DBMS_SPACE 70000010d9a65e0 3922 package body SYS.DBMS_SPACE 70000010d9a65e0 4233 package body SYS.DBMS_SPACE 70000011a7d9c88 1 anonymous block 700000180678048 344 SYS.WRI$_ADV_OBJSPACE_TREND_T 700000180678048 1485 SYS.WRI$_ADV_OBJSPACE_TREND_T 7000001334867d0 1535 package body SYS.PRVT_ADVISOR 7000001334867d0 1618 package body SYS.PRVT_ADVISOR 70000011f9f64a8 186 package body SYS.DBMS_ADVISOR 70000010d9a65e0 1500 package body SYS.DBMS_SPACE 70000010d9a65e0 1566 package body SYS.DBMS_SPACE ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedst+001c bl ksedst1 70000017E9975D0 ? 100000001 ? ksedmp+0290 bl ksedst 104A2CDB0 ? ksfdmp+0018 bl 03F2735C kgerinv+00dc bl _ptrgl kgeasnmierr+004c bl kgerinv 000000000 ? 000000001 ? 000000005 ? 7000000E19760FC ? 7000000E1976014 ? ktspGetNextL1ForSca bl 01F94828 n+0104 |
显然这又是一个ORACLE内部的bug，仍然是定时任务导致的，Oracle在进行空间趋势分析的时候出现了这个错误。
Oracle在文档ORA-600 [ktspNextL1:4] from SYS.DBMS_SPACE / SYS.DBMS_ADVISOR/WRI$_ADV_OBJSPACE_TREND_DATA [ID 841158.1]描述了这个问题，给出的解决方案简单粗暴。方案一、忽略错误；方案二、升级到11.1.0.7；方案三、重新执行JOB。这个问题影响不大，而且并非每次都能重新，因此解决方案还算靠谱。