ORA-01595 ORA-00607 ORA-00600

Errors in file /export/home/oracle/admin/cobra/bdump/cobra_smon_22146.trc:

ORA-01595: error freeing extent (5) of rollback segment (31))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [4271], [4056], [], [], [], [], []

SOLUTION:
Run DBV utility to check,if any datafiles is in recovery mode or corrupted.

NOTE: To know more about DB Verify Utility, read Note 35512.1 on Metalink.

If every thing is fine use below steps to get rid of the problem:


SYS@cobra> show parameter undo


NAME TYPE VALUE
———————————— ———– ——————————
undo_management                         string                                      AUTO
undo_retention                               integer                                        900
undo_tablespace                            string                                       undotbs1

SYS@cobra> CREATE UNDO TABLESPACE undotbs2 DATAFILE ‘/data02/cobra/undo02.dbf’ SIZE 2g REUSE AUTOEXTEND ON;


SYS@cobra> alter system set undo_tablespace = ‘undotbs2’ ;


SYS@cobra> show parameter undo


NAME TYPE VALUE
———————————— ———– ——————————
undo_management                                 string    AUTO
undo_retention                                       integer  900
undo_tablespace                                    string    undotbs2

Now you can Drop your old undo tablespace:

SYS@cobra> drop tablespace undotbs1 including contents cascade constraints;

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply