Oracle 12.2 RAC 报错ora-600 ora-07445

报错如下：
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2017-11-22 13:56:36.095000 +08:00
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F358CE5F7E3] [PC:0xAB3E99F, evaudc()+127] [flags: 0x0, count: 1]
Errors in file /oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_59052.trc  (incident=122179) (PDBNAME=TSSDB):
ORA-07445: exception encountered: core dump [evaudc()+127] [SIGSEGV] [ADDR:0x7F358CE5F7E3] [PC:0xAB3E99F] [Invalid permissions for mapped object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2017-11-22 13:57:34.132000 +08:00
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F7C412B539A] [PC:0xAB3E99F, evaudc()+127] [flags: 0x0, count: 1]
Errors in file /oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_63258.trc  (incident=122617) (PDBNAME=TSSDB):
ORA-07445: exception encountered: core dump [evaudc()+127] [SIGSEGV] [ADDR:0x7F7C412B539A] [PC:0xAB3E99F] [Invalid permissions for mapped object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2017-11-22 13:57:48.377000 +08:00
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F7B710B10E2] [PC:0xAB3E99F, evaudc()+127] [flags: 0x0, count: 1]
DDE: Problem Key 'ORA 7445 [evaudc]' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
2017-11-22 13:58:40.155000 +08:00
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F096426B19D] [PC:0xAB3E99F, evaudc()+127] [flags: 0x0, count: 1]
Errors in file /oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_63564.trc  (incident=121985) (PDBNAME=TSSDB):
ORA-07445: exception encountered: core dump [evaudc()+127] [SIGSEGV] [ADDR:0x7F096426B19D] [PC:0xAB3E99F] [Invalid permissions for mapped object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2017-11-22 13:59:33.141000 +08:00
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7FB8400F327B] [PC:0xAB3E99F, evaudc()+127] [flags: 0x0, count: 1]
Errors in file /oracle/app/db/diag/rdbms/tsscdb/TSSCDB2/trace/TSSCDB2_ora_63999.trc  (incident=121796) (PDBNAME=TSSDB):
ORA-07445: exception encountered: core dump [evaudc()+127] [SIGSEGV] [ADDR:0x7FB8400F327B] [PC:0xAB3E99F] [Invalid permissions for mapped object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

通过对上述trace信息的检查发现除了SQL auto adviser外，还有一条SQL语句出发了该问题，该sql 语句在plsql或者服务器端执行都会出现如下报错：
     ORA-03113: 通信通道的文件结尾
    进程 ID: 5896
    会话 ID: 191 序列号: 1
同时出发ora-07445报错。
通过netalink查看发现应该是12C的一个bug，通过修改如下参数可解决：

ora-07445: exception encountered: core dump [evaudc()+180] Rediscovery Notes When query has all of below:
1) special ordering operator in outer query(example: ORDER BY ...DESC/ASC
NULLS LAST)
2) query having view on which view merge takes place
3) there is FI usage i.e. order by column is fetched from Functional index Workaround alter session set "_replace_virtual_columns"=false;
or
alter session set "_simple_view_merging"=false;
alter session set "complex_view_merging"=false;

具体见：
     Bug 21869685 - ORA-7445: exception encountered: core dump [evaudc()+180] (Doc ID 21869685.8)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28612416/viewspace-2147612/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28612416/viewspace-2147612/