Upgrades to Oracle Database (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
  • Oracle Database
  • Oracle Database
  • Oracle Database

Direct Upgrade to Oracle Database 12.2

No direct upgrades are supported from versions below Oracle Database

For versions older than Oracle Database 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.


Share this:

39 thoughts on “Upgrades to Oracle Database (and Downgrades)

  1. Hi Mike,

    Where do I get the upgrade?

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

    Thank You.

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


  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 for quite a while for two simple reasons:

    (1) Oracle Database 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 ( or – 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 will need some treatments (patches and parameters) but actually all my customers I helped with going live on are EXTREMELY happy with it. Just at a conference recently somebody mentioned in the audience that for him and his company is the most stable release he has seen since 7.3.4. And yes, there are some treatments necessary.


  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" πŸ˜‰


  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.


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


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



  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
    /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/).

    My question regarding future upgrades to
    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).

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

  15. Hi Mike,

    We would like to upgrade to 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 nodes.
    2. Stop 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.

  17. Hi Mike,
    Are you aware of any manuals describing how to do in-place upgrade of existing DBCS from 12.1 to 12.2?
    I’aware how to install a new Oracle 12.2 home and dbua instance to it.
    But will it cause problems with existing db cloud tools or service web ui?

    • Ed,

      the upgrade path currently is to move your database from one to another environment and upgrade it there. You could also install 12.2 in your current env by installing 12.2 via SSH manually. But then you rely on a silent install etc. I know that the team is testing the upgrade option right now – and it should be released soon and ease things.

      I will blog about it as soon as things are settled rock solid.


      • Mike,
        Thank you for the update. Moving DBCS database to other environment seems to be complicated as this database is already tied with existing Java Cloud Services.
        Yes, my initial intention was to do a silent dbua (so it is transparent to external services), but I was not sure if I needed to do more steps to make cloud managing tools (/var/opt/oracle/ocde) aware of this change.
        Looking forward for the upgrade option.
        Thank you,

        • Ed,

          it should be available within a few weeks hopefully. I will update the blog with a new post as soon as it is ready to go-live. And I fully agree, all other options don’t seem very reasonable.


  18. Hello Mike,

    Please share the details on this blog for Database Downgrade from Oracle to Oracle Non-CDB.


Leave a Reply

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

* Checkbox to comply with GDPR is required


I agree

This site uses Akismet to reduce spam. Learn how your comment data is processed.