Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    9

    Unanswered: Database creation problem

    Hi

    I tried to create a database on Oracle 8.1.7 (Win xp). First I started up database in NOMOUNT state specifying pfile. It was fine. Further I issued following statement to create a database 'SHREE' from SQLPLUS.

    CREATE DATABASE SHREE
    CONTROLFILE REUSE
    LOGFILE GROUP1
    ('E:\DEV2K\ORA817\ORADATA1\SHREE\REDO101.LOG',
    'E:\DEV2K\ORA817\ORADATA1\SHREE\REDO102.LOG') SIZE 5M REUSE,
    GROUP2
    ('E:\DEV2K\ORA817\ORADATA1\SHREE\REDO201.LOG',
    'E:\DEV2K\ORA817\ORADATA1\SHREE\REDO202.LOG') SIZE 5M REUSE
    MAXLOGFILES 4
    MAXLOGMEMBERS 3
    MAXDATAFILES 254
    MAXINSTANCES 3
    ARCHIVELOG
    DATAFILE 'E:\DEV2K\ORA817\ORADATA1\SHREE\ANCSYS.DBF' SIZE 10M
    AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED
    DEFAULT TEMPORARY TABLESPACE TEMP
    TEMPFILE 'E:\DEV2K\ORA817\ORADATA1\SHREE\TEMPSHREE.DBF' SIZE 10M;

    I got an error at line 3 , ORA-02236: invalid file name.

    E:\DEV2K\ORA817\ORADATA1\SHREE\ directory is already in my system.

    It is to mention that my system has one database which is created at the time of installation.

    Please help me to figure out the possible causes of error. I have checked my parameter file and I belive it is fine.

    GS

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Try this in 3 steps :

    1. CREATE THE DATABASE
    CREATE DATABASE SHREE
    CONTROLFILE REUSE
    LOGFILE GROUP1
    ('E:\DEV2K\ORA817\ORADATA1\SHREE\REDO101.LOG',
    'E:\DEV2K\ORA817\ORADATA1\SHREE\REDO102.LOG') SIZE 5M REUSE,
    GROUP2
    ('E:\DEV2K\ORA817\ORADATA1\SHREE\REDO201.LOG',
    'E:\DEV2K\ORA817\ORADATA1\SHREE\REDO202.LOG') SIZE 5M REUSE
    MAXLOGFILES 4
    MAXLOGMEMBERS 3
    MAXDATAFILES 254
    MAXINSTANCES 3
    DATAFILE 'E:\DEV2K\ORA817\ORADATA1\SHREE\ANCSYS.DBF' SIZE 10M
    AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED

    2. CREATE YOUR OTHER TABLESPACES
    DEFAULT TEMPORARY TABLESPACE TEMP
    TEMPFILE 'E:\DEV2K\ORA817\ORADATA1\SHREE\TEMPSHREE.DBF' SIZE 10M;

    3. ALTER DATABASE ARCHIVELOG
    ARCHIVELOG

    This is assuming that the directory structure is ok ...

    HTH
    Gregg

Posting Permissions

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