-
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
-
I think a space is required between group and groupno.
group 4 and not group4
-
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
-
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?
-
Hello
Its working for me .i think your syntax is still wrong.
regards
hrishy
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|