product-lifecycle

Describe about product life cycle. For example, Microsoft, Apple, Oracle, etc.

Oracle DB 11gR2 cannot be upgraded directly to 21c (cannot upgrade)

Dear all, Did you know that you should definitely upgrade/upgrade your 11G (including R2) Oracle Database to 19c?
I did not know that.

Note to self. I would like to note that.

  • 11g/11gR2 must be upgraded to 19c
  • because 11g/11gR2 cannot be directly upgraded to 21c or 23c

11g/11gR2 cannot be directly upgraded to 21c or 23c

It is already mentioned in the 21c release note
There is no mention of 11gR2 here .

Oracle Database Releases That Support Direct Upgrade
https://docs.oracle.com/en/database/oracle/oracle-database/21/upgrd/oracle-database-releases-that-support-direct-upgrade.html

You can perform a direct upgrade to the new release from the following releases: 19c
18c
12c Release 2 (12.2)

I hope you understand that.
The Oracle Database Version that can be upgraded to 21c is 12.2 or later.
12.1 is also not available along with 11.2.

DB Version that you can upgrade directly to 19c (11.2 / 12.1)

On the other hand, it is possible to upgrade to 19c.
It is possible with both 11gR2 and 12cR1.

Oracle Database Releases That Support Direct Upgrade

You can perform a direct upgrade to the new release from the following releases:
* 11.2.0.4
* 12.1.0.2
* 12.2.0.1
* 18

But don't have to force yourself to upgrade from 11gR2 to 19c?

You certainly shouldn't force it, not by any means.
However, you should force yourself to try and upgrade to 19c!

Because versions that cannot be upgraded directly "may also lose compatibility"!

Of course, no one is saying no compatibility, but there are a lot of big changes that affect SQL and execution plans.
Of course the changes between versions that can't be upgraded directly are likely to be significant
Of course the direct upgradable versions have been checked for that somewhat right?
If a version is not directly upgradable, we have no choice but to assume that there will be incompatibilities.

This is an important point, so I'll say it again

  • Versions that cannot be directly upgraded have no choice but to consider incompatibilities as inevitable.

Don't rely on Sustaining Support, which is provided by Oracle in good faith.
Rather than upgrading at Oracle's behest, choose your own upgrade timing!
Let's use Oracle Database without being at the mercy of Oracle!

www.product-lifecycle.work

www.product-lifecycle.work

[EOL]