| OSD-04002: unable to open file [message #130633] |
Mon, 01 August 2005 12:20  |
kals_kk
Messages: 61
Registered: August 2005
|
Member |
|
|
Hi ,
I am trying to create a database. My oracle home directory is on c:oracle\ora10. And I want to create the file on o:\DATABASE\FOOD\ which is a network drive. I am unable to create the control file. can somebody help me
SQL> CREATE DATABASE "FOOD"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 32
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 254
7 DATAFILE 'O:\DATABASE\FOOD\SYSTEM\SYSFOOD.ORA' SIZE 300M REUSE EXTENT MANAGEMENT LOCAL
8 SYSAUX DATAFILE 'O:\DATABASE\FOOD\SYSTEM\AUXFOOD.ORA' SIZE 300M REUSE AUTOEXTEND ON MAXSIZE UNL
IMITED
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'O:\DATABASE\FOOD\datafile\TEMP.ora' SIZE 25M AUTOEX
TEND ON NEXT 20M MAXSIZE 1000M
10 CHARACTER SET AL32UTF8
11 LOGFILE GROUP 1 ('O:\DATABASE\FOOD\LOGFILES\LOG1AFOOD.ORA', 'O:\DATABASE\FOOD\LOGFILES\LOG1BFOO
D.ORA') SIZE 5120K,
12 GROUP 2 ('O:\DATABASE\FOOD\LOGFILES\LOG2AFOOD.ORA', 'O:\DATABASE\FOOD\LOGFILES\LOG2BFOOD.ORA')
SIZE 5120K,
13 GROUP 3 ('O:\DATABASE\FOOD\LOGFILES\LOG3AFOOD.ORA', 'O:\DATABASE\FOOD\LOGFILES\LOG3BFOOD.ORA')
SIZE 5120K
14 USER SYS IDENTIFIED BY "welcome" USER SYSTEM IDENTIFIED BY "welcome"
15 /
CREATE DATABASE "FOOD"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: 'O:\DATABASE\FOOD\SYSTEM\CTL1FOOD.ORA'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
|
|
|
|
|
|
| Re: OSD-04002: unable to open file [message #130783 is a reply to message #130743] |
Tue, 02 August 2005 08:16  |
kals_kk
Messages: 61
Registered: August 2005
|
Member |
|
|
Hi,
I have created all the directories in prior before running the script itself. And I checked the file permissions also and I have been full control permission on that drive. Any more suggestions pls.
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
