dbca Fails With PRCR-1006 PRCR-1071 CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource 'ora.driver.afd'
<<Back to DB Administration Main Page
CRS-2566: User 'dbatst1' does not have sufficient permissions to operate on resource 'ora.driver.afd',
Log Extract
CRS-2566: User 'dbatst1' does not have sufficient permissions to operate on resource 'ora.driver.afd',
CRS-2566: User 'dbatst1' does not have sufficient permissions to operate on resource 'ora.driver.afd',
[ 2018-08-06 11:26:46.919 CEST ] PRCR-1006 : Failed to add resource ora.wdtestdba.db for wdtestdba
PRCR-1071 : Failed to register or update resource ora.wdtestdba.db
CRS-2566: User 'dbatst1' does not have sufficient permissions to operate on resource 'ora.driver.afd', which is part of the dependency specification.
[ 2018-08-06 11:26:51.541 CEST ] DBCA_PROGRESS : DBCA Operation failed.
PRCR-1071 : Failed to register or update resource ora.wdtestdba.db
CRS-2566: User 'dbatst1' does not have sufficient permissions to operate on resource 'ora.driver.afd', which is part of the dependency specification.
[ 2018-08-06 11:26:51.541 CEST ] DBCA_PROGRESS : DBCA Operation failed.
Cause
user ('dbatst1' ) or primary group (oinstall) does not have privilege on ora.driver.afd$ crsctl stat res ora.driver.afd -p |grep ACL
ACL=owner:oragrid:rwx,pgrp:asmadmin:r-x,other::r--,user:oragrid:r-x
Solution:
Modify the afd driver resource group to database user group.
$ crsctl modify resource ora.driver.afd -attr "ACL='owner:oragrid:rwx,pgrp:oinstall:r-x,other::r--,user:oragrid:r-x' " -init
$ crsctl stat res ora.driver.afd -p |grep ACL
ACL=owner:oragrid:rwx,pgrp:oinstall:r-x,other::r--,user:oragrid:r-x
Note:-Change the user and group according to your environment
Comments
Post a Comment