ORA-00600[ktspNextL1:4]_bug5649098_11.1.0.7之后已修复__package_5649098_DBMS_SPACE_body_SYS_

当前位置: 数据库>oracle

ORA-00600[ktspNextL1:4]_bug5649098_11.1.0.7之后已修复

来源: 互联网发布时间：2017-05-25

本文导语: 今天看了一下alert log发现如下报错：查看alert log： Fri Aug 2 07:13:33 2013 Errors in file /u01/Oracle/admin/eptdb/bdump/eptdb1_j002_962644.trc:Fri Aug 2 07:13:36 2013Fri Aug 2 07:13:36 2013Trace dumping is performing id=[cdmp_20130802071336] 查看trace文件： ----- PL/SQL Cal...

今天看了一下alert log发现如下报错：查看alert log：

Fri Aug 2 07:13:33 2013

Errors in file /u01/Oracle/admin/eptdb/bdump/eptdb1_j002_962644.trc:

Fri Aug 2 07:13:36 2013

Fri Aug 2 07:13:36 2013
Trace dumping is performing id=[cdmp_20130802071336]

查看trace文件：

----- PL/SQL Call Stack -----
object line object
handle number name
7000002e5a5d398 1834 package body SYS.DBMS_SPACE
7000002e5a5d398 3922 package body SYS.DBMS_SPACE
7000002e5a5d398 4233 package body SYS.DBMS_SPACE
70000030cded6d0 1 anonymous block
700000320ec2178 344 SYS.WRI$_ADV_OBJSPACE_TREND_T
700000320ec2178 1485 SYS.WRI$_ADV_OBJSPACE_TREND_T
70000031d9e48a8 1535 package body SYS.PRVT_ADVISOR
70000031d9e48a8 1618 package body SYS.PRVT_ADVISOR
70000031bb80860 186 package body SYS.DBMS_ADVISOR
7000002e5a5d398 1500 package body SYS.DBMS_SPACE
7000002e5a5d398 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 700000344A7DF80 ? 100000001 ?
ksedmp+0290 bl ksedst 10454B728 ?
ksfdmp+0018 bl 03F49CB0
kgerinv+00dc bl _ptrgl
kgeasnmierr+004c bl kgerinv 000000000 ? 000000001 ?
000000001 ? 7000002684E40CC ?
7000002684E4014 ?
ktspGetNextL1ForSca bl kgeasnmierr 110173D18 ? 110400040 ?
n+0104 10487FADC ? 000000000 ?
000000002 ? 000000000 ?

...............

MOS中解释：

Unpublished bug 6746222 ORA-00600 [KTSPNEXTL1:4] DURING WORKLOAD
Closed as a potential duplicate of unpublished Bug 5649098

Unpublished bug 5649098 ORA 600 [KTSPNEXTL1:4] WHILE SEGMENT SHRINK
Closed as not reproducible in 11.1.0.7, but a fix was never identified

--是由于bug 6746222、bug 5649098 导致的。

To implement the solution, please execute one of the following steps:

1. Ignore the error.

2. Upgrade to 11.1.0.7.

3. Rerun the job.

Unpublished bug 5649098 was found during the 11g beta testing and was determined as being fixed in the 11.1.0.7 version. The bug was closed as not reproducible.

--我的数据库是10.2的，所以因为bug 5649098而该报错。

--这个bug不会导致数据损坏或者实例崩溃，因此不用管它，只要重新启动job即可。

您可能感兴趣的文章:

本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。