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

Thread: Create DATABASE error ???

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Unhappy

    I am getting this error, has anyone else seen it ? Any suggestions ?

    I have already tried all that I found on MetaLink.

    SVRMGR> CREATE DATABASE devdbx
    2> controlfile reuse
    3> DATAFILE '/u60/oradata/devdbx/system01.dbf' SIZE 250M reuse
    4> logfile group 1 ('/u40/oradata/devdbx/redo01.log') SIZE 100M reuse,
    5> group 2 ('/u41/oradata/devdbx/redo02.log') SIZE 100M reuse,
    6> group 3 ('/u40/oradata/devdbx/redo03.log') SIZE 100M reuse,
    7> group 4 ('/u41/oradata/devdbx/redo04.log') SIZE 100M reuse
    8> maxdatafiles 200
    9> maxinstances 8
    10> maxlogfiles 32
    11> character set US7ASCII
    12> national character set US7ASCII;
    CREATE DATABASE devdbx
    *
    ORA-01501: CREATE DATABASE failed
    ORA-02084: database name is missing a component

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    Try:
    1. Make sure database name in create database matchs
    that of init.ora.
    2. Put " around database name like: "devdbx"
    3. try without group since you only have one group member
    logfile '...',
    '...',


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