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

开发反馈应用无法连接数据库，发现数据库实例崩溃，且数据库为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语句，问题处理反馈开发人员修改代码，减少绑定变量。

 

转载于:https://www.cnblogs.com/lvcha001/p/11452736.html