ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN

run{

allocate channel prmy1 type disk;

allocate channel prmy2 type disk;

allocate auxiliary channel stby type disk;

duplicate target database for standby from active database

spfile

parameter_value_convert 'testdb1','testdb2'

set db_name='testdb1'

set db_unique_name='testdb2'

set db_file_name_convert='/testdb1/','/testdb2/'

set log_file_name_convert='/testdb1/','/testdb2/'

set control_files='+DATA'

set log_archive_max_processes='4'

set standby_archive_dest = '/holding/testdb2/standby_logs'

set log_archive_dest_1 = 'LOCATION=/holding/testdb2/archive_logs valid_for=(online_logfile, all_roles)'

set log_archive_dest_2 = 'LOCATION=/holding/testdb2/standby_logs valid_for=(standby_logfile, standby_role)'

set standby_file_management='AUTO'

set log_archive_config='dg_config=(testdb1,testdb2)'

;

}

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 04/19/2017 17:25:50

RMAN-05501: aborting duplication of target database

RMAN-06136: ORACLE error from auxiliary database: ORA-00200: control file could not be created

ORA-00202: control file: '+DATA'

ORA-17502: ksfdcre:4 Failed to create file +DATA

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-12547: TNS:lost contact

Solution:

In my case when I checked the permission of $ORACLE_HOME and $GRID_HOME and the permission was incorrect which caused the problem. After fixing the permission it works fine.

[root@testdb2 ~]$ ls -al /opt/oracle/product/11.2.0.3/bin/oracle

-rwxr-x--x 1 oracle oinstall 232512956 Apr 17 12:01 /opt/oracle/product/11.2.0.3/bin/oracle

[root@testdb2 ~]$ ls -al /opt/grid/product/11.2.0.3/bin/oracle

-rwxr-x--- 1 grid oinstall 203972891 Jun 17 2012 /opt/grid/product/11.2.0.3/bin/oracle

The file permission should be "-rwsr-s--x". I have change the permission using chmod 6751

[root@testdb2 ~]$ chmod 6751 /opt/oracle/product/11.2.0.3/bin/oracle

[root@testdb2 ~]$ chmod 6751 /opt/grid/product/11.2.0.3/bin/oracle

[root@testdb2 ~]$ ls -al /opt/oracle/product/11.2.0.3/bin/oracle

-rwxr-x--x 1 oracle oinstall 232512956 Apr 17 12:01 /opt/oracle/product/11.2.0.3/bin/oracle

[root@testdb2 ~]$ ls -al /opt/grid/product/11.2.0.3/bin/oracle

-rwsr-s--x 1 grid oinstall 203972891 Jun 17 2012 /opt/grid/product/11.2.0.3/bin/oracle