Wednesday 19 January 2011

ORA-17502: ksfdcre:5 Failed to create file +data

[oracle@VOL-ORATEST bin]$ rman target sys/xxxxx@bsquat catalog rman/xxxxx@gridem auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jan 19 13:12:26 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: BSQUAT (DBID=12345678)
connected to recovery catalog database
connected to auxiliary database: AUX (not mounted)

RMAN> duplicate target database to aux nofilenamecheck;

Starting Duplicate Db at 19-JAN-2011 13:12:37
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/19/2011 13:12:38
RMAN-06136: ORACLE error from auxiliary database: ORA-00200: control file could not be created
ORA-00202: control file: '+data'
ORA-15045: ASM file name '+data' is not in reference form
ORA-17502: ksfdcre:5 Failed to create file +data
ORA-15081: failed to submit an I/O operation to a disk


Solution===================
Ok so for anyone else running into this issue...

the permissions of the file $ORACLE_HOME/bin/oracle must look as follow:

-r-sr-s--x 1 oracle asmadmin

in my case the file belonged to oracle:oinstall, but as stated in my previous post I changed it to oracle:asmadmin.
By changing the user and group the file permissions looked as follows:

-r-xr-x--x 1 oracle asmadmin


[root@VOL-ORATEST bin]# ls -lrt oracle
-rwsr-s--x 1 oracle oinstall 163939510 Jan 14 17:20 oracle
[root@VOL-ORATEST bin]# chown oracle:asmadmin oracle
[root@VOL-ORATEST bin]# ls -lrt oracle
-rwxr-x--x 1 oracle asmadmin 163939510 Jan 14 17:20 oracle
[root@VOL-ORATEST bin]#



No comments: