1. 首页
  2. IT资讯

索引坏掉导致ORA-07445

客户端报错:ORA-03113: end-of-file on communication channelalert.log报7445的错误:Tue Apr 10 15:01:55 2007Errors in file /data/oracle/admin/imslog/udump/imslog_ora_22550.trc:ORA-07445: exception encountered: core dump [FFFFFFFF7DC4EFBC] [SIGBUS] [Invalid address alignment] [0x408461AF961C76C] [] []ORA-07445: exception encountered: core dump [FFFFFFFF7DC4EFBC] [SIGBUS] [Invalid address alignment] [0x408461AF961C76C] [] []ORA-07445: exception encountered: core dump [FFFFFFFF7DC4EFBC] [SIGBUS] [Invalid address alignment] [0x408461AF961C76C] [] []Tue Apr 10 15:02:02 2007SMON: Parallel transaction recovery triedTue Apr 10 15:16:54 2007Errors 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://www.cxybcw.com/195781.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code