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进行拆分