Friday, February 17, 2012

CRS-4228: Value of attribute 'pgrp:dba:r-x' is missing



We connected Exalogic to Exadata.
Over SDP. And created the LISTENER_IB, which listens in IB interface.

Next time, during dbca created next one ordinary DB the message appears:

PRCR-1006 : Failed to add resource ora.DBNAME.db
PRCP-0171 : Failed to register or update resource ora.DBNAME.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource 'ora.LISTENER_IB.lsnr', which is part of dependency specification





















Let's check rights:
 
$ crsctl status resource ora.LISTENER_IB.lsnr -p

NAME=ora.LISTENER_IB.lsnr
TYPE=ora.listener.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
...

But other resources have other rights:

# /u01/app/11.2.0.3/grid/bin/crsctl status resource ora.LISTENER_SCAN1.lsnr -p
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
ACL=owner:oracle:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=


CRSCTL utility reference

So, let's change:

[oracle@ed01db02 ~]$ crsctl modify resource ora.LISTENER_IB.lsnr -attr ACL=owner:oracle:rwx,pgrp:dba:r-x,other::r--
CRS-4228: Value of attribute 'pgrp:dba:r-x' is missing
CRS-4000: Command Modify failed, or completed with errors.

[oracle@ed01db02 ~]$ crsctl modify resource ora.LISTENER_IB.lsnr -attr ACL=owner:oracle
CRS-0258: Invalid ACL string format.
CRS-4000: Command Modify failed, or completed with errors.

[oracle@ed01db02 ~]$ crsctl modify resource ora.LISTENER_IB.lsnr -attr "ACL=owner:oracle:rwx,pgrp:dba:r-x,other::r--"
CRS-4228: Value of attribute 'pgrp:dba:r-x' is missing
CRS-4000: Command Modify failed, or completed with errors.

What's wrong ???

MOS helps:

"crsctl modify resource" fails with "CRS-4228: Value of attribute ')' is missing" [ID 958455.1]
Solution: To prevent the comma in the attribute from being interpreted as an attribute delimiter,
the attribute value needs to be enclosed in single quotes ('):


[root@ed01db01 ~]#  crsctl modify resource ora.LISTENER_IB.lsnr -attr "ACL='owner:oracle:rwx,pgrp:dba:r-x,other::r--' "
[root@ed01db01 ~]#




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...