Register 11.2 DB with 12.1 Clusterware fails with CRS-0245

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
 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 (DB PSU July 2013 applied) with 12C Clusterware 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 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 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/ -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 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/ line 406.
BEGIN failed--compilation aborted at /u01/patch/OPatch/crs/ 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/ -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

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/

Undefined subroutine &main::error called at /u01/app/oracle/product/11.2.0/db_ee_1/OPatch/crs/ 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
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    :
OUI version       :
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 (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,

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.

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

Du kommentierst mit Deinem Abmelden /  Ändern )

Google Foto

Du kommentierst mit Deinem Google-Konto. Abmelden /  Ändern )


Du kommentierst mit Deinem Twitter-Konto. Abmelden /  Ändern )


Du kommentierst mit Deinem Facebook-Konto. Abmelden /  Ändern )

Verbinde mit %s