-
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 ?
-
Creating logfile group error
Do you have write permissions to that directory?
-
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 ...
-
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...
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|