If you are starting an upgrade plan, do it directly to 19c. Why?
Well, first let’s say that 19c is “equal” to 126.96.36.199 on previous version model, while 18c is 188.8.131.52, after latest 184.108.40.206. So, thinking reasonably, you would already plan for latest PSU on the future version, right? So this is 19c.
But not only this. It’s well known that Oracle’s Terminal Patchset is the Long Term Release for each version. And for 12.2 family this is 19c.
The image below (From Doc ID 742060.1) should help on clarifying this:
In summary, since August 1st 2019:
– 220.127.116.11 is already on Extended Support (20% more expensive unless you have ULA)
– 12.1 family is already on Extended Support (20% more expensive unless you have ULA)
Which only leave us with 12.2 Family. Now I ask you, why jump to any “PSU” other than the final one?
Also, support on 18.104.22.168 goes only up to Nov 2020 and for 18c (22.214.171.124) only to Jun 2021, while 19c goes up to 2026 with ES/ULA!
I’m not even raising the great improvements we have on newer versions (if you are in 11.2, shame on you, you are basically 6 years behind the world technology wise).
Myself , I already migrated several databases on different clients to 19c and it’s running preeeetty fine. So trust on it!
Ok, so to migrate to 19c? (Some tips):
– To migrate directly to 19c you need to be on supported terminal patch set (126.96.36.199, 188.8.131.52) or on 12.2 family (184.108.40.206, 18c).
– Get in touch and use AutoUpgrade mechanism (you’ll love it!) – AutoUpgrade Tool (Doc ID 2485457.1)
– Check Upgrade Guide: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/index.html
– Have a look on Mike Dietrich blog for news: https://mikedietrichde.com/
– Test it before doing in prod.
Release Schedule of Current Database Releases (Doc ID 742060.1)
Very nice and complete post (in portuguese) on this topic from Ricardo Portilho.
I like very much the table below as well: