Thursday 4 April 2013

ORA-27040: file create error, unable to create file OSD-04002: unable to open file

How to solve this error (workaround)

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/04/2013 15:06:
05
ORA-19504: failed to create file "\\10.1.1.234\E\BACKUP\RMAN\GBM\INCR0\GBM_RMAN_CNTRL_09O688IJ_1_1"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

I had this problem when I tried to backup a database on Windows to another server using UNC link
Firstly don't use the $ sign like \\<some_server>\d$

Metalink and other posts says the Oracle services like the listener must be started as another account (Administrator) this adds more security risk but works.
Run services.msc go to your listener and change properties go to log on tab and change this account to say administrator with the password. You will need to restart both services 1. the listener 2.the database.
If you execute the above hopefully it will work 


No comments:

Post a Comment