-
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;
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|