DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Ora 27040

  1. #1
    Join Date
    Apr 2002
    Posts
    291

    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

  2. #2
    Join Date
    Apr 2002
    Posts
    291
    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
    PNRDBA

  3. #3
    Join Date
    Apr 2002
    Posts
    291
    Hi gurus, please help me out from this problem.... i've to get this today done.

    thanks a lot in advance....
    PNRDBA

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Hi

    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
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width