Re: Help: Oracle error ORA-00600 !!

Antero Elovaara wrote:
> > ERROR:
> > ORA-00600: internal error code, arguments: [12700], [134231271], [0], [], [],
> > [], [], []
> >
> > 00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
>
> It seems that we had it in Ultrix Oracle 7.0.16.
> Customer support was able to tell us that it was
> Bug number 200344, fixed in version 7.1.3.
> Patch status was 28. September 1994 :
>
> os rdbms bug status
> -----------------------------------------------------------------------------SCO 7.0.16 228592 patch available
> HPUX 7.0.15 205209 patch available
> HPUX 7.0.16 238393 patch requested but not approved (yet)
> ULTRIX 7.0.16 239580 patch requested and approved, but not yet available

ORA-600 internal error is raised from many different of causes, most from bugs in Oracle system.
In your case, it may be index structure is inconsistent with its table. You can use 'ANALYZE TABLE XXX VALIDATE STRUCTURE CASCADE' to validate all USER defined tables to
see which index has problems. After finding, drop the index and recreate it.

If it is the case, the error can be much reduced from V7.1 above.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049