Re: Bad Block ORA-00600

Oracle's advice with ORA-00600 is ... call Oracle. Unless this is an unimportant database ... which perhaps it is as you have let this go on now for three months, I would go to Oracle before attempting anything.

Daniel Morgan

Brian Rankin wrote:

> Hello,
>
> I'm running Oracle 8.1.7 with Oracle Portal; there's a bad block in
> the TAB$ table. Background:
>
> a) The following error is being listed every few minutes in the alert
> log:
> ORA-00600: internal error code, arguments: [4142], [20992194], [], [],
> [], [],
> [], [].
> b) This means that transaction USN 7 slot# 84 on database object ID 4
> is bad;
> c) The object for ID 4:
>
> select owner,object_id, object_name, object_type from
> dba_objects where object_id = 4;
>
> OWNER OBJECT_ID
> ------------------------------ ----------
> OBJECT_NAME
> --------------------------------------------------------------------------------
> OBJECT_TYPE
> ------------------
> SYS 4
> TAB$
> TABLE
>
> d) This error has been occuring since January; backups aren't
> available for this database that far back. I've tried to drop the
> TAB$ table on a mirror server, but can't. Portal operations hasn't
> been affected thus far...Help!
Received on Thu Apr 18 2002 - 14:09:40 CDT