ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(ktspNextL1:4)错误

ORA-600(ktspNextL1:4)错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-02-05 23:56:59 0 删除 编辑

错误信息如下:

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。这个问题影响不大,而且并非每次都能重新,因此解决方案还算靠谱。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-715664/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORA-600(1158)错误
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10367075