ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

[yxez]

Hi dear, im just confused....I haven't really explore much of this undo thing...

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.

Ron

So you mean here that changing the pfile from AUTO to MANUAL and
deleting the UNDO(supposedly creating the problem) was not the
real solution right?

The real problem is that, the undo tablespace name was not reflected in the pfile's (undo_tablespace parameter).
I mean the solution is just to reflect the undo tablespace name.

Am i right? davey...