Question:
I am trying to clone my database and I
get the OSD-04002 error:
ORA-00344: unable to re-create . . .
ORA-27040: skgfrcre: create error, unable to
create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
How do I resolve the ORA-00344 error?
Answer:
You start by using the
oerr utility to look up OSD-04220 error:
OSD-04002
Unable to open file
Cause:- The
specified path or filename is invalid, or the destination device is
full.
Action:- Make
sure the path and file exist, and the device has free space.
If this fails, increase the number of OS file handles.
Also, see the related
ORA-00344 unable to re-create error.
You need to check these disk storage related issues:
- Missing mount-point or Windows drive letter:
In another condition, a non-existent mount point
(or non-existent disk) can cause these errors:
ORA-00344: unable to
re-create online log 'D:\ORADATA\PROD\REDO01B.ORA'
ORA-27040: skgfrcre: create error, unable to
create file
OSD-04002:
unable to open file
O/S-Error: (OS 5) Access is denied.
In the above case, the PC does not have a D:
drive mapped to Windows.
- Incorrect OS Permissions -
The directory owner should be your "oracle" user, and the
permission should be at least 770, to allow the Oracle user and
ensure that the is in the dba UNIX group. A permission of
770 on the directory should allow you to allocate files within
the mount point.
In Windows, abandon all hope and migrate to Linux. You can issue the chmod 770 on the
directory node to correct the permissions:
oracle> cd 'u01/oradata/prod
oracle>
chmod 770 logs
- Not enough Disk Space - You need to check the
filesystem space and ensure
that there is enough room within the directory using the “df –k”
command. In Windows, go to "Computer --> Disks
--> (right click on disk letter)
For more information on using OS commands, see the book
Oracle Shell Scripting
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2012
All rights reserved.
Oracle ©
is the registered trademark of Oracle Corporation.
|
|
