Step by step to resolve ORA-600 4194 4193 4197 on database crash
(Doc ID 1428786.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 9.2 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Dec-2013***
The following error is occurring in the alert.log right before the database crashes.
ORA-00600: internal error code, arguments: , [#], [#], , , , , 
This error indicates that a mismatch has been detected between redo records and rollback (undo) records.
Arg [a] - Maximum Undo record number in Undo block
Arg [b] - Undo record number from Redo block
Since we are adding a new undo record to our undo block, we would expect that the new record number is equal to the maximum record number in the undo block plus one. Before Oracle can add a new undo record to the undo block it validates that this is correct. If this validation fails, then an ORA-600  will be triggered.
This issue generally occurs when there is a power outage or hardware failure that initially crashes the database. On startup, the database does the normal roll forward (redo) and then rollback (undo), this is where the error is generated on the rollback.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!