索引壞掉導致ORA-07445

bulletming發表於2019-07-13
索引


客戶端報錯：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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章