ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Hello guys..
I just moved into this new job and inherited this problem when i started the database.
======================
SQL> startup
ORACLE instance started.
Total System Global Area 303532544 bytes
Fixed Size 731648 bytes
Variable Size 285212672 bytes
Database Buffers 16777216 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
==================================
so, i went into alert log and saw this...
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
so, i changed the pfile and changed undo_management from AUTO to MANUAL and started the database. Database started fine. So then, i deleted the old UNDO that is creating the problems, and created a new UNDO, and shutdown the database.
Then, I went and changed the pfile and changed the undo_management from MANUAL to AUTO and started the database.
Its giving the same error....
any help ?
thanks for help
Ron
What is the alternative method
What is the alternative method
i have the same error " ORA-30012: undo tablespace "
from u r advice i have changed the pfile parameter for undo to manual -"undo_management=MANUAL".
but i need a alternative solution for this from the beginning,, (while Creating the database)?
And i want to know why this is happening (reason)?