ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

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

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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

  2. #2
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    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

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    oops...i forgot that..

    thakyou brhynold

    ron

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Hi dear, im just confused....I haven't really explore much of this undo thing...


    Quote 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

  6. #6
    Join Date
    May 2009
    Location
    Muscat,Oman
    Posts
    11

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

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    happening becuase you didnt create an undo tablespace properly - use dbca to create a database

  8. #8
    Join Date
    Oct 2006
    Posts
    175
    Read yxez's reply carefully. Reflect undo tablespace's name in pfile's undo_tablespace parameter. It should resolve the issue.

    HTH
    gtcol

  9. #9
    Join Date
    May 2009
    Location
    Muscat,Oman
    Posts
    11
    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

  10. #10
    Join Date
    Aug 2009
    Posts
    1

    Smile

    Quote Originally Posted by davey23uk View Post
    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
  •  



Click Here to Expand Forum to Full Width