Re: creating database results in error ora-01503, ora-00200, ora-

How is your control files defined in ="E:\oracle\admin\SOURCEDB\scripts\init.ora"?

Did you manually create the directory "E:\oracle\oradata\nmeofdb\"?

HTH Guang

Christian Satzger <stanley42_at_gmx.net> wrote in message news:<b84qcu8p55k5numeeabg3okinolnoqlp5k_at_4ax.com>...
> Hello,
>
> we are trying to create a database on an Win 2000 Server with Oracle
> 8.1.7, but we only get this error-log:
>
> ----------> snip <-----------------
>
> SQL> startup nomount
> pfile="E:\oracle\admin\SOURCEDB\scripts\init.ora";
> ORACLE instance started.
>
> Total System Global Area 118255568 bytes
> Fixed Size 282576 bytes
> Variable Size 83886080 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 532480 bytes
> SQL> CREATE DATABASE nmeofdb
> 2 MAXINSTANCES 1
> 3 MAXLOGHISTORY 1
> 4 MAXLOGFILES 5
> 5 MAXLOGMEMBERS 5
> 6 MAXDATAFILES 100
> 7 DATAFILE 'E:\oracle\oradata\nmeofdb\system01.dbf' SIZE 325M REUSE
> AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
> 8 UNDO TABLESPACE "UNDOTBS" DATAFILE
> 'E:\oracle\oradata\nmeofdb\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND
> ON
> NEXT 5120K MAXSIZE UNLIMITED
> 9 CHARACTER SET WE8MSWIN1252
> 10 NATIONAL CHARACTER SET AL16UTF16
> 11 LOGFILE GROUP 1 ('E:\oracle\oradata\nmeofdb\redo01.log') SIZE
> 100M,
> 12 GROUP 2 ('E:\oracle\oradata\nmeofdb\redo02.log') SIZE 100M,
> 13 GROUP 3 ('E:\oracle\oradata\nmeofdb\redo03.log') SIZE 100M;
> CREATE DATABASE nmeofdb
> *
> ERROR at line 1:
> ORA-01501: CREATE DATABASE failed
> ORA-00200: controlfile could not be created
> ORA-00202: controlfile: 'E:\oracle\oradata\nmeofdb\CONTROL01.CTL'
> ORA-27040: skgfrcre: create error, unable to create file
> OSD-04002: unable to open file
> O/S-Error: (OS 5) Access is denied.
>
> ----------> snap <-----------------
>
> After this, we tried to create to db- and control-files on Drive C:\
> at the same machine. We get the same error-messages, but the
> control-files where created by oracle. While connecting to the db, we
> get an error ORA-01092 (i think, this is ok, because the db was not
> created correctly)
>
> We tried to create the database on several Machines with Win 2000
> Server or Win 2000 Professional --> it´s ok
> On this Machines we tried it with 8.1.6, 8.1.7 and 9i without any
> problems.
>
> Thank´s for any help
>
> Christian
Received on Tue Apr 30 2002 - 20:49:33 CEST