【案例】ORA-00600 ORA-07445 数据库异常宕机

数据库版本：

Oracle11.2.0.1

数据库异常宕机

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x17E8693, opiaba()+639] [flags: 0x0, count: 1]
Fri Jun 26 00:13:48 2020
Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27711.trc (incident=10089):
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x25F14A4B8], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/incident/incdir_10089/zetian_ora_27711_i10089.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27566.trc (incident=9993):
ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x17E8693] [SI_KERNEL(general_protection)] []
Incident details in: /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/incident/incdir_9993/zetian_ora_27566_i9993.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27711.trc (incident=10090):
ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x2BD6749F8], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x25F14A4B8], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/incident/incdir_10090/zetian_ora_27711_i10090.trc
Fri Jun 26 00:14:00 2020
Dumping diagnostic data in directory=[cdmp_20200626001400], requested by (instance=1, osid=27711), summary=[incident=10090].
Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27711.trc (incident=10091):

处理方案：SQL使用了较多绑定变量出发bug

1. Apply the one-off patch for Bug:12578873 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=12578873] - ORA-7445 [opiaba] when using more than 65535 bind variables

OR

2. Use the workaround: Reduce the number of bind variables

OR

3.Migrate to 12.1.0.2 or higher.

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x17E8693, opiaba()+639] [flags: 0x0, count: 1]Fri Jun 26 00:13:48 2020Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27711.trc (incident=10089):ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x25F14A4B8], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/incident/incdir_10089/zetian_ora_27711_i10089.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27566.trc (incident=9993):ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x17E8693] [SI_KERNEL(general_protection)] []Incident details in: /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/incident/incdir_9993/zetian_ora_27566_i9993.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27711.trc (incident=10090):ORA-00600: internal error code, arguments: [kghGetHpSz1], [0x2BD6749F8], [], [], [], [], [], [], [], [], [], []ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x25F14A4B8], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/incident/incdir_10090/zetian_ora_27711_i10090.trcFri Jun 26 00:14:00 2020Dumping diagnostic data in directory=[cdmp_20200626001400], requested by (instance=1, osid=27711), summary=[incident=10090].Errors in file /u01/oracle/oracle11g/diag/rdbms/zetian/zetian/trace/zetian_ora_27711.trc (incident=10091):