10.2.0.4 RAC环境出现ORA-7445[opitca]错误。
错误信息如下：
Wed Oct 19 17:50:41 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_26638.trc: ORA-07445: exception encountered: core dump [opitca()+4618] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Wed Oct 19 17:50:42 2011 Trace dumping IS performing id=[cdmp_20111019175042] Wed Oct 19 17:53:12 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_12642.trc: ORA-07445: exception encountered: core dump [opitca()+4618] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Wed Oct 19 17:53:13 2011 Trace dumping IS performing id=[cdmp_20111019175313] Wed Oct 19 17:54:13 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_29512.trc: ORA-07445: exception encountered: core dump [opitca()+4618] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Wed Oct 19 17:54:14 2011 Trace dumping IS performing id=[cdmp_20111019175414] Wed Oct 19 18:23:02 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_25383.trc: ORA-07445: exception encountered: core dump [opitca()+4618] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Wed Oct 19 18:23:03 2011 Trace dumping IS performing id=[cdmp_20111019182303] |
根据MOS文档Bug 6316585 – Dump / OERI from complex view merging [ID 6316585.8]，导致该错误的由于复杂视图合并操作时，在外联接查询块中包含了算术或布尔表达式。
这个错误确认影响的版本包括10.2.0.3和10.2.0.4，Oracle在10.2.0.5和11.1.0.7中FIXED了该问题。由于问题和COMPLEX VIEW MERGE有关，因此设置隐患参数”_complex_view_merging”为FALSE同样可以避免这个错误的产生。