DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

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

  1. #11
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by tarana View Post
    can u explain the process of creating database by using DBCA
    What's wrong with Oracle documentation? http://download.oracle.com/docs/cd/B...install003.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  2. #12
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by PAVB View Post
    What's wrong with Oracle documentation? http://download.oracle.com/docs/cd/B...install003.htm
    But Pablo, that would require thinking and a little work...

  3. #13
    Join Date
    Mar 2010
    Posts
    35

    Question

    Please Seniors,, why u leaders making confusion in this issue,, please give me a straight answer to over come this undo tablespace.

  4. #14
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by 4iappsDBA View Post
    Please Seniors,, why u leaders making confusion in this issue,, please give me a straight answer to over come this undo tablespace.
    Make sure that the undo tablespace specified in you init/spfile points to your undo tablespace.

  5. #15
    Join Date
    Mar 2010
    Posts
    35

    Undo Problem Solved

    Yes you are correct just now i did and its working fine..

    i would like to post the database creation syntax here, please dont mine.

    its just to upcome from UNDO TABLESPACE problem in common.

    1) In "init.ora" file please set the UNDO TABLESPACE name and keep it on ur mind.

    ###########################################
    # System Managed Undo and Rollback Segments
    ###########################################
    undo_management=AUTO
    UNDO_TABLESPACE=UNDOTBS1


    2) Type creation commands in a notepad which will helps you to write it without any wrong spells,directory paths and commas(').

    3) Here u have to remember the UNDO TABLESPACE NAME u given in "init.ora" file, and specify the same in the line "undo tablespace UNDOTBS1"

    For u reference here am giving a sample prg.

    create database iapps
    logfile group 1 'C:/oracle/product/10.2.0/oradata/iapps/redo1.log' size 10m,
    group 2 'C:/oracle/product/10.2.0/oradata/iapps/redo2.log' size 10m,
    group 3 'C:/oracle/product/10.2.0/oradata/iapps/redo3.log' size 10m
    datafile 'C:/oracle/product/10.2.0/oradata/iapps/system.dbf' size 50m autoextend on
    next 2m maxsize 90m
    sysaux datafile 'C:/oracle/product/10.2.0/oradata/iapps/sysaux.dbf' size 25m autoextend on
    next 1m maxsize 40m
    undo tablespace UNDOTBS1
    datafile 'C:/oracle/product/10.2.0/oradata/iapps/undo.dbf' size 10m
    default temporary tablespace temp
    tempfile 'C:/oracle/product/10.2.0/oradata/iapps/temp.dbf' size 10m


    I Hope this will help ever new junior DBA's

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