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

Thread: Creating new log groups and members

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    SCO Unixware 7
    Oracle 8.1.6

    Hi friends.

    I am attempting to ceate new log groups and members so that I can resize.

    I issue the following command through sqlplus connected as 'system'.

    alter database add logfile group4
    '/u04/oradata/prod/redo4a.log' size 10m,
    '/u04/oradata/prod/redo4b.log' size 10m;

    When executed I get the following :

    error at line 1
    ora - 00301: error in adding logfile '/u04/oradata/prod/redo4a.log' size 10m, - file cannot be created.
    ora-27040 skgfrcre : create error, unable to create file Intel SVR4 Unix Error 2: No such file or directory.

    The directory does exist, but the file does not. I m assuming that Oracle will create dynamically.

    Anyone know what's wrong?

    Thanks

    Suresh











  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    I think a space is required between group and groupno.

    group 4 and not group4

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    wrong synatx correct syntax is

    ALTER DATABASE test
    ADD LOGFILE GROUP 4
    ('/u04/oradata/prod/redo4a.log' ,
    '/u04/oradata/prod/redo4b.log') SIZE 10M;

    hope thsi helps

    regards
    hrishy

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Sorry about that.

    I did actually put a space in it when I tried through sqlplus.

    Same problem still exists.

    I also tried creating a file in the specified directory and was able to, so the OSUSER (oracle) does have write permissions to that directory. There is plenty of space in the u04 drive.

    any ideas?





  5. #5
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Its working for me .i think your syntax is still wrong.

    regards
    hrishy

  6. #6
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Hrishy..

    Thanks mate, don't think I brought my brain in with me today. Forgot th initial /.

    Suresh

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