Re: unable to create database

On Wed, 5 Jan 2000 15:47:53 -0000, "News server" <paul.scrivens_at_opus-portfolio.co.uk> wrote:

>Hi Folks,
>
>We are having trouble creating an 8.1.5 database on NT: -
>
>SVRMGR> CREATE DATABASE DEMO
> 2> LOGFILE 'r:\Oracle\oradata\DEMO\redo01.log' SIZE 1024K,
> 3> 'r:\Oracle\oradata\DEMO\redo02.log' SIZE 1024K
> 4> MAXLOGFILES 32
> 5> MAXLOGMEMBERS 2
> 6> MAXLOGHISTORY 1
> 7> DATAFILE 'D:\Oracle\oradata\DEMO\system01.dbf' SIZE 50M REUSE
> 8> MAXDATAFILES 254
> 9> MAXINSTANCES 1
> 10> CHARACTER SET WE8ISO8859P1
> 11> NATIONAL CHARACTER SET WE8ISO8859P1;
>CREATE DATABASE DEMO
>*
>ORA-01501: CREATE DATABASE failed
>ORA-00200: controlfile could not be created
>ORA-00202: controlfile: 'r:\Oracle\oradata\DEMO\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.
>
>svrmgrl is complaining that it does not have permission to create files on a
>network mapped drive. We have checked permissions and they seem OK and we
>can create files manually in the target directories. If we run the same
>scripts putting the files on local drives all seems OK. We have also tried
>mapping an area of a local drive and use that for database files - we got
>the same access denied messages !
>
>Any ideas ?
>
>Paul Scrivens
>paul.scrivens_at_opus-portfolio.co.uk
>
>
>

Sure,
Oracle doesn't allow networked drives. Which is reasonable, because if the remote server goes down, the database will also go down, because in your example your files are vital for operation.

Placing a control file on a networked drive is just... Ok, no further comments. You get the picture probably.

Sorry,

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Jan 05 2000 - 12:34:39 CST