Upgrades to Oracle Database 12.2.0.1 (and Downgrades)


Oracle Database 12c Release 2 (12.2) is available now in the Oracle Cloud
in DBCS and ECS in both NAS and EMEA zones, as well as being available on Exadata Express Cloud Service. The Oracle Database 12.2 documentation should be published later today.

Just to note down, the versions supporting direct upgrade either with catctl.pl on the command line or with DBUA are:

  • Oracle Database 11.2.0.3
  • Oracle Database 11.2.0.4
  • Oracle Database 12.1.0.1
  • Oracle Database 12.1.0.2

Direct Upgrade to Oracle Database 12.2

No direct upgrades are supported from versions below Oracle Database 11.2.0.3.

For versions older than Oracle Database 11.2.0.3 other tools such as Data Pump or techniques such as Transportable Tablespaces may be used in order to avoid double- or triple-hops jumping from one release to another. And of course those will work when migrating into the Oracle Cloud as well.

For Downgrades you can downgrade back down to the version you have upgraded from for non-CDBs.

–Mike
.

33 thoughts on “Upgrades to Oracle Database 12.2.0.1 (and Downgrades)

  1. Hi Mike,

    Where do I get the 12.2.0.1 upgrade?

    I must be missing something because I have searched the Oracle and non Oracle sites, and haven’t found any 12.2.0.1 upgrade to download.

    Thank You.

  2. You’ll get the 12.2.0.1 software only in the Cloud right now. There’s no date communicated for the on-premises release yet.

    Cheers
    Mike

  3. When exactly Oracle Database 12c Release 2 (12.2) released?

    and is that possible to upgrade to this new release in our server machine without hosting our database in Cloud?

  4. Is there at least hypothetical date (or quarter or year) when the 12.2 will be available on-premises..?

    We are planning upgrade from 11.2 and would prefer to upgrade to 12.2 at once..

  5. Paul,

    I recommend to everybody being in my workshops and talks Oracle 12.1.0.2 for quite a while for two simple reasons:

    (1) Oracle Database 12.2.0.1 is not available yet on-premises but only in the Oracle Cloud – and no, I don’t have a confirmed date but we’ll announce it as soon as it gets confirmed.

    (2) Be honest: Most will wait for the first or even the second patch set (12.2.0.2. or 12.2.0.3) – and usually patch sets based on the experience in the past take 11-14 months after the initial base release.

    There is no such thing as a "First" and "Second" release anymore. I know that 12.1.0.2 will need some treatments (patches and parameters) but actually all my customers I helped with going live on 12.1.0.2 are EXTREMELY happy with it. Just at a conference recently somebody mentioned in the audience that for him and his company 12.1.0.2 is the most stable release he has seen since 7.3.4. And yes, there are some treatments necessary.

    Cheers
    Mike

  6. Oracle CORP showing the whole world how desperate they are loosing Could to Amazon. Every presentation from Oracle that I have attend lately Oracle are literately forcing to use Oracle Cloud . when you are Oracle shop 100% perhaps Oracle Cloud makes seance. But face it I need to run Casandra , Mongo, Etc. So to attract customers to Oracle Cloud Oracle offering 12.2 on Oracle Cloud only first, from the side it is looks so desperate from Oracle

  7. No, simply not enough time to attend all oracle related presentation, but those that I did went to Oracle starts with the prayer – ‘O deer Oracle Cloud …" "We are here in the name of Oracle Cloud " etc. But as for me DBA I evaluated both and I can boldly tell that Oracle Cloud is not the same as AWS. AWS is way more robust. and AWS idea of Cloud is way more robust. over 20 +years I notice that Oracle are very good on the core product, never good at GUI representational interface of the product, what’s makes user experience difficult and complex. I went and crated simple oracle db on Oracle Cloud , well took 3 hr to have it ready functional. I am asking myself a question did the Cloud tools created db or some team from India on the background manual ran dbca ???

  8. Sergey,

    as I blindly guess – you never been to one of my or Roy’s workshops πŸ˜‰ If your local user group is willing to host a full day event I would come and show you that not all Oracle presentations have to start with a prayer πŸ˜‰ πŸ˜‰

    And I see your points – but I’m not the right person to give you the best advice. I’m just the "upgrade guy" πŸ˜‰

    Cheers
    Mike

  9. Peter,

    yes of course – the non-CDB architecture has been deprecated only meaning we don’t develop it further. But nothing will change in Oracle Database 12.2 – and we’ll see what will happen afterwards.

    Cheers
    Mike

  10. Yes, of course. That’s a simple but manual exercise.

    Goto support.oracle.com
    Search for 161818.1
    Click on the 11.2 release link
    Click on the "Availability and Known Issues" note for your client’s patch set, for instance 11.2.0.4
    Then see the ALERTS, Patch Recommendations and also the ISSUES INTRODUCED.

    This is not a complete list but it gives you advice about the most important issues.

    Cheers
    Mike

  11. I have been working with Oracle since 9/9i versions and it is undoubtly a great RDBMS.

    But considering the issues I have been going through since then, I have no courage to upgrade a critical production environment, running smoothly, from 11.2.0.4 to 12.1. And even a release 12.2 wouldn’t make me upgrade promptly (not whithout creating a environment for exhaustive validation).

    Any Oracle tiny new features always bring complex licenses issues together. That will make me wait until I feel comfortable and ready to upgrade.

    I’m not even talking about using Oracle cloud.

  12. Some of you running oracle 9.2 – I will tell you that I am still running
    Oracle 7.3 on MPRAS OS , on Pentium III and my db is 1+TB on and Oracle Forms V3 with Pro*C, Ha Ha beat me on that lowest point.

  13. Hello, I looked at Oracle Technology Network > Database > Database 12c > Downloads for Oracle 12c Release 1 on Linux x86-64, but it is not there anymore.

    Do you happen to know where I can find Oracle Database 12c Release 1 to download for Linux x86-64?

    Thanks,

    Mike

  14. Hi Mike,
    Currently I’m installing 2 fresh 12.2 RACs.
    One issue while running the root.sh script was, that I had to change the
    ASM_DISCOVERY_STRING from
    /dev/sd* to /dev/mapper to
    in /u01/app/12.2.0/grid/crs/install/crsconfig_params.
    This is because, we are using multipath devices and root.sh scrip expects the candidate devices under the wrong path (/dev/sd* instead of /dev/mapper/).

    However:
    My question regarding future upgrades to 12.2.0.2:
    Should I update the /u01/app/12.2.0/grid/crs/install/crsconfig_params with new parameters, such as new NICs for private or public networks, paths and so on, which will occured after the initial installation of the RAC? I’m asking this, because I assume that this file is the reference for future upgrades.

    Best regards Peter

      • Hi Peter,

        REG> This is because, we are using multipath devices and root.sh scrip expects the candidate devices under the wrong path (/dev/sd* instead of /dev/mapper/).

        The discovery string for ASM (devices) can be changed during the installation. root.sh takes the value provided by the installer – it does not “expect” a value. The installer offers to change the discovery string in interactive mode as well as in silent mode. Please, let me know whether you need more information on this part.

        For the current system, you don’t need to change crsconfig_params, as it is not required to update crsconfig_params for any configuration changes after the initial deployment. The crsconfig_params file in a GI home is for one-time use only – during root.sh/rootupgrade.sh of that home.

        In other words, once the system is installed, any subsequent (in-place) patch or other operations will use the current configuration of the system that is manifested in the OLR and / or the profile. The current crsconfig_params file is not maintained constantly and therefore will not be used directly.

        During upgrades, the installer populates the new crsconfig_params in the target home with the up-to-date configuration data of the cluster. This crsconfig_params in the new/target home will be used by rootupgrade.sh of that home. rootupgrade.sh will never access crsconfig_params of the old home for any data.

        Concluding, there is no need to maintain the crsconfig_params file.

        REG> Should I update the /u01/app/12.2.0/grid/crs/install/crsconfig_params with new parameters, such as new NICs for private or public networks, paths and so on, which will occured after the initial installation of the RAC? I’m asking this, because I assume that this file is the reference for future upgrades.

        Your assumption is not correct. See the above clarification.

        Hope this helps (and thanks for Markus Michalewicz who got me the answer).
        Cheers
        Mike

        • Mike,
          many thanks for your effort. You did realy help me.
          However, I could not discover any issues with 12.2 GI and DB.
          Swingbench loadtest has reached 6000 TPS per instance, unplug/plug of PDB works very well, restore and recover, too. Solid work!
          One issue comes with Oracle Linux (see: https://community.oracle.com/thread/4069268), but this I could resolve.
          We want to go in production within the next 2 months…
          Best regards!
          “Viele Grüße aus Dresden”
          Peter

  15. Hi Mike,

    We would like to upgrade 11.2.0.4 to 12.2.0.1 using GI home cloning, with GI home gold copy with latest RU applied. The crsconfig_params file (and a few other files) are removed from the gold copy. So, with upgrade steps by cloning (high level) as follows:

    1. Deploy the 12.2 GI gold image copy into 12.2/grid home on all 11.2.0.4 nodes.
    2. Stop 11.2.0.4 CRS on all nodes.
    3. Run clone.pl to register 12.2/grid home in inventory.xml. (=> clone.pl … ORACLE_HOME=”/../12.2/grid” … CRS=true)
    4. Before config.sh, set CRS=false for the 12.2/grid home in inventory.xml, as one one GI home can have CRS=true. (=> runInstaller -updateNodeList ORACLE_HOME=”/../12.2/grid” CRS=false)
    5. As 12.2/grid/crs/install/crsconfig_params not exist in gold copy, will next step config.sh run?
    I.e. will config.sh(rootupgrade.sh) re-create the crsconfig_params file as you mentioned?
    6.Execute config.sh -silent -responseFile , with oracle.install.option=UPGRADE.

    Are the above steps correct? I hope I do not miss any key steps, e.g. the crsconfig_params management before config.sh (rootupgrade.sh).

    Your input are much appreciated!

  16. Hi Mike,

    I just finished a fresh 12.2 GI installation using cloning method. The clone.pl did create the crsconfig_params file, so step 5 in the above is not needed as you mentioned previously.

Leave a Reply

Your email address will not be published. Required fields are marked *