[Problem Record] ORA-00600 [ktspnextl1: 4] _ bug5649098_11.1.0.7 has been fixed

I checked Alert Log and found the following error: View Alert Log:

Fri Aug 2 07:13:33 2013

Errors in file/u01/Oracle/admin/eptdb/bdump/eptdb1_j002_961_4.trc:
ORA-00600: Internal error code, arguments: [ktspnextl1: 4], [], [], [], [], [], [], [], []
Fri Aug 2 07:13:36 2013
Errors in file/u01/Oracle/admin/eptdb/bdump/eptdb1_j002_961_4.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
], [], [], [], [], [], [], []
Fri Aug 2 07:13:36 2013
Trace dumping is refreshing Ming id = [cdmp_20130802071336]

View the trace file:

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_t
Rend (: 1,: 2,: 3,: 4, null, 'false',: 5, 'false '))

----- 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 rj54b728?
Ksfdmp + 0018 BL 03f49cb0
Kgerinv + 00dc BL _ ptrgl
Kgeasnmierr + 004c BL kgerinv 000000000? 000000001?
000000001? 7000002684e40cc?
7000002684e4014?
Ktspgetnextl1forsca BL kgeasnmierr 110173d18? 110400040?
N + 0104 10487 FADC? 000000000?
000000002? 000000000?

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

Mos: Cause

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

-- It is caused by bug 6746222 and bug 5649098.

Solution

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.

Reports of the same problem exist in 10.2 and those have been either susponded (because the problem only happened once) or marked as potential duplicate of unpublished bug 5649098.

-- My database is 10.2, so the error is reported due to bug 5649098.

This error happens when the advisor job runs continuously concurrent with other heavy segment operations. This bug does not cause any data upload uption or instance crash. The workaround is to run the job again.

-- This bug does not cause data corruption or instance crashes, so you don't need to worry about it. You just need to restart the job.