[案例ORA-07445]ORA-07445 oracle11.2.0.4

 

Tue Apr 27 22:00:13 2021
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFEC1D45FF8] [PC:0x9541C52, kkorminl()+348] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_12272.trc (incident=305225):
ORA-07445: exception encountered: core dump [kkorminl()+348] [SIGSEGV] [ADDR:0x7FFEC1D45FF8] [PC:0x9541C52] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_305225/orcl1_j002_12272_i305225.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Apr 27 22:00:18 2021
Dumping diagnostic data in directory=[cdmp_20210427220018], requested by (instance=1, osid=12272 (J002)), summary=[incident=305225].
Tue Apr 27 22:00:18 2021
Sweep [inc][305225]: completed
Sweep [inc2][305225]: completed
Tue Apr 27 22:01:16 2021

在mos 文档17339455.8：

ORA-7445 [kkorminl] or similar can occur when running DBMS_SQLTUNE
Index Advisor on queries with inlists. This is most likely to occur when running
an automatic tuning task that runs Index Advisor.

Workaround
If the issue occurs during automatic tuning then an option to avoid the dumps is to
disable the automatic tuning job.
eg:
BEGIN
dbms_auto_task_admin.disable(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/

收集trace信息

$ adrci

ADRCI: Release 11.2.0.4.0 - Production on Wed Apr 28 13:21:33 2021

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

ADR base = "/u01/app/oracle"
adrci> show base
ADR base is "/u01/app/oracle"
adrci> show home
ADR Homes:
diag/rdbms/orcl/orcl1
adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
305225 ORA 7445 [kkorminl()+348] 2021-04-27 22:00:13.628000 +08:00
1 rows fetched

adrci>