Oracle 12.2 RAC报错ora

68次阅读
没有评论

共计 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 行业资讯频道!

正文完
 
丸趣
版权声明:本站原创文章,由 丸趣 2023-07-19发表,共计3223字。
转载说明:除特殊说明外本站除技术相关以外文章皆由网络搜集发布,转载请注明出处。
评论(没有评论)