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: –
- 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.