If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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

Originally Posted by vr76413

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.