Scenario:
DB node Crashes after upgrading from 12.0 to 19c.
Error:
2021-02-04T12:00:15.450521+00:00
Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc:
ORA-00600: internal error code, arguments: [3732], [33], [2], [], [], [], [], [], [], [], [], [] <<<<<=================================================
Errors in file /u01/database/19.0.0/diag/rdbms/doyen/doyenB/trace/doyenB_lgwr_56472.trc (incident=596913) (PDBNAME=CDB$ROOT):
ORA-470 [] [] [] [] [] [] [] [] [] [] [] [] <<<<<======================
Incident details in: /u01/database/19.0.0/diag/rdbms/doyen/doyenB/incident/incdir_596913/doyenB_lgwr_56472_i596913.trc
2021-09-06T19:00:15.924505+00:00
Dumping diagnostic data in directory=[cdmp_20210906190015], requested by (instance=2, osid=47689 (LGWR)), summary=[incident=596912].
2021-09-06T19:00:16.306844+00:00
LOGMINER: End mining logfile for session 18 thread 1 sequence 17377, /ocfsd101/ora/doyendata/redo_n1g6a.log
Non critical error ORA-48913 caught while writing to trace file “/u01/database/19.0.0/diag/rdbms/doyen/doyenB/incident/incdir_457813/doyenB_lgwr_56472_i1235913.trc”
Error message: ORA-48913: Writing into trace file failed, file size limit [4157440] reached
Writing to the above trace file is disabled for now…
2021-09-06T19:00:17.130101+00:00
USER (ospid: 98472): terminating the instance due to ORA error 470 <<<<<=============================
2021-02-04T19:00:29.482486+00:00
ORA-1092 : opitsk aborting process
2021-02-04T19:00:21.237954+00:00
Termination issued to instance processes. Waiting for the processes to exit, wait time 5 sec <<<<<===============================================
2021-02-04T12:00:42.98273+00:00
License high water mark = 1423
Solution:
The fix is first included in 19.9 Oct 2020 DBRU
The one off patch is available for DBRU 19.7.0.0.200414
we can download and apply the below patch
Patch 30414491: LNX64-20.1-ASM,DB LGWR HIT ORA-00600[3732] THEN INST CRASH
Release Oracle Database 19.7.0.0.0 DBRU
Platform Linux x86-64
File Name p30414491_197000DBRU_Linux-x86-64.zip
Reference :
Bug 30414491 – LGWR process hits ORA-600[3732] and Instance crashes ( Doc ID 30414491.8 )
