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 FEBRUARY 07, 2019
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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
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)
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--
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
-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
$ 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'
PRCR-1071 : Failed to register or update resource ora.LISTENER.lsnr
CRS-2532: OCR write failed for 'ora.LISTENER.lsnr'
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |