Oracle Upgrade

Upgrade Planning

Database-Key-Dates

eol oracle-database

┌──────────┬────────────┬────────────┬─────────────────┬────────────────────────────────────────────────────────────────────────────────┐│ cycle    │  release   │    eol     │ extendedSupport │ link                                                                           │├──────────┼────────────┼────────────┼─────────────────┼────────────────────────────────────────────────────────────────────────────────┤│ 21       │ 2021-08-13 │ 2024-04-30 │      False      │ https://docs.oracle.com/en/database/oracle/oracle-database/21/whats-new.html   ││ 19 LTS   │ 2019-04-25 │ 2024-04-30 │    2027-04-30   │ https://docs.oracle.com/en/database/oracle/oracle-database/19/whats-new.html   ││ 18       │ 2018-07-23 │ 2021-06-30 │      False      │ https://docs.oracle.com/en/database/oracle/oracle-database/18/whats-new.html   ││ 12.2     │ 2017-03-01 │ 2022-03-31 │      False      │ https://docs.oracle.com/en/database/oracle/oracle-database/12.2/whats-new.html ││ 12.1 LTS │ 2013-06-25 │ 2018-07-31 │    2022-07-31   │ https://docs.oracle.com/database/121/index.htm                                 ││ 11.2 LTS │ 2009-09-01 │ 2015-01-31 │    2020-12-31   │ https://docs.oracle.com/cd/E11882_01/index.htm                                 ││ 11.1 LTS │ 2007-08-09 │ 2012-08-31 │    2015-08-31   │ https://docs.oracle.com/cd/B28359_01/index.htm                                 ││ 10.2 LTS │ 2005-07-11 │ 2010-07-31 │    2015-07-31   │ https://docs.oracle.com/cd/B19306_01/nav/portal_1.htm                          ││ 10.1 LTS │ 2003-09-08 │ 2009-01-31 │    2012-01-01   │ https://www.oracle.com/database/technologies/database10g-doc.html              ││ 9.2 LTS  │ 2002-05-01 │ 2007-07-31 │    2010-07-31   │ https://www.oracle.com/database/technologies/oracle9i.html                     ││ 9.0      │ 2001-06-01 │ 2003-12-31 │      False      │ https://www.oracle.com/database/technologies/database10g-doc.html              │└──────────┴────────────┴────────────┴─────────────────┴────────────────────────────────────────────────────────────────────────────────┘
Oracle-Upgrade-Matrix
Note that you cannot always upgrade directly from your current version to your desired version. e.g. you cannot upgrade direct from 11.2.0.3 or 12.1.0.1 to 19c.


APEX-Oracle-Matrix
If you are also using APEX there are further considerations. e.g. to upgrade from 11.2.0.3 running APEX 4.2 to 19c running APEX 21 one option would be to first upgrade the database to 12.1.0.2 (the latest version to still support APEX 4.2 and a version that can be directly upgraded to 19c) then upgrade APEX to 21 (since this is supported on db 12.1.02 and 19c), then upgrade the db to 19c.

Deprecated and Desupported features.


https://docs.oracle.com/database/121/UPGRD/deprecated.htm (12.1 Deprecated and Desupported Features)

Versions

21c (Innovation Release) - New Features

12.1.0.2 - New Features

12.1.0.1 - New Features

Bibliography

https://mikedietrichde.com/2017/08/09/news-new-oracle-database-release-schedule/https://www.theregister.co.uk/2017/08/11/number_off_oracle_rounds_up_major_database_release_cycle_numbers/https://dohdatabase.com/ (TODO)https://endoflife.date/oracle-database
https://docs.oracle.com/database/121/UPGRD/deprecated.htm (12.1 Deprecated and Desupported Features)
https://support.oracle.comOracle Database Upgrade Path Reference List (Doc ID 730365.1)Database Server Upgrade/Downgrade Compatibility Matrix (Doc ID 551141.1)Release Schedule of Current Database Releases (Doc ID 742060.1)
AutoUpgradehttps://mikedietrichde.com/2020/12/16/download-the-newest-autoupgrade-for-19c-and-21c-upgrades/https://support.oracle.com/epmos/faces/DocumentDisplay?id=2485457.1https://mikedietrichde.com/2019/04/29/the-new-autoupgrade-utility-in-oracle-19c/
Multitenant (CDB/PDB)https://docs.oracle.com/en/database/oracle/oracle-database/19/spupu/about-upgrading-pluggable-databases-sequentially.html
23https://blogs.oracle.com/database/post/oracle-database-23c-the-next-long-term-support-releasehttps://blogs.oracle.com/developers/post/simplified-tde-configuration-in-oracle-database-23ai-free
21chttps://blogs.oracle.com/database/introducing-oracle-database-21chttps://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/
12.2https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/oracle-database-releases-that-support-direct-upgrade.html
12.1https://mikedietrichde.com/2014/07/22/oracle-database-12-1-0-2-is-available/https://mikedietrichde.com/2013/06/25/oracle-database-12c-is-available-for-download-now/
11.2https://juliandontcheff.wordpress.com/2011/09/24/oracle-database-11-2-0-3-new-featureshttps://mikedietrichde.com/2020/12/17/recap-support-periods-for-oracle-11-2-0-4-on-prem-and-in-the-cloud/