ORA-29855 from ORA-01578 (ODCIINDEXCREATE, data block corrupted)

From: S P Arif Sahari Wibowo <arifsaha_at_yahoo.com>
Date: Fri, 31 Jan 2003 12:28:23 -0600
Message-ID: <Pine.LNX.4.42.0301311149260.25306-100000_at_macbeth.tirone.com>



In creating an intermedia text index in Oracle 8.1.6, after the process ran for quite a while, it stop with this error:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
ORA-01578: ORACLE data block corrupted (file # 5, block # 168382)
ORA-01110: data file 5: '/o03/oradata/<dbid>/users01.dbf'
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute)

(I replaced the database name with <dbid>)

It quite large index, at the time of stopping, the DR$...$I table created for the intermedia text has size of 473.75 MB. The index are created from a LOB field, I think the LOB segment of it has the size of 661.375 MB.

I checked already that the corrupt block is indeed part of the DR$...$I table.

Somewhere in this newsgroup I read that sometime ORA-01578 can be caused by insufficient SGA. Is that true? Is that seems to be the case here? If it is, which part of SGA I should increase? At the moment of crash, the initial db_block_buffers is 2048 (x 8192) and initial shared_pool_size is 15728640. Total SGA is 56008688 bytes.

Should I really worried about the disks? There is no SCSI error logged (the system log is on separate disk and controller).

I am using Oracle 8.1.6 standard in RH Linux 7.3. The drive where the table space located is Fujitsu MAG3182MP 18.2 GB formatted with ext2, on controller Tekram DC-390U3W, driver sym53c8xx

Thanks!

-- 
                                   S P Arif Sahari Wibowo
  _____  _____  _____  _____ 
 /____  /____/ /____/ /____          arifsaha_at_yahoo.com
_____/ /      /    / _____/       http://www.arifsaha.com/
Received on Fri Jan 31 2003 - 19:28:23 CET

Original text of this message