ORA-00607/ORA-00600

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

SQL> show parameter undo
NAME                                 TYPE        VALUE
———————————— ———– ——————————
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS

SQL> alter system set undo_management=’MANUAL’ scope=spfile;

SQL > Shutdown immediate ;
SQL > Startup ; 

SQL > create undo tablespace NEW_UNDOTBS datafile ‘/u01/app/oracle/oradata/SID/NEW_UNDOTBS01.DBF’ size 1G ;

SQL> alter system set undo_tablespace=’NEW_UNDOTBS’ scope=spfile;

System altered.

SQL> alter system set undo_management=’AUTO’ scope=spfile;

System altered.

SQL> drop tablespace UNDOTBS01 including contents;
ORA-01548: active rollback segment ‘_SYSSMU1_1255349037$’ found, terminate dropping tablespace

SQL> select * from v$rollname ;

USN NAME
———- —————–
0   SYSTEM
1  _SYSSMU1$
2 _SYSSMU2$
3 _SYSSMU3$
4 _SYSSMU4$
5 _SYSSMU5$
6 _SYSSMU6$

 SQL > Create Pfile=’/u01/New.init’ from spfile
 File Created

SQL > Shutdown immediate ;

*.undo_management=’MANUAL’
*.undo_retention=1800
*.undo_tablespace=’NEW_UNDOTBS’
*._offline_rollback_segments= (_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$ )

• Startup database from new pfile without create spfile ;
• try to Drop Tablespace Now, this way should work.
• After drop Undo Tablespace, Remove _offline Parameter and undo_management to AUTO