Ora 27040

Hi Gurus,
I'm trying to create DB 9.0.1.4.0 on linux 7.1 using script. But i'm getting the following error.

ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 2: No such file or directory

Here i'm posting my script with error also, please help me out, i've to create the DB today and give it to my manager. Please let me know where i'm doing mistakes.

Thanks in advance.


SQL> startup nomount
ORACLE instance started.

Total System Global Area 453342860 bytes
Fixed Size 280204 bytes
Variable Size 436207616 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
SQL> @/home/oracle/crdbcmsdev.sql
create database cmsdev
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00301: error in adding log file
'u01/app/oracle/oradata/cmsdev/redolog1a.log' - file cannot be created
ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 2: No such file or directory



MY SCRIPT FOR CREATING DATABASE:
---------------------------------
create database cmsdev
datafile '/u01/app/oracle/oradata/cmsdev/system01.dbf' size 500M reuse
undo tablespace "undotbs" datafile '/u09/oradata/cmsdev/undotbs01.dbf' size 2000
M reuse
default temporary tablespace "temp01"
tempfile '/u09/oradata/cmsdev/temp01_01.dbf' size 2000M
logfile group 1 ('u01/app/oracle/oradata/cmsdev/redolog1a.log',
'/u02/oradata/cmsdev/redolog1b.log') size 100M,
group 2 ('u01/app/oracle/oradata/cmsdev/redolog2a.log',
'/u02/oradata/cmsdev/redolog2b.log') size 100M,
group 3 ('u01/app/oracle/oradata/cmsdev/redolog3a.log',
'/u02/oradata/cmsdev/redolog3b.log') size 100M
controlfile reuse;

The directory mentioned for creating log groups has write permissions for oracle user which is under dba group.

[oracle@cmsprod3 oradata]$ ls -l
total 4
drwxr-xr-x 2 oracle dba 4096 Feb 17 14:55 cmsdev


Thanks in advance

Hi gurus, please help me out from this problem.... i've to get this today done.

thanks a lot in advance....

Hi
The error is simple... You have to place a / infront of the directory

ie

Now you specified as 'u01/app/oracle/oradata/cmsdev/redolog1a.log'
and replace with '/u01/app/oracle/oradata/cmsdev/redolog1a.log'

Note the / in the begining...


Simple error eatup your day..

Thanks

Thomas