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

原文地址:https://www.cnblogs.com/hanglinux/p/15181139.html