DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Erorr creating Oracle database

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    Erorr creating Oracle database

    I am following the Oralce documentation in the 10G admin guide on how to manually create a database.

    When I issue the following command (create database command) I see the following error show up in my trace file. BTW, the fille was created on disk. Does anybody have an idea on how to rectify this?



    CREATE DATABASE pbh10g2
    USER SYS IDENTIFIED BY sys
    USER SYSTEM IDENTIFIED BY system
    LOGFILE GROUP 1 ('/rdbms/oracle_data/10g2/pbh10g2/redo01.log') SIZE 50M,
    GROUP 2 ('/rdbms/oracle_data/10g2/pbh10g2/redo02.log') SIZE 50M,
    GROUP 3 ('/rdbms/oracle_data/10g2/pbh10g2/redo03.log') SIZE 50M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    MAXINSTANCES 1
    DATAFILE '/rdbms/oracle_data/10g2/pbh10g2/system01.dbf' SIZE 325M REUSE
    EXTENT MANAGEMENT LOCAL
    SYSAUX DATAFILE '/rdbms/oracle_data/10g2/pbh10g2/sysaux01.dbf' SIZE 325M REUSE
    DEFAULT TABLESPACE tbs_1
    DEFAULT TEMPORARY TABLESPACE temp
    TEMPFILE '/rdbms/oracle_data/10g2/pbh10g2/temp01.dbf'
    SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    DATAFILE '/rdbms/oracle_data/10g2/pbh10g2/undotbs01.dbf'
    SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;


    *** 2006-08-14 11:22:20.429
    kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
    Control file created with size 416 blocks
    *** 2006-08-14 11:22:47.648
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
    Offending statement at line 5792
    CREATE UNDO TABLESPACE UNDOTBS DATAFILE
    '/rdbms/oracle_data/10g2/pbh10g2/undotb
    s01.dbf'
    SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5792
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    you're creating UNDOTBS and your init.ora has UNDOTBS1.

    there are tools for this, you know?
    Jeff Hunter

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    Thanks for your help. I know about the tools. Being a newbie to Oracle I wanted to try it with the manual steps so I can see what is under the covers.

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Google it.........

    Try out!

    All the best.
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Feb 2003
    Posts
    63
    use DBCA a lot easier

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