Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Unanswered: [O9i on Win2003] Create database failed

    Am I crazy ?

    After a successfully startup nomount, I'm trying to run


    create database
    USER SYS IDENTIFIED BY ORACLE
    USER SYSTEM IDENTIFIED BY ORACLE
    LOGFILE
    GROUP 1 ('D:\oracle\redo\REDO01.log') SIZE 100M,
    GROUP 2 ('D:\oracle\redo\REDO02.log') SIZE 100M
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXLOGHISTORY 100
    MAXDATAFILES 50
    MAXINSTANCES 1
    ARCHIVELOG
    FORCE LOGGING
    DATAFILE 'D:\oracle\data\SYSTEM01.dbf' SIZE 128M
    DEFAULT TEMPORARY TABLESPACE TMP01 TEMPFILE 'D:\oracle\temp\TMP01.dbf' SIZE 100M
    UNDO TABLESPACE UNDO01 DATAFILE 'D:\oracle\undo\UNDO01.dbf' SIZE 50M
    set time_zone='+01:00';


    This statement is generating the following error msg:

    create database
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced


    In the dump file, I find the following "explanation"


    Citation:*** SESSION ID 9.1) 2004-10-19 07:56:49.000
    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 5161
    CREATE UNDO TABLESPACE UNDO01 DATAFILE 'D:\oracle\undo\UNDO01.dbf' SIZE 50M
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 5161
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type



    I'm sure that it doesn't exist, because I'm trying to create it !

    Some comments
    - All files specified in the command do not exist before running the create
    - all directories and subdirectories exist
    - I've all permissions in this host (admin)

    Any help/idea is welcome
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    my suggestion is your datasets are not large enough to fit the creation requirements

    the creation process breaks at a statement within a module SQL.BSQ which is building up/filling system.dbf which is only 128MB

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    system.dbf is large enough. The problem came from the undo tablespace automatic process of the version 9i. The name of the tablespace must be defined in the init.ora file
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •