Re: createing database results in error ora-01501, ora-00200...

As someone else has pointed out, undo tablespaces don't exist until 9i, so if this is genuinely 8i, you can confidently expect the thing to fail around about line 7.

However, I think your problem is even more basic than that. The thing fails actually at line 1, because the 'create database' command implies the creation of a control file, in whatever directory is specified in your init.ora. And the error message you've got is that Oracle is unable to create the controlfile in 'E:\oracle\oradata\nmeofdb\'. That will be because the directory structure is not right (for example, if you've really got a directory 'e:\oracle\u01\oradata\nameofdb'). Or because the directory structure specified is perfectly legit, but the permissions on the directory have been set so that Oracle doesn't have the permissions to write to it.

Sort that out, remove reference to features you don't actually have in the version you say you are using, and all should be well.

Regards
HJR "Christian Satzger" <stanley42_at_gmx.net> wrote in message news:2a342cd1.0204290717.6258370_at_posting.google.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 Mon Apr 29 2002 - 17:12:04 CDT