菜单 学习猿地 - LMONKEY

VIP

开通学习猿地VIP

尊享10项VIP特权 持续新增

知识通关挑战

打卡带练!告别无效练习

接私单赚外块

VIP优先接,累计金额超百万

学习猿地私房课免费学

大厂实战课仅对VIP开放

你的一对一导师

每月可免费咨询大牛30次

领取更多软件工程师实用特权

入驻
137
0

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

原创
05/13 14:22
阅读数 12934

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

 

发表评论

0/200
137 点赞
0 评论
收藏
为你推荐 换一批