Re: Has anybody an idea? (ORA-00600)

Rick Wessman <Rick.Wessman_at_oracle.com> wrote in news:socd75ln0sj.fsf_at_rwessman-pc.us.oracle.com:

>> > Audit Commission UK
>> > "Harald Buesching" <harald.buesching.hb_at_germany.agfa.com> wrote in
>> > message news:3bd6f795.0108212257.30d9661b_at_posting.google.com...
>> > > We are running Oracle 8.0.5.0.0 on NT.
>> > > After I fixed a problem on the rollback-segments size, we
>> > > sometimes have problem with truncates.
>> > > Error message:
>> > >
>> > > 21.08.2001 01:10:43 Activity started
>> > > 21.08.2001 01:11:13 Error: ORA-00600: internal error code,
>> > > arguments: [kcbget_18], [2], [8478100], [7], [], [], [], [],
>> > > Connector 'DWHOracle', Method -Action [Truncate]- (600)
>> > > 21.08.2001 01:11:17 Activity Ended With An Error
>> > >
>> > > We using Lotus Notes for transferring data into Oracle, so I can't
>> > > do a 'DELETE'
>> > > Furthermore some truncates may run at the same time. (I never have
>> > > problems with the manual restarts!)
>> > > I read the newsgroup, found a somehow similar problem, and made a
>> > > quick rebuild of the RBS, but no improvemtents.
>> > > It could also be a problem with the RAID-5 system, but I doubt
>> > > this, because the problems appeared after my size changing of the
>> > > RBS.
>> > >
>> > > All suggestions are welcome!
>> > > Harald Buesching.

>

Stolen from Oracle's web site. Upgrade!

TRUNCATE TABLE ORA-600 When I truncate a table, I obtain an ora-600 or database crash. Anybody have an idea?

ORA-00600: internal error code, arguments: [kcbget_18], [2], [8440792], [7], [], [], [], []
or
ora-600 [kcbget_18], [2], [8498752], [7] or
ora-600 [plio.c: non-reus], [1], [], [], [], [], [], [] or
ora-600 [2023] [5] [1]

dlema_at_tilsor.com.uy

From: Oracle, Matthew Arrocha 03-Nov-00 18:37 Subject: Re : TRUNCATE TABLE ORA-600

This is a known bug. please upgrade and apply patch to correct.

VERSIONS The information here relates to version 8.0.X The information has NOT been verified for any other Oracle version.

DESCRIPTION This assertion may be raised if the high watermark of the rollback segment is in an extent map block.

FUNCTIONALITY BUFFER CACHE MANAGEMENT IMPACT PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.

SUGGESTION Known Issues:
Bug 694386 ORA-600 [KCBGET_18] WHEN TRYING TO TRUNCATE TABLE, fixed in 8.0.5.2, 8.0.6.1, 8.1.5.0 releases.

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com