Oracle Upgrade
Upgrade Planning
Upgrade Planning
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 │└──────────┴────────────┴────────────┴─────────────────┴────────────────────────────────────────────────────────────────────────────────┘
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.
Deprecated and Desupported features.
https://docs.oracle.com/database/121/UPGRD/deprecated.htm (12.1 Deprecated and Desupported Features)
Versions
Versions
21c (Innovation Release) - New Features
21c (Innovation Release) - New Features
Blockchain Tables
Native JSON Datatype
Executing JavaScript inside Oracle Database
SQL Macros
Database In-Memory Vector Joins
Self-Managing In-Memory Column Store
In-Memory Hybrid Columnar Scans
Expression based init.ora parameters
Automatic Zone Maps (Exadata)
In-Database Machine Learning
AutoML
Optimized Graph Models
Sharding Enhancements
Persistent Memory (PMEM) Support
12.1.0.2 - New Features
12.1.0.2 - New Features
Oracle Database In-Memory
Oracle Big Data SQL
Oracle JSON Document Store
Oracle REST Data Services
Improvements to Oracle Multitenant
Advanced Index Compression
Zone Maps
Approximate Count Distinct
Attribute Clustering
Full Database Caching
Rapid Home Provisioning
12.1.0.1 - New Features
12.1.0.1 - New Features
Parallel Upgrade including Pre/Post-Upgrade-Fix-Ups
Full Transportable Export/Import Feature
Oracle Multitenant
Bibliography
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://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/
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/
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/
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/