Post 64 of Series - Some errors and their fixes

FOURTH MEHL: Great is the greatness of that humble being, whom the Guru Himself anointed in His Presence. All the world comes and bows to him, falling at his feet. His praises spread throughout the world. The galaxies and solar systems bow in reverence to him; the Perfect Guru has placed His hand upon his head, and he has become perfect. The glorious greatness of the Guru increases day by day; no one can equal it. O servant Nanak, the Creator Lord Himself established him; God reserves his honor. 

Index of all the posts of Gurpartap Singh's Blog

CRS-0245:  User doesn't have enough privilege to perform the operation

When you try to add 11gR2 database on 12c cluster (Grid Infrastructure) using the following commands, you get and error after first command as:

srvctl add database -d SDIEGO -o /u01/app/oracle/product/database/11.2.0.3 -p '+DATA/SDIEGO/PARAMETERFILE/spfile.268.830972273'
srvctl add instance -d SDIEGO -i SDIEGO1 -n rac20
srvctl add instance -d SDIEGO -i SDIEGO2 -n rac21



 16:42 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add database -d SDIEGO -o /u01/app/oracle/product/database/11.2.0.3 -p '+DATA/SDIEGO/PARAMETERFILE/spfile.268.830972273'
PRCR-1006 : Failed to add resource ora.sdiego.db for sdiego
PRCD-1184 : Failed to upgrade configuration of database type to version 11.2.0.3.0
PRCR-1071 : Failed to register or update resource type ora.database.type
CRS-0245:  User doesn't have enough privilege to perform the operation

Fix is:

On 12c cluster the default value is :

[root@rac20 ~]# /u01/app/grid/12.1.0.0/bin/crsctl  status type  ora.database.type -p | grep DEFAULT_VALUE=owner
DEFAULT_VALUE=owner:root:rwx,pgrp:oinstall:rwx,other::r--,group:oinstall:r-x,user:oracle:r-x


Update the permissions for both and service using following commands as root:

/u01/app/grid/12.1.0.0/bin/crsctl   modify type ora.database.type -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"
/u01/app/grid/12.1.0.0/bin/crsctl modify type ora.service.type  -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"

as :

[root@rac20 ~]# /u01/app/grid/12.1.0.0/bin/crsctl   modify type ora.database.type -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"
[root@rac20 ~]# /u01/app/grid/12.1.0.0/bin/crsctl modify type ora.service.type  -attr "ATTRIBUTE=TYPE_ACL, DEFAULT_VALUE='owner:root:rwx,pgrp:dba:rwx,other::r--,group:dba:r-x,user:oracle:rwx'"
[root@rac20 ~]#


Now add the database as:

 16:45 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add database -d SDIEGO -o /u01/app/oracle/product/database/11.2.0.3 -p '+DATA/SDIEGO/PARAMETERFILE/spfile.268.830972273'

 16:49 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add instance -d SDIEGO -i SDIEGO1 -n rac20

 16:49 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$ srvctl add instance -d SDIEGO -i SDIEGO2 -n rac21

 16:49 : oracle : rac20.rac.meditate.com : @DUMMY : /u01/app/oracle/product/database/11.2.0.3
$

He Himself created the world, O my Lord of the Universe; the Lord Himself plays in so many ways! Some enjoy enjoyments, O my Lord of the Universe, while others wander around naked, the poorest of the poor. He Himself created the world, O my Lord of the Universe; the Lord gives His gifts to all who beg for them. His devotees have the Support of the Naam, O my Lord of the Universe; they beg for the sublime sermon of the Lord.