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