C:\Users\Raw>sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 28 15:23:34 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 587203136 bytes
Database Buffers 473956352 bytes
Redo Buffers 5595136 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'UNDOTS3' does not exist or of wrong type
Process ID: 2716
Session ID: 5 Serial number: 3
SQL> startup mount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2182592 bytes
Variable Size 587203136 bytes
Database Buffers 473956352 bytes
Redo Buffers 5595136 bytes
Database mounted.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTS3
SQL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 ARB_TABLESPACE YES NO YES
7 ARB2_TABLESPACE YES NO YES
5 UNDOTBS2 YES NO YES
8 TEMP2 NO NO YES
9 UNDOTBS3 YES NO YES
10 rows selected.
SQL> alter system set undo_tablespace=UNDOTBS3 scope=both;
alter system set undo_tablespace=UNDOTBS3 scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'UNDOTS3' does not exist or of wrong type
Process ID: 1128
Session ID: 5 Serial number: 3
SQL>