Oracle ORA-00600 [KCBRLS_1], ORA-01578

ORA-00600 [KCBRLS_1], ORA-01578

SYMPTOMS

There are two errors being reported. One in the database's Alert log and the other by the application.

The first Manageability issue is the ORA-00600 [kcbrls_1] doing an Insert on a Windows Server 2003 x32 and 9.2.0.8.0.

ORA-00600: internal error code, arguments: [kcbrls_1], [], [], [], [], [], [], []

Current SQL statement for this session:

insert into mgmt_db_file_gtt select f.tablespace_name, (f.bytes)/1048576 meg,

(f.maxbytes)/1048576 maxmeg, f.file_name, f.file_id, ts.ts#, ts.blocksize, 0 from

sys.ts$ ts, sys.dba_data_files f where ts.contents$ = 0 and f.tablespace_name = ts.name

The second is the ORA-1578 data corruption issue.

ORA-01578: ORACLE data block corrupted (file # 11, block # 316275)

ORA-01110: data file 11: 'E:\ORACLE\ORADATA\COBRADVL\OPP_DATA1.DBF'

This ORA-1578 error was not written in the Alert log and was generated on the application screen by the INSERT statement shown in the preceding ORA-00600

[kcbrls_1] error.

CHANGES

The fact that the Windows Server 2003 x32 and 9.2.0.8 is not a certifiable combination may or may not have a bearing on this issue. However, the corruption was

resolved using a Oracle PLSQL package.

CAUSE

The issue seems to be related to SMON not being able to clean up a few temporary segments in the OPP_DATA tablespace. Now, this tablespace

contains corrupt Table and Bitmap Index segments.

SOLUTION

The corruption in OPP_DATA tablespace was resolved by using the DBMS_SPACE_ADMIN package. With this package, the blocks were marked corrupt and, then,

they were dropped.

In addition, this tablespace has bitmap indexes and the DBMS_SPACE_ADMIN.TABLESPACE_REBUILD_BITMAPS procedure was used to Rebuild them.

After the segments were Dropped, new segments were re-imported from a previous export and the bitmap indexes were Rebuilt.

The following are the procedures used to perform these tasks. By following Note <<28814.1>>, the tablespace name can be obtained by using file # 11, block #

316275 identified by the ORA-1578 error. This information is needed to perform the following procedures.