Oracle 18c install DBCA failure – PRCR-1006 PRCR-1071 CRS-2566

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s