PRCR-1071: CRS-0245: PRCD-1184 : Failed to upgrade configuration of database type to version 11.2.0.3.0 to 12c Cluster.

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

Unable to register the database to on 11.2.0.3 to 12c Cluster.

[oracle@rac131 dbs]$ . oraenv

ORACLE_SID = [OCM11G1] ?

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac131 dbs]$ cd

[oracle@rac131 ~]$ srvctl add database -d OCM11G -o /u01/app/oracle/product/11.2.0.3/DB_1 -p +DG_DATA/OCM11G/parameterfile/spfileOCM11G.ora

PRCR-1006 : Failed to add resource ora.ocm11g.db for ocm11g

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

[oracle@rac131 ~]$

[oracle@rac131 ~]$

During database registration from 11.2.0.3 binary to 12c Cluster, we are getting above error.   This is an published bug which need to fix before the registration.  Bug 13460353 - Registration of 11.2 database fails against 12.1 CRS stack (required fix for 11g DB with 12c GI) (Doc ID 13460353.8)

Workaround

Rediscovery Notes

 Registration of an 11.2 database fails against a 12.1 CRS stack

Workaround

 The preference is to use the patch for this issue.

 If required the following commands may be used to work around the problems:

  crsctl modify type ora.database.type -attr  "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=3.2" "-unsupported

  crsctl modify type ora.service.type -attr "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=2.2" "-unsupported

 (note that -unsupported flag is required on the above commands otherrwise they will error)

Note:

 This fix is needed in the 11.2 DB home in order to work with 12c GI.

 The fix is included in 11.2.0.3.4 GI PSU onwards and interim patches

 are available for other 11.2 releases here: Patch:13460353

Download the patch 13460353 for your database binary version and apply patch one by one on all 11.2.0.3 database home.

After download unzip the patch in stage directory and apply.

Applying the patch

[oracle@rac131 13460353]$ /u01/app/oracle/product/11.2.0.3/DB_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0.3/DB_1 -local /nfs/Maintenance/software/Oracle/database/PSU/13460353/custom/server/13460353

Oracle Interim Patch Installer version 11.2.0.3.11

Copyright (c) 2016, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/DB_1

Central Inventory : /grid/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/DB_1/oraInst.loc

OPatch version    : 11.2.0.3.11

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/DB_1/cfgtoollogs/opatch/opatch2016-03-11_06-41-53AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   13460353

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0.3/DB_1')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '13460353' to OH '/u01/app/oracle/product/11.2.0.3/DB_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'

ins_srvm.mk:31: warning: ignoring old commands for target `libsrvm11.so'

ins_srvm.mk:71: warning: overriding commands for target `libsrvmocr11.so'

ins_srvm.mk:34: warning: ignoring old commands for target `libsrvmocr11.so'

ins_srvm.mk:74: warning: overriding commands for target `libsrvmhas11.so'

ins_srvm.mk:37: warning: ignoring old commands for target `libsrvmhas11.so'

Patch 13460353 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/11.2.0.3/DB_1/cfgtoollogs/opatch/opatch2016-03-11_06-41-53AM_1.log

OPatch completed with warnings.

[oracle@rac132 13460353]$ /u01/app/oracle/product/11.2.0.3/DB_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0.3/DB_1 -local /nfs/Maintenance/software/Oracle/database/PSU/13460353/custom/server/13460353

[oracle@rac133 13460353]$ /u01/app/oracle/product/11.2.0.3/DB_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0.3/DB_1 -local /nfs/Maintenance/software/Oracle/database/PSU/13460353/custom/server/13460353

Applied this patch to all 11.2.0.3 home (rac132/133)

Once applied the patch on all cluster database nodes.  Then proceed the database registration on 12c Cluster

[oracle@rac131 ~]$ srvctl add database -d OCM11G -o /u01/app/oracle/product/11.2.0.3/DB_1 -p +DG_DATA/OCM11G/parameterfile/spfileOCM11G.ora

[oracle@rac131 ~]$ srvctl add instance -d OCM11G -i OCM11G1 -n rac131

[oracle@rac131 ~]$ srvctl add instance -d OCM11G -i OCM11G2 -n rac132

[oracle@rac131 ~]$ srvctl add instance -d OCM11G -i OCM11G3 -n rac133

[oracle@rac131 ~]$ srvctl start database -d OCM11G