• 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语句,问题处理反馈开发人员修改代码,减少绑定变量。
  • 相关阅读:
    ExtJs-学习篇(1)
    js中的Ajax经典示例
    软件工程开发流程
    Maven和Ajax
    搭建SSH框架
    拦截器
    OGNL
    Struts 2配置详解
    Struts 2入门
    HQL连接查询和注解
  • 原文地址:https://www.cnblogs.com/lvcha001/p/11452736.html
Copyright © 2020-2023  润新知