ORA-07445: exception encountered: core dump [kglIsOwnerVersionable()]

Hi all,

We have received a mail from customer to investigate above error reported in the database's alert log.
Please find the details below.

Can you please investigate below error against EBSPRD and let me know the next course of action?

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x24] [PC:0x2587EB9, kglIsOwnerVersionable()+123] [flags: 0x0, count: 1]

Errors in file /sw/oraebs/EBSPRD/db/tech_st/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/trace/EBSPRD_ora_17713.trc  (incident=624688):

ORA-07445: exception encountered: core dump [kglIsOwnerVersionable()+123] [SIGSEGV] [ADDR:0x24] [PC:0x2587EB9] [Address not mapped to object] []

Incident details in: /sw/oraebs/EBSPRD/db/tech_st/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/incident/incdir_624688/EBSPRD_ora_17713_i624688.trc

Non critical error ORA-48913 caught while writing to trace file "/sw/oraebs/EBSPRD/db/tech_st/11.2.0/admin/EBSPRD_ebsprddb01/diag/rdbms/ebsprd/EBSPRD/incident/incdir_624688/EBSPRD_ora_17713_i624688.trc"

Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached

As per MOSC doc “Bug 9003145 - Dump (kglIsOwnerVersionable) / "library cache: mutex X" waits (Doc ID 9003145.8)”,

A dump can occur in kglIsOwnerVersionable . Also "library cache: mutex X" waits may be seen for location kglIsOwnerVersionable if such a dump does occur.

Symptoms:

·         Process May Dump (ORA-7445) / Abend / Abort

·         Mutex Contention

·         Performance Affected (General)

·         Dump in or under kglIsOwnerVersionable

·         Waits for "library cache: mutex X"

We must prove to the customer that it is a bug in our database. So i have tracked the session details,sql_id and wait_event for the time when the error generated using dba_hist_active_sess_history.

(I'll give you sql query later to find the below output)

Output:

The above output proves that sql_id '8dx678sfn9zru' was waited for library cache: mutex X

Solution:

This issue is fixed in

• 11.2.0.2 (Server Patch Set)
• 11.2.0.1 Bundle Patch 3 for Exadata Database
• 11.2.0.1 Patch 9 on Windows Platforms