• 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语句,问题处理反馈开发人员修改代码,减少绑定变量。
  • 相关阅读:
    winform音频播放器(有声小说[凡人修仙传])
    c# 小小备忘录
    编程语言 : Java的动态Web解决方案泛谈
    服务器 : Apache Tomcat
    荐书 : 调试九法
    框架应用 : Spring MVC
    框架应用 : Spring
    数据库 : Mysql
    框架应用:Mybatis
    String对象的一些函数用法与心得
  • 原文地址:https://www.cnblogs.com/lvcha001/p/11452736.html
Copyright © 2020-2023  润新知