Background
During my first Oracle 18c install I hit an installation issue with Oracle DBCA (Database Configuration Assistant) failing.
After looking at the installation log file “/u01/app/oraInventory/logs/InstallActions2018-07-26_12-18-47PM/installActions2018-07-26_12-18-47PM.log”
I could see the following:
…
PRCR-1006 : Failed to add resource ora.cdb1.db for cdb1
PRCR-1071 : Failed to register or update resource ora.cdb1.db
CRS-2566: User ‘oracle’ does not have sufficient permissions to operate on resource ‘ora.driver.afd’, which is part of the dependency specification.
…
Issue
The ‘oracle’ user primary group (dba) does not have privilege on ora.driver.afd
[oracle@z-oracle1 ~]$ id grid
uid=54331(grid) gid=1001(dba) groups=1001(dba),54321(oinstall),54333(asmdba),54334(asmoper),54335(asmadmin),54336(racdba)
[grid@z-oracle1 ~]$ id grid
uid=54331(grid) gid=1001(dba) groups=1001(dba),54321(oinstall),54333(asmdba),54334(asmoper),54335(asmadmin),54336(racdba)
Fix
Change the afd driver resource group to database user group e.g. ‘asmadmin’ to ‘dba’
[grid@z-oracle1 ~]$ crsctl stat res ora.driver.afd -p
…
ACL=owner:grid:rwx,pgrp:asmadmin:r-x,other::r–,user:grid:r-x
…
[grid@z-oracle1 ~]$ crsctl modify resource ora.driver.afd -attr “ACL=’owner:grid:rwx,pgrp:dba:r-x,other::r–,user:grid:r-x’ ” -init
[grid@z-oracle1 ~]$ crsctl stat res ora.driver.afd -p
…
ACL=owner:grid:rwx,pgrp:dba:r-x,other::r–,user:grid:r-x…
Once corrected I was able to resume the installation without any experiencing any further issues.
Hope this helps.
[twitter-follow screen_name=’RonEkins’ show_count=’yes’]
Leave a Reply