Creating logfile group error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Creating logfile group error

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    26
    I tried the follwoing SQL in 8.0.05 and NT 4 SP 4


    alter database add logfile group 3 '\\filer720\oracle_ega\new.ora' size 10M

    and got the following error

    ORA-00301: error in adding log file '\\filer720\oracle_ega\new.ora' - file cannot be created
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 5) Access is denied.

    anyone know what is up ?

  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink Creating logfile group error

    Do you have write permissions to that directory?

  3. #3
    Join Date
    Dec 2000
    Posts
    11
    Have you tried creating a file there as the oracle software owner? It just sounds like the write o/s priv to that share is missing ...

  4. #4
    Join Date
    Oct 2000
    Posts
    26

    got permission now i get this....

    we fixed the permisison issue now i get this....


    alter database add logfile group 3 's:\oracle_ega\new.ora' size 10M
    *
    ORA-00301: error in adding log file 's:\oracle_ega\new.ora' - file cannot be created
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.

    s: is mapped to the \\filer720\c$, the device i am writing to...

  5. #5
    Join Date
    Dec 2000
    Posts
    19
    Hi Are u using a network drive and trying to add the logfile group. Log file should be present in the same NT server. Don't use Network Mapped drives, if there is disconnection then Database might crash.


  6. #6
    Join Date
    Jun 2000
    Posts
    179
    Check if you have enough space on disk .

    Check if you have log group with the number.

    Try create the group under a new group number.

    make a scandisk and be sure that you do not have bad sectors on hard disk.

    try making the new group on another physical device if available.

    Log on to Oracle as the NT administrator or using the user that being used when installing Oracle.

    Make the statement like :
    Alter database ORCL add logfile group 3 ......

    add the database name to the alter statement ( SID ) and set the environment variable using " Set Oracle_SID=ORCL " to the SID name you want to alter.

    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

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