Oracle 10g 的bug 还真不少,这次又遇到了个未公布的bug.
数据库遇到07455,472错误,具体信息如下:
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_j010_5066.trc: ORA-07445: exception encountered: core dump [kghadjust()+152] [SIGSEGV] [Address not mapped to object] [0x000000018] [] [] Mon Jul 28 14:30:37 2008 Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_pmon_25485.trc: ORA-07445: exception encountered: core dump [kghadjust()+152] [SIGSEGV] [Address not mapped to object] [0x000000018] [] [] Mon Jul 28 14:30:59 2008 CKPT: terminating instance due to error 472 Mon Jul 28 14:30:59 2008 Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_lgwr_25503.trc: ORA-00472: PMON process terminated with error Mon Jul 28 14:30:59 2008 Errors in file /data/oracle/sprrprd1/admin/bdump/instanace_name_rvwr_25672.trc: ORA-00472: PMON process terminated with error Mon Jul 28 14:31:00 2008 Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_psp0_25487.trc: ORA-00472: PMON process terminated with error Termination issued to instance processes. Waiting for the processes to exit Instance terminated by CKPT, pid = 25505 |
得到ORACLE SR回复如下:
It seems that you has got the problem described in Bug4927533, which is unfortunately not public and therefore not available on Metalink. For more information please read Note:421947.1, Ora-7445 [KGHADJUST] Pmon Process Terminated And Instance Crashed. Fixed in version: - Oracle 11.1 Workaround: - Set "_BLOOM_FILTER_ENABLED" to FALSE. No fix exist for Oracle 10.2.0.3.0. I recommend that you use the workaround, this will solve your problem. |
_BLOOM_FILTER_ENABLED 是一个UNDOCUMENT的参数.这个参数自10.2.0引入.
可以使用ALTER SYSTEM 命令动态修改,由于是隐含参数,所以要加引号.
ALTER SYSTEM SET "_BLOOM_FILTER_ENABLED"= false; |
参数具体含义可以参考下面这篇文章
http://www.dbasupport.com/oracle/ora10g/hash.shtml
最新评论