RDBMS and Clusterware/Grid Infrastructure Compatibility

A recent “tweet” from Coskan regarding a problem he was having running DBUA with Oracle Database 11.2.0.2 on servers that were running Grid Intrastructure (Clusterware and Automatic Storage Management) version 11.2.0.1 stood out as I was scanning down Twitter… I thought you had to run Clusterware (and ASM) at a higher version than the database. I responded to Coskan and he came back to me stating that he’d run 10.2.0.3 Database Server on 10.2.0.1 Clusterware.

This just didn’t fit with what I’d understood about the requirements, so I wanted to find out what had given me the impression that this wasn’t possible/certified.

Readme for 6810189 10.2.0.4 Patchset

7.1.4 Upgrading Oracle Clusterware

The Oracle Clusterware software must be at the same or newer level as the Oracle software in the Oracle RAC Oracle home. Therefore, you should always upgrade Oracle Clusterware before you upgrade Oracle RAC. This patch does not allow you to upgrade Oracle RAC before you upgrade Oracle Clusterware.

Readme for 6890831 11.1.0.7 Patchset

7.1.2 Upgrading Oracle Clusterware

The Oracle Clusterware software must be at the same or newer level as the Oracle software in the Oracle RAC Oracle home or ASM Home. Therefore, you should always upgrade Oracle Clusterware before you upgrade Oracle RAC or Oracle ASM. This patch does not allow you to upgrade Oracle RAC or Oracle ASM before you upgrade Oracle Clusterware.

Readme for 8202632 10.2.0.5 Patchset

8.1.5 Upgrading Oracle Clusterware

The Oracle Clusterware software must be at the same or newer level as the Oracle software in the Oracle RAC Oracle home. Therefore, you should always upgrade Oracle Clusterware before you upgrade Oracle RAC. This patch does not allow you to upgrade Oracle RAC before you upgrade Oracle Clusterware.

… OK, so that explains where my “knowledge” had come from, but time to dig a little deeper and clarify the situation.

A bit of reading took me to Identifying Your Oracle Database Software Release

Component-Specific Release Number

The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.

“Different components can have different numbers in this position…” Well, that seems pretty conclusive. I then checked out the Certification information on MOS and found that Oracle Server – Enterprise Edition 11gR2 RAC is certified for Oracle Clusterware 11g. Does this suggest that it is acceptable to use Clusterware 11.1 with an 11.2 database? Moving on to look at Oracle Server – Enterprise Edition 10gR2 RAC, it is certified for Oracle Clusterware 10g. I was expecting to see version 10g or greater for 10gR2, but maybe that is implied?

Anyone tried 10.2 RDBMS on 10.1 Clusterware or 11.2 RDBMS on 11.1 Clusterware?

A quick survey of other Oracle DBAs revealed that I’m not alone in thinking that “The Oracle Clusterware software must be at the same or newer level as the Oracle software in the Oracle RAC Oracle home.” means that if you want to run Oracle Database 10.2.0.4 then the Clusterware needs to be at least 10.2.0.4.

The fact that Coskan has done it certainly shows that it’s possible, but I’d be interested to hear from others about their interpretation of the documentation and their real world experience.

Thanks in advance for any comments.

Advertisements

4 thoughts on “RDBMS and Clusterware/Grid Infrastructure Compatibility

  1. I patched 11.2.0.1 -> 11.2.0.2.

    On first test, I failed rootupgrade.sh and attempted to start grid. I can start from new home(ps -aef ), then upgrade database from “dbua”, but found, I’m using 11.2.0.2 database with 11.2.0.1 grid.

    So, I used “root.sh” (new grid home) and set import resource, then i can use “dbua”.

    On second test, I failed rootupgrade.sh again. but i fixed some… and run rootupgrade.sh again, It seemed ok…. then install + upgrade database (no error).
    http://surachartopun.com/2010/09/struggle-to-upgrade-oracle-database.html

    So, I think I should make sure I ‘ve done about Grid upgrading before I upgrade database…. anyway

  2. Ok all the fuzz was about me so I am now declaring the details of my statement πŸ™‚ As a member of BAAG I made a mistake or maybe I did not but I rely on my comrade’s words when I tweeted. He is still 100% sure that they ran 10.2.0.3 DB on 10.2.0.1 CRS. Our boss does not remember anything about the issue.

    I already got my answer from Oracle that it is not possible.

    I personally think I made a mistake about telling others experiences as they are absolute true which I normally do not trust even my own word before I try. Nevertheless, as you might guess trying those words needs a looong time consuming vm builts which I did not have time to do and just tweeted before trying πŸ™‚

    As a last word maybe it can be done but %100 not supported by Oracle so will be waste of time.

    sorry for the inconvenience caused

  3. One thing came into my mind is that if there wasn’t a new crs release between 10.2.0.1 and 10.2.0.4 then it may be the case.

    And while I am writing this my comrade prooved his fact and saved my credibility πŸ™‚

    [oracle@xxxxxxxa OPatch]$ ./opatch lsinventory

    Invoking OPatch 10.2.0.4.2

    Oracle Interim Patch Installer version 10.2.0.4.2

    Copyright (c) 2007, Oracle Corporation. All rights reserved.

    Oracle Home : /u01/crs/oracle/product/10.2.0/crs

    Central Inventory : /home/oracle/oraInventory

    from : /etc/oraInst.loc

    OPatch version : 10.2.0.4.2

    OUI version : 10.2.0.4.0

    OUI location : /u01/crs/oracle/product/10.2.0/crs/oui

    Log file location : /u01/crs/oracle/product/10.2.0/crs/cfgtoollogs/opatch/opatch2010-09-17_10-15-07AM.log

    Lsinventory Output file location : /u01/crs/oracle/product/10.2.0/crs/cfgtoollogs/opatch/lsinv/lsinventory2010-09-17_10-15-07AM.txt

    ——————————————————————————–

    Installed Top-level Products (2):

    Oracle Clusterware 10.2.0.1.0

    Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0

    There are 2 products installed in this Oracle Home.

    There are no Interim patches installed in this Oracle Home.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s