Oracle Issue running 12.1.0.2 clusterware with 11.2.0.2 database

Recently been tasked with planning an upgrade from 11.2.0.2 to 12.1.0.2.


After the upgrade I  needed to install another database so the cluster had two databases.
Oracle Cluster = 12.1.0.2
Oracle Database = 11.2.0.2

So I ran dbca from the Oracle Database home and the installer got part of the way into adding the database and I saw:

PRCR-1006 : Failed to add resource ora<name>.db for null
PRCD-1183 : Failed to upgrade configuration of service type to version 11.2.0.2.0
PRCR-1071 : Failed to register or update resource type ora.service.type
CRS-0245 : User doesn't have enough privileges to perform the operation




Trying to implement the workaround in Doc ID 13460353.8 - Registration of 11.2 database fails against 12.1 CRS stack (required fix for 11g DB with 12c GI).

We have 11.2.0.2 database software and 12.1.0.2 clusterware currently install (we are preparing for to upgrade). I am trying to create a new database and get CRS-0245. I have 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 ) and am planning on running the workaround:

[root bin]# ./crsctl modify type ora.lnxd.db -attr "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=3.2"
CRS-4995: The command 'Modify type' is invalid in crsctl. Use srvctl for this command. 



Solution - Use the -unsupported flag. 
[root@ bin]# ./crsctl modify type ora.database.type -attr "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=3.2" -unsupported
[root@ bin]# ./crsctl modify type ora.service.type -attr "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=2.2" -unsupported


7 comments:

  1. Thank you for the post. Saved time by not creating the SR with Oracle.

    ReplyDelete
  2. Just worked like a charm. Sadly I created an SR and wasted 2 days, still without any luck.

    ReplyDelete
  3. The main function of concurrency control is to ensure optimal levels of performance in the database even if various constraints are placed on the operations of the database.kpi dashboards

    ReplyDelete
  4. Firewall configuration will help in protecting the data and ensuring the security of the database. mysql dashboards

    ReplyDelete