-
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
-
Have you changed the undo_tablespace parameter in the pfile to reflect the new undo tablespace name.
Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic
-
oops...i forgot that..
thakyou brhynold
ron
-
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.
Behind The Success And Failure Of A Man Is A Woman
-
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.
Am i right? davey...
Last edited by yxez; 10-25-2006 at 08:42 PM.
Behind The Success And Failure Of A Man Is A Woman
-
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)?
-
happening becuase you didnt create an undo tablespace properly - use dbca to create a database
-
Read yxez's reply carefully. Reflect undo tablespace's name in pfile's undo_tablespace parameter. It should resolve the issue.
HTH
gtcol
-
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
-
 Originally Posted by davey23uk
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|