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

harald.buesching.hb_at_germany.agfa.com (Harald Buesching) 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.

Unfortunately 00600 internal errors are version and parameter value specific. We encounter the ORA-00600 [kcbget_18] error on version 8.0.5.2.1. The rest of the parameter list varies, but depending on the error/version may or may not indicate we hit the same error. But to continue, we entered a tar with Oracle support and the only information I have recorded is that they said to upgrade and then call back if the error re-occured. We did and it has not reoccurred.

I am pretty sure that in our case we did not have an rbs related problem. Question, is the problem repeatable? If you can duplicate it every time and it generates a trace then support should at least be able to tell you if it matches a known problem, and if there is a patch. They will send patches even on unsupported versions as long as they have them.

Good luck

• Mark D Powell --