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.

11g_12c_cl_err

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 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

In my case the Database was 11.2.0.3.7 (DB PSU July 2013 applied) with 12C Clusterware 12.1.0.1. 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 11.2.0.3.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 11.2.0.3.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 11.2.0.3.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    : 11.2.0.3.4
OUI version       : 11.2.0.3.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, 11.2.0.3.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.

Advertisements

Kommentar verfassen

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

WordPress.com-Logo

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

Twitter-Bild

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

Facebook-Foto

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

Google+ Foto

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

Verbinde mit %s