共計 3223 個字符，預計需要花費 9 分鐘才能閱讀完成。
這篇文章主要介紹 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;
alter session set _simple_view_merging =false;
alter session set complex_view_merging =false;以上是“Oracle 12.2 RAC 報錯 ora-600 ora-07445 怎么辦”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注丸趣 TV 行業資訊頻道！
