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

[vr76413]

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

[brhynold]

Have you changed the undo_tablespace parameter in the pfile to reflect the new undo tablespace name.

[vr76413]

oops...i forgot that..

thakyou brhynold

ron

[yxez]

Hmmmn...I'm just curious what cause the problem, do u think that
someone had accidentally deleted the undo datafile? or drop the
undo tablespace.

[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...

[abdulhameedom]

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)?

[davey23uk]

happening becuase you didnt create an undo tablespace properly - use dbca to create a database

[gtcol]

Read yxez's reply carefully. Reflect undo tablespace's name in pfile's undo_tablespace parameter. It should resolve the issue.

HTH
gtcol

[abdulhameedom]

thank U my dear brother's.. i solved the problem with ur help..
am just a beginner, if i have any droughts or problem arrives please help me like this,,

U ppls still active in this blog,, that makes me more happy,, god bless U brothers

[tarana]

happening becuase you didnt create an undo tablespace properly - use dbca to create a database

can u explain the process of creating database by using DBCA