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;
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;