ORA-01552: non-system tablespace 'users' cannot be processed using system rollback segments

Fault symptom:
ERROR: 12-09-20 16:15:03 get the maximum size ERROR: CallableStatementCallback; uncategorized SQLException for SQL [{call USP_SYS_CMSCODE (?, ?, ?, ?)}]; SQL state [72000]; error code [1552]; ORA-01552: non-system tablespace 'users' cannot use system rollback segments
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31
ORA-06512: In line 1; nested exception is java. SQL. SQLException: ORA-01552: non-system tablespace 'users' cannot use system rollback segments
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31
ORA-06512: In line 1

Java. lang. RuntimeException: CallableStatementCallback; uncategorized SQLException for SQL [{call USP_SYS_CMSCODE (?, ?, ?, ?)}]; SQL state [72000]; error code [1552]; ORA-01552: non-system tablespace 'users' cannot use system rollback segments
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31
ORA-06512: In line 1
; Nested exception is java. SQL. SQLException: ORA-01552: non-system tablespace 'users' cannot use system rollback segments
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24
ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31
ORA-06512: In line 1
 
Fault analysis:
The UNDO tablespace data file is damaged, causing the update operation to fail.
 
Fault repair:
C: \ Documents ents and Settings \ Administrator> sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Thursday September 20 17:26:38 2012
Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

SQL> create undo tablespace "UNDOTBS02" datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ zjport \ undotbs02.dbf' size 128 m reuse autoextend on next 10 m maxsize 2048 m;

The tablespace has been created.

SQL> alter system set undo_tablespace = UNDOTBS02 scope = spfile;

The system has been changed.

SQL> alter system set undo_management = auto scope = spfile;

The system has been changed.

SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
 
SQL> startup;
The ORACLE routine has been started.
The database has been loaded.
The database has been opened.

SQL> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

The tablespace has been deleted.

SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup;
The ORACLE routine has been started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
The database has been loaded.
The database has been opened.