Linux redhat 5 (x86-64) 最近遇到ORA-07445的错误,日志不停的报错误信息,db version 11.1.0.6
有遇到过这样的错误吗?metalink上说是bug,和硬件有关,就没有一个解决方法呢?
告警日志:
adrci> show alert -ti
DIA-48415: Syntax error found in string [show alert -ti] at column [14]
adrci> show alert -tail 10
2010-08-06 09:41:23.675000 +08:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x73AC832, nttaddr2bnd()+1152]
Errors in file /u01/app/diag/rdbms/testora/testora/trace/testora_d000_5913.trc (incident=6414):
ORA-07445: exception encountered: core dump [nttaddr2bnd()+1152] [SIGSEGV] [ADDR:0x0] [PC:0x73AC832] [Address not mapped to object] []
Sweep Incident[6414]: completed
2010-08-06 09:42:26.656000 +08:00
found dead dispatcher 'D000', pid = (19, 6)
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x73AC832, nttaddr2bnd()+1152]
Errors in file /u01/app/diag/rdbms/testora/testora/trace/testora_d000_5927.trc (incident=6415):
ORA-07445: exception encountered: core dump [nttaddr2bnd()+1152] [SIGSEGV] [ADDR:0x0] [PC:0x73AC832] [Address not mapped to object] []
Sweep Incident[6415]: completed
2010-08-06 09:43:29.699000 +08:00
found dead dispatcher 'D000', pid = (19, 7)
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x73AC832, nttaddr2bnd()+1152]
Errors in file /u01/app/diag/rdbms/testora/testora/trace/testora_d000_5939.trc (incident=6416):
ORA-07445: exception encountered: core dump [nttaddr2bnd()+1152] [SIGSEGV] [ADDR:0x0] [PC:0x73AC832] [Address not mapped to object] []
Sweep Incident[6416]: completed
trace 文件:
*** 2010-08-06 09:43:29.753
*** CLIENT ID:() 2010-08-06 09:43:29.753
*** SERVICE NAME:() 2010-08-06 09:43:29.753
*** MODULE NAME:() 2010-08-06 09:43:29.753
*** ACTION NAME:() 2010-08-06 09:43:29.753
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x73AC832, Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x73AC832, nttaddr2bnd()+1152]
DDE: Problem Key 'ORA 7445 [nttaddr2bnd()+1152]' was flood controlled (0x2) (incident: 6416)
ORA-07445: exception encountered: core dump [nttaddr2bnd()+1152] [SIGSEGV] [ADDR:0x0] [PC:0x73AC832] [Address not mapped to object] []
*** 2010-08-06 09:43:30.097
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
解决方法:
注释 dispatcher 参数(spfile)
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
问题:一时找不到更好的办法,暂时注释掉了dispatchers,不知道是否有其它好的办法(Help)?
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24247514/viewspace-670418/ ,如需转载,请注明出处,否则将追究法律责任。