使用tts(传输表空间) 跨版本升级数据库并且使用bitmap索引时遇到的一个bug

第一。bug的现象:

ORA-07445: exception encountered: core dump [$cold_kggbt()+304] [SIGSEGV] [Address not mapped to object] [0x63646567B4B9BEBE] [] []
ORA-00600: internal error code, arguments: [25027], [9], [2399694318], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x9FFFFFFFFC60BB60], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kdiblLockRange:maxRetryCountExce], [], [], [], [], [], [], []

trc文件中有bitmap的很多提示。


第二,解决方法:

Oracle 技术支持 - 2011年10月31日 下午05时21分16秒 [ODM Solution/Action Plan]

drop and recreate the corrupted indexes now.

To prevent the issue from happening again, upgrade to 11.2.0.2 or apply patch 7251049.

More information please see note 7251049.8
[@more@]
请使用浏览器的分享功能分享到微信等