ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x1858C3F] [SI_KERNEL(general_protection)] []

开发反馈应用无法连接数据库,发现数据库实例崩溃,且数据库为11.2.0.4 单实例。

数据库告警日志发现,数据库崩溃之前出现ORA-07445
ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x1858C3F] [SI_KERNEL(general_protection)] []


匹配MOS
Bug 12578873 - ORA-7445 [opiaba] when using more than 65535 bind variables (文档 ID 12578873.8)    


APPLIES TO:
PL/SQL - Version 1.0.0 to 12.1.0.1
Information in this document applies to any platform.
DETAILS
Note to support: do not edit this note - it is auto generated
  For corrections please add a Comment

Bug 12578873  ORA-7445 [opiaba] when using more than 65535 bind variables
 This note gives a brief overview of bug 12578873. 
 The content was last updated on: 17-DEC-2015
 Click here for details of each of the sections below.

Description

This bug is only relevant when using PL/SQL
When using more than 65535 bind variables from PL/SQL we could
get a crash under opiaba(). This issue can also cause a memory corruption
and a subsequent ORA-600 and/or instance failure.
 
Workaround
Reduce the number of bind variables


报错后续附加Trace日志,可以发现大量的SQL语句,问题处理反馈开发人员修改代码,减少绑定变量。

 

posted @ 2019-09-03 14:19  绿茶有点甜  阅读(1479)  评论(0编辑  收藏  举报