When attempting to register an 11.2 database against a 12.1 CRS stack, this error can seen in the DBCA.
From the Logfiles you see the same error:
PRCR-1006 : Failed to add resource ora.db11ee.db for ayap PRCD-1184 : Failed to upgrade configuration of database type to version 220.127.116.11.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
In my case the Database was 18.104.22.168.7 (DB PSU July 2013 applied) with 12C Clusterware 22.214.171.124. This is a known issue and is described in MOS Note: 13460353.8 Bug 13460353 – Registration of 11.2 database fails against 12.1 CRS stack (required fix for 11g DB with 12c GI) .
The are two solution for the problem first to add the GI PSU 126.96.36.199.4 or higher to the Database Home or to add a interim Patch.
In my case i have tried first to apply patch 13460353 to my Database Home with OPatch 188.8.131.52.4 but it is failing with this error.
[oracle@server1 13460353]$ /u01/patch/OPatch/opatch auto $PWD -oh $ORACLE_HOME Executing /u01/app/12.1.0/grid/perl/bin/perl /u01/patch/OPatch/crs/patch11203.pl -patchdir /u01/patch/t1 -patchn 13460353 -oh /u01/app/oracle/product/11.2.0/db_ee_1 -paramfile /u01/app/12.1.0/grid/crs/install/crsconfig_params Can't locate crspatch.pm in @INC (@INC contains: /crs/install /u01/app/12.1.0/grid/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/app/12.1.0/grid/perl/lib/site_perl/5.14.1 /u01/app/12.1.0/grid/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/app/12.1.0/grid/perl/lib/5.14.1 .) at /u01/patch/OPatch/crs/patch11203.pl line 406. BEGIN failed--compilation aborted at /u01/patch/OPatch/crs/patch11203.pl line 406.
Or simillar like this:
[oracle@server1 13460353]$ /u01/app/oracle/product/11.2.0/db_ee_1/OPatch/opatch auto $PWD -oh $ORACLE_HOME Executing /u01/app/12.1.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_ee_1/OPatch/crs/patch11203.pl -patchdir /u01/patch/t1 -patchn 13460353 -oh /u01/app/oracle/product/11.2.0/db_ee_1 -paramfile /u01/app/12.1.0/grid/crs/install/crsconfig_params /u01/app/12.1.0/grid/crs/install/crsconfig_params /u01/app/12.1.0/grid/crs/install/s_crsconfig_defs This is the main log file: /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatchauto2013-07-19_23-40-53.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatchauto2013-07-19_23-40-53.report.log Undefined subroutine &main::error called at /u01/app/oracle/product/11.2.0/db_ee_1/OPatch/crs/patch11203.pl line 1301.
The final solution was to apply the Path 16742216 (GI PSU) in my Database Home. I had a some troubles with the Response File for OPatch so the auto Parameter does not work for me.
The final OPatch command :
[oracle@server1 ~]$ /u01/app/oracle/product/11.2.0/db_ee_1/OPatch/opatch napply /u01/patch/t3/16619898/custom/server/16619898 -local -silent -oh /u01/app/oracle/product/11.2.0/db_ee_1 -invPtrLoc /u01/app/oracle/product/11.2.0/db_ee_1/oraInst.loc -ocmrf /u01/patch/ocm.rsp Oracle Interim Patch Installer version 184.108.40.206.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_ee_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_ee_1/oraInst.loc OPatch version : 220.127.116.11.4 OUI version : 18.104.22.168.0 Log file location : /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-07-20_00-33-41AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 16619898 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/db_ee_1') Is the local system ready for patching? [y|n] y Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '16619898' to OH '/u01/app/oracle/product/11.2.0/db_ee_1' Patching component oracle.rdbms, 22.214.171.124.0... Verifying the update... Patch 16619898 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-07-20_00-33-41AM_1.log OPatch succeeded.
After successfull installing the GI PSU the DBCA also completed without any error.