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 命令动态修改,由于是隐含参数,所以要加引号.
前段时间,用disk clone 方式从生产库clone一个数据库,结果数据库无法启动,遇到 ORA-03113: end-of-file on communication channel错误。
More…
Popularity: 24% [?]
Oracle 10g 的bug 还真不少,这次又遇到了个未公布的bug.
数据库遇到07455,472错误,具体信息如下:
得到ORACLE SR回复如下:
_BLOOM_FILTER_ENABLED 是一个UNDOCUMENT的参数.这个参数自10.2.0引入.
可以使用ALTER SYSTEM 命令动态修改,由于是隐含参数,所以要加引号.
参数具体含义可以参考下面这篇文章
http://www.dbasupport.com/oracle/ora10g/hash.shtml
Popularity: 30% [?]