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 viewmerge takes place 3) there is FI usage i.e. order by column is fetched fromFunctionalindex 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怎么办”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注行业资讯频道！