creating database results in error ora-01503, ora-00200, ora-
Date: Mon, 29 Apr 2002 11:53:13 +0200
Message-ID: <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
Total System Global Area 118255568 bytes
pfile="E:\oracle\admin\SOURCEDB\scripts\init.ora";
ORACLE instance started.
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 Mon Apr 29 2002 - 11:53:13 CEST