项目上有个功能报ORA-03113:通信道的文件结尾的错误,获取oracle日志,查看对应时间段的日志记录,步骤如下
1.命令窗口执行:show parameter dump_dest
2.获取oracle警告文件,文件名规则:alert_+Oracle服务名+.log
3.查看对应时间段的日志记录
发现错误信息如下:
Mon Oct 08 15:38:51 2018
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x45] [PC:0x35797B4, _kkqstcrf()+1342]
Errors in file e:\app\***\diag\rdbms\orcl\orcl\trace\orcl_ora_19488.trc (incident=5153):
ORA-07445: 出现异常错误: 核心转储 [kkqstcrf()+1342] [ACCESS_VIOLATION] [ADDR:0x45] [PC:0x35797B4] [UNABLE_TO_READ] []
Incident details in: e:\app\****\diag\rdbms\orcl\orcl\incident\incdir_5153\orcl_ora_19488_i5153.trc
查询资料发现,这是oracle的bug,通过关闭参数问题解决:
SQL> alter system set "_optimizer_join_elimination_enabled" = false;