ORA-7445(opitca)錯誤

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同樣可以避免這個錯誤的產生。