记忆在这里化作永恒

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

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.

ALTER SYSTEM SET "_BLOOM_FILTER_ENABLED"= false;