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同样可以避免这个错误的产生。