ORA-07445[opiaba()+639]，ORA-00600[17147] oracle宕机

a select sum(bytes)/1024/1024/1024 from dba_segments where owner= '数据用户名'

#alert.log
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x186016B, opiaba()+639] [flags: 0x0, count: 1]
Errors in file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_84692.trc  (incident=2304422):
ORA-07445: 出现异常错误: 核心转储 [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x186016B] [SI_KERNEL(general_protection)] []
Incident details in: /oracle/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_2304422/orcl1_ora_84692_i2304422.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Nov 23 16:25:46 2020
Dumping diagnostic data in directory=[cdmp_20201123162546], requested by (instance=1, osid=84692), summary=[incident=2304422].
Mon Nov 23 16:25:47 2020
Sweep [inc][2304422]: completed
Sweep [inc2][2304422]: completed
Mon Nov 23 16:25:56 2020
Errors in file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pmon_84453.trc  (incident=2304078):
ORA-00600: internal error code, arguments: [17147], [0xAAE36B7A8], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_2304078/orcl1_pmon_84453_i2304078.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Nov 23 16:25:57 2020
Dumping diagnostic data in directory=[cdmp_20201123162557], requested by (instance=1, osid=84453 (PMON)), summary=[incident=2304078].
Errors in file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_pmon_84453.trc:
ORA-00600: internal error code, arguments: [17147], [0xAAE36B7A8], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 84453): terminating the instance due to error 472
System state dump requested by (instance=1, osid=84453 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_diag_84463_20201123162558.trc
Instance terminated by PMON, pid = 84453

查看 orcl1_ora_84692_i2304422.trc

Dump continued from file: /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_84692.trc
ORA-07445: 出现异常错误: 核心转储 [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x186016B] [SI_KERNEL(general_protection)] []

========= Dump for incident 2304422 (ORA 7445 [opiaba()+639]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x186016B, opiaba()+639] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000ac7df8760 %rbx: 0x0000000aaf9b9378 %rcx: 0x0000000000003200
%rdx: 0x0000000000000000 %rdi: 0x0000000000001480 %rsi: 0x0000000000001480
%rsp: 0x00007ffd344dde90 %rbp: 0x00007ffd344ddf00  %r8: 0x0000000aae361508
 %r9: 0x0000000000000071 %r10: 0x0000000000000a84 %r11: 0x0000000ac7df84d0
%r12: 0x0000000ac7dccea8 %r13: 0x0000000000000000 %r14: 0x020000000ac7df87
%r15: 0x0000000000000004 %rip: 0x000000000186016b %efl: 0x0000000000010206
  opiaba()+625 (0x186015d) jmp 0x186019a
  opiaba()+627 (0x186015f) movzbl 0x2c(%rbx),%r15d
  opiaba()+632 (0x1860164) mov %r14,-0x60(%rbp)
  opiaba()+636 (0x1860168) mov %rax,%r14
> opiaba()+639 (0x186016b) movswq 0xa(%r14),%rcx
  opiaba()+644 (0x1860170) cmp %ecx,%r15d
  opiaba()+647 (0x1860173) jne 0x186018e
  opiaba()+649 (0x1860175) mov 0x18(%rbx),%rdi
  opiaba()+653 (0x1860179) lea 0xc(%r14),%rsi

*** 2020-11-23 16:25:42.886
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=5t7462zwvss61) -----
begin  
            update testtable
             SET VERSION = VERSION + 1,
                
                    CODE = :1 ,

MOS：

参考 这个 https://blog.csdn.net/u014237598/article/details/82993168