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


10 comments:

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

    ReplyDelete
    Replies
    1. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

      Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


      Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

      Delete
  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