ORA-07445: exception encountered: core dump [kkorminl()+317] [SIGSEGV] [ADDR: ] [PC: ] [Address not mapped to object]

Questo è l'errrore ricevuto:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFE12C1FFF8] [PC:0x9540CB7, kkorminl()+317] [flags: 0x0, count: 1]

Errors in file /u01/app/oracle/diag/rdbms/rilp/RILP/trace/RILP_j003_3043.trc  (incident=12361):

ORA-07445: exception encountered: core dump [kkorminl()+317] [SIGSEGV] [ADDR:0x7FFE12C1FFF8] [PC:0x9540CB7] [Address not mapped to object] []

Incident details in: /u01/app/oracle/diag/rdbms/rilp/RILP/incident/incdir_12361/RILP_j003_3043_i12361.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errore (con stack trace identico) riconducibile al Bug 18451758 come da nota ORA-7445 [kkorminl()+348] in 11.2.0.4.0 database (Doc ID 2435261.1)

"This is a known issue documented in:

  - Bug 18451758 - ORA-07445 [kkorminl()+306] soon after job SYS_AUTO_SQL_TUNING_TASK runs which was closed as duplicated of:

  - Bug 17339455 - ORA-600 [qerixAddNotNullStopKeyPredicate:1] with tune sql

Issue/Error has been discussed in both the BUGs.

The issue is resolved in Oracle 12.1.0.2 but there are some versions that already have an interim Patch available.

In the meantime, the workaround to avoid this problem is to disable Automatic Tuning Task as follows:

BEGIN

DBMS_AUTO_TASK_ADMIN.DISABLE(

 client_name => 'sql tuning advisor',

 operation => NULL,

 window_name => NULL );

END;

/

Query di verifica

SQL> SELECT client_name, status FROM dba_autotask_client;

CLIENT_NAME                                                      STATUS

---------------------------------------------------------------- --------

auto optimizer stats collection                                  ENABLED

auto space advisor                                               ENABLED

sql tuning advisor                                               DISABLED

Following jobs is configured default by Oracle:
Automatic Optimizer Statistics Collection- Gathers stale or missing statistics
Automatic Segment Advisor – Identifies segments that reorganized to save space
Automatic SQL Tuning Advisor – Tune high load SQL

All'interno del Bug 18451758 : ORA-07445 [KKORMINL+306] SOON AFTER JOB SYS_AUTO_SQL_TUNING_TASK RUNS

si riscontra lo stesso stack trace che abbiamo nella nostra trace e viene suggerito:

@ So this is pretty much a corrupt in-list chain where q->logorp doesn't exist 

@ and leads to stack overflow (60x recursions in trace).

@ Same was addressed in bug 13809241 but the fix had an issue so you need to 

@ pickup fix from bug 17339455.

La interim patch c'è per diverse versioni della 11.2.0.4 ma non per la nostra che è un po' datata (11.2.0.4.4 di Oct 2014).

Quindi dovremmo installare 

0) Installare anche opatch per psu --->  p6880880_112000_Linux-x86-64

1) l'ultima PSU OCT2020 (11.2.0.4.201020) patch 31537677 --> Opatch_1120341_aprile2023-perdb112000  -->  p31537677_112040_Linux-x86-64

2) e poi la interim patch seguente:

17339455 EBS12.2: ORA-600 [QERIXADDNOTNULLSTOPKEYPREDICATE:1] WITH TUNE SQL (Patch) 11.2.0.4.201020 Linux x86-64 (American English)                                                     -----> p17339455_11204201020_Linux-x86-64