ORA-07445 – exception encountered: core dump

Issue :-

DB was down due to the ORA – 07445 error in the alert log

Cause:-

ORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV] [ADDR:0x44F823458] [PC:0x117171614] [Application data integrity precise] [2] Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2023-07-20T13:48:39.009825-04:00
opidrv aborting process CL04 ospid (26603) as a result of ORA-602
2023-07-20T13:48:39.014556-04:00
Dumping diagnostic data in directory=[cdmp_20230720134839], requested by (instance=1, osid=4294993899 (CL04)), summary=[incident=5600740].
2023-07-20T13:48:39.029997-04:00
PMON (ospid: 24963): terminating the instance due to ORA error 12752
2023-07-20T13:48:39.032414-04:00
Cause – ‘Instance is being terminated due to fatal process death (pid: 89, ospid: 26603, CL04)’
2023-07-20T13:48:39.042541-04:00
Process termination requested for pid 59456 [source = unknown], [info = 0] [request issued by pid: 24963, uid: 4000]

Solution: –

  1. For solaris, set the below parameter which will fix the issues.

Need to bounce the database to set the parameter.

“_memory_adi_enabled” = FALSE

2. If the issue is not fixed after setting up the above parameter, apply the below patch.

Download and apply Patch 35464935.

 

Recommended Posts

Start typing and press Enter to search