Oracle 12.2 RAC报错ora-600 ora-07445怎么办

这篇文章主要介绍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: 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;

以上是“Oracle 12.2 RAC报错ora-600 ora-07445怎么办”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！