ORA-03113: end-of-file on & ORA-07445

--------------ORA-03113: end-of-file on--------------

SQL> show parameter background_dump;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /home/u01/oracle/diag/rdbms/or
cl/orcl/trace

[[email?protected]_179_95_centos trace]$ tail -f alert_orcl.log
Fri Dec 07 09:52:07 2018
Sweep [inc][68390]: completed
Fri Dec 07 09:52:18 2018
Exception [type: SIGSEGV,Address not mapped to object] [ADDR:0x71] [PC:0x1CB9CA9,kkqstcrf()+1355] [flags: 0x0,count: 1]
Errors in file /home/u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_28798.trc (incident=68319):
ORA-07445: exception encountered: core dump [kkqstcrf()+1355] [SIGSEGV] [ADDR:0x71] [PC:0x1CB9CA9] [Address not mapped to object] []
Fri Dec 07 09:53:07 2018
Sweep [inc][68319]: completed

ORA-07445: 出现异常错误: 核心转储 [kkqstcrf()+1355]

解决方案：

trace里当前SQL引用多个left outer join，在11.2.0.1.0版本，外关联存在多个BUG；

查看MOS和BUG 9050716比较匹配，禁用_optimizer_join_elimination_enabled参数问题解决；

SQL> alter system set "_optimizer_join_elimination_enabled"=false scope=both;

SQL> alter system set "_optimizer_join_elimination_enabled"=false scope=both;

---查看_optimizer_join_elimination_enabled参数值

select a.ksppinm name,b.ksppstvl value,a.ksppdesc description

from x$ksppi a,x$ksppcv b

where a.indx = b.indx

and a.ksppinm = ‘_optimizer_join_elimination_enabled‘;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!