srvctl Fails to Register Database With PRCR-1006 PRCR-1071 CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource (Doc ID 1415140.1)

Last updated on DECEMBER 12, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

11gR2 Grid Infrastructure environment, the following error is reported when tried to register database with srvctl from database home:

$ srvctl add database -d racdb -o /home/oracle/product/11.2/db
PRCR-1006 : Failed to add resource ora.racdb.db..
PRCR-1071 : Failed to register or update resource ora.racdb.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource 'ora.ons', which is part of the dependency specification


Both database and grid user have "oinstall" as primary group:

$ id oracle
uid=4501(oracle) gid=45(oinstall) groups=46(dba)

$ id grid
uid=4510(grid) gid=45(oinstall) groups=46(dba)


The offending resource has "oinstall" as primary group

$ crsctl stat res ora.ons -f
NAME=ora.ons
..
ACL=owner:grid:rwx,pgrp:oinstall:r-x,other::r--



OS command "ls" shows binary for offending resource has "dba" group:

$ ls -l $GRID_HOME/opmn/bin/ons
-rwxr-xr-x   1 grid     dba       317232 Aug 10  2011 /ocw/grid/opmn/bin/ons



However as "grid" user, "touch" creates a dummy file with "oinstall" as group:

$ touch /tmp/test-grid-file
$ ls -l /tmp/test-grid-file
-rw-r--r--   1 grid     oinstall       0 Feb 13 20:12 /tmp/test-grid-file

 

Other possible errors:

PRCR-1006 : Failed to add resource ora.LISTENER.lsnr for LISTENER
PRCR-1071 : Failed to register or update resource ora.LISTENER.lsnr
CRS-2532: OCR write failed for 'ora.LISTENER.lsnr'



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms