ORA-00600: internal error code, arguments: [4193]

ORA-00600: internal error code, arguments: [4193]

This is caused due to corrupted segment (may be due to power failure or database abrupt shutdown)- For more details visit - Oracle Support

Remember your database is up and running before following the below steps

Follow below instructions :

1. This command will give you segment_name. Copy the segment and use in below command.

 select segment_name,status from dba_rollback_segs where segment_id=8;


2. Use Segment_name from output of above command.

alter system dump undo header "_SYSSMU8_437891266$";

3. Offline the rollback segment:

alter system set "_smu_debug_mode"=4;

4. Check status,  if STATUS=OFFLINE

alter rollback segment "_SYSSMU8_437891266$" offline;

5.  if STATUS=OFFLINE

select status from dba_rollback_segs where segment_id=8;

6. Drop rollback segment

drop rollback segment "_SYSSMU8$";

7. Alter

alter system set "_smu_debug_mode"=0;