ORA-07445 opiaba()+639 ORA-00600 17147数据库宕机

/u01/app/oracle/diag/rdbms/testaa/testaa/trace
Thu Aug 01 12:43:37 2024
Archived Log entry 46044 added for thread 1 sequence 23032 ID 0x860b01b0 dest 1:
Thu Aug 01 12:51:36 2024
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x184CD17, opiaba()+639] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/testaa/testaa/trace/testaa_ora_25992.trc  (incident=321137):
ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x184CD17] [SI_KERNEL(general_protection)] []
Incident details in: /u01/app/oracle/diag/rdbms/testaa/testaa/incident/incdir_321137/testaa_ora_25992_i321137.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Aug 01 12:51:41 2024
Dumping diagnostic data in directory=[cdmp_20240801125141], requested by (instance=1, osid=25992), summary=[incident=321137].
Thu Aug 01 12:51:43 2024
Sweep [inc][321137]: completed
Sweep [inc2][321137]: completed
Thu Aug 01 12:51:52 2024
Errors in file /u01/app/oracle/diag/rdbms/testaa/testaa/trace/testaa_pmon_15250.trc  (incident=320153):
ORA-00600: internal error code, arguments: [17147], [0x0641B8FE0], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/testaa/testaa/incident/incdir_320153/testaa_pmon_15250_i320153.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/app/oracle/diag/rdbms/testaa/testaa/trace/testaa_pmon_15250.trc:
ORA-00600: internal error code, arguments: [17147], [0x0641B8FE0], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 15250): terminating the instance due to error 472
Thu Aug 01 12:51:54 2024
System state dump requested by (instance=1, osid=15250 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/testaa/testaa/trace/testaa_diag_15298_20240801125154.trc
Instance terminated by PMON, pid = 15250

vi /u01/app/oracle/diag/rdbms/testaa/testaa/incident/incdir_321137/testaaa_ora_25992_i321137.trc
查看到日志里面记录了一连串的update语句

Dump continued from file: /u01/app/oracle/diag/rdbms/cdc/cdc/trace/cdc_ora_25992.trc
ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x184CD17] [SI_KERNEL(general_protection)] []

========= Dump for incident 321137 (ORA 7445 [opiaba()+639]) ========
----- Beginning of Customized Incident Dump(s) -----
----- Current SQL Statement for this session (sql_id=51zvt0zmxvba3) -----

根据MOS提示，该错误是一个BUG导致，如下信息。

补丁包可以在个人的资源里面下载。