• Instance crashed after ORA-7445 [opiaba] and ORA-600 [17147]


    操纵系统:Centos6.5  

    数据库版本:11.2.0.4 rac

    补丁情况:未更新任何补丁

    现象数据库突然宕机,启动之后过一段时间还是会出现一下情况

    Wed Apr 18 11:41:44 2012
    Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x1495A37, opiaba()+639] [flags: 0x0, count: 1]
    Errors in file /u01/.../SID_ora_26561.trc (incident=272318): ORA-7445: exception encountered: core dump [opiaba()+639] [SIGSEGV][ADDR:0x0] [PC:0x1495A37] [SI_KERNEL(general_protection)] []
    Incident details in: /u01/.../incdir_272318/SID_ora_26561_i272318.trc
    Errors in file /u01/.../SID_ora_26561.trc (incident=272319):
    ORA-600: internal error code, arguments: [kgh_heap_sizes:ds],[0x81BF26440], [], [], [], [], [], [], [], [], [], []
    ORA-7445: exception encountered: core dump [opiaba()+639] [SIGSEGV][ADDR:0x0] [PC:0x1495A37] [SI_KERNEL(general_protection)] []
    Incident details in: /u01/...t/incdir_272319/SID_ora_26561_i272319.trc
    Wed Apr 18 11:41:49 2012
    Trace dumping is performing id=[cdmp_20120418114149]
    ...
    Wed Apr 18 11:51:51 2012
    Process 0x0x9e0c8d0d0 appears to be hung while dumping <-----
    Current time = 746796356, process death time = 746736136 interval = 60000
    Attempting to kill process 0x0x9e0c8d0d0 with OS pid = 26561
    OSD kill succeeded for process 0x9e0c8d0d0
    Errors in file /u01/.../SID_pmon_6020.trc (incident=265950):
    ORA-600: internal error code, arguments: [17147], [0x81BF26428], [], [],[], [], [], [], [], [], [], []
    Incident details in: /u01/.../incdir_265950/SID_pmon_6020_i265950.trc
    Wed Apr 18 11:51:55 2012
    Trace dumping is performing id=[cdmp_20120418115155]
    Errors in file /u01/.../SID_pmon_6020.trc:
    ORA-600: internal error code, arguments: [17147], [0x81BF26428], [], [],[], [], [], [], [], [], [], []
    PMON (ospid: 6020): terminating the instance due to error 472

    结合报错信息,查看mos,发现1466343.1情况符合,根据提示单个SQL的绑定变量超过65535就会触发这个bug,版本10.2.0.5 to 12.1.0.1在这个之内都会有这个问题。

    联系应用,确定是否存在此类情况,应用在昨晚进行升级之后,今天执行的plsql中指定多条update语句,绑定变量总和7w多,超过阀值65535触发bug。

    补丁地址

    https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=oj76x1cv0_148&_afrLoop=17411389381759

    bug id:12578873

    解决:

    1.打补丁

    打完补丁之后,修复了实例被终止的问题,绑定变量仍然不能超过65535

    2.通知应用对问题plsql进行拆分

  • 相关阅读:
    关于Jupyter Notebook默认起始目录设置无效的解决方法
    关于二叉树中度为0与度为2节点数关系证明
    LeetCode第[3]题(Java):Longest Substring Without Repeating Characters 标签:Linked List
    数据结构,物理结构,存储结构,逻辑结构的区分
    条件变量 sync.Cond
    defer 的常用场景
    switch...case... 语句中的类型转换
    golang 切片和数组在for...range中的区别
    golang 并发顺序输出数字
    Golang 中哪些值是不可以寻址的
  • 原文地址:https://www.cnblogs.com/hanglinux/p/15181139.html
Copyright © 2020-2023  润新知