索引坏掉导致ORA-07445

客户端报错：ORA-03113: end-of-file on communication channel
alert.log报7445的错误：
Tue Apr 10 15:01:55 2007
Errors in file /data/oracle/admin/imslog/udump/imslog_ora_22550.trc:
ORA-07445: exception encountered: core dump [FFFFFFFF7DC4EFBC] [SIGBUS] [Invalid address alignment] [0x40
8461AF961C76C] [] []
ORA-07445: exception encountered: core dump [FFFFFFFF7DC4EFBC] [SIGBUS] [Invalid address alignment] [0x40
8461AF961C76C] [] []
ORA-07445: exception encountered: core dump [FFFFFFFF7DC4EFBC] [SIGBUS] [Invalid address alignment] [0x40
8461AF961C76C] [] []
Tue Apr 10 15:02:02 2007
SMON: Parallel transaction recovery tried
Tue Apr 10 15:16:54 2007
Errors in file /data/oracle/admin/imslog/udump/imslog_ora_22822.trc:
ORA-07445: exception encountered: core dump [00000001005EFA44] [SIGSEGV] [Address not mapped to object] [
0x1652D6179D4] [] []

一个插入语句在一些做了索引的列插入某些值的时候客户端报ORA-03113: end-of-file on communication channel

如果将问题索引drop掉，或者在索引列无值插入或者别的值，也没问题，后来索引drop掉，没问题，重建后，也没有问题，应该是有坏块了，不过没有对索引作一些一致性检查

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/82392/viewspace-144671/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/82392/viewspace-144671/