TRUE or FALSE – Extended Period of Support is June 2021

The investment in the Oracle Database once done has never been lost. Now, almost any older versions of the Oracle Database could be upgraded to the latest Oracle Database 12c which is

The Premier Support for Oracle Database Version 11.2 has ended on Jan 31, 2015.

It is now 9 months over!

But, the Extended Period of Oracle Support for the current database version is June 2021.

There are two ways to upgrade to Oracle database 12c:

1) The Direct Path and Higher

2) The Indirect Path

7.3.3 (lower) to 7.3.4 to to to 12.1.x

8.0.5 (or lower) to 8.0.6 to to to 12.1.x

8.1.7(or lower) to to to 12.1.x (or lower) to to to 12.1.x (or lower)to to 12.1.x lower) to to 12.1.x to to 12.1.x to to 12.1.x

The direct path allows you to upgrade directly from versions,, and and Higher to The Premium Period of Support for is until June 2018.

The indirect path requires you to plan and organize the upgrade to in several steps. The older the version of the Oracle database that you are going to upgrade, the longer the process.

The oldest version that could be upgraded to is 7.3.3 or lower to 7.3.4.

As of 8i and 9i upgrade, there are 2 to 4 steps to do it, for an example, versions 8.1.7(or lower) are first to be upgraded to, then will be upgraded to, and finally the version will be upgraded to

Again, think about it, it is a big advantage! The Premium Period of Oracle Support for is until June 2018 and the Extended Period of Oracle Support for is June 2021. It is about 6 years from today!

The Oracle Corporation recommendations about each possible path of the upgrade, direct or indirect, are explained in detail in the document

Oracle® Database Upgrade Guide 12c Release 1 (12.1) E41397-11

The cost of the upgrade includes in some extreme cases:

  1. the replacement of the hardware,
  2. the upgrade or replacement of the operating systems,
  3. the change or replacement of the applications,
  4. the change of the used client software,
  5. the prolonged downtime of your system,
  6. the number of the databases that you are upgrading.

The longer you avoid the upgrade to the Oracle Database 12c, the harder and more expensive it becomes.

To speed up the hole process of the upgrade, the Oracle Corporation advises you to run the new preupgrade script preupgrd.sql which will generate the fix up scripts and gives you the starting information about issues that might be present both before and after the upgrade. That would be the base of how to organize your upgrade and calculate the cost of it.

For the owners of the large systems with more than 100 Oracle databases running, there is the option of the PARALLEL UPGRADE that guarantee you:



Beside the command line script upgrade, there is the Database Upgrade Assistant (DBUA) which automates the hole upgrade process.

The Hands-On-Lab “Upgrade, Migrate and Consolidate to Oracle Database 12c” is available for DOWNLOAD from the website

The lab will guide you through the following tasks:

  1. Upgrade an database to Oracle
  2. Plug in this database into a CDB
  3. Migrate an database with Full Transportable Export into another PDB
  4. Unplug an PDB and plug/upgrade it into an CDB

If you are in a doubt about when to start the upgrade, now or later, the Hands-On Lab is a good starting point as it will show you how to do it, and allow you to experience the features of straight forward.

The Oracle Database 12c with a new architecture allows a multitenant container database to hold up to 252 pluggable databases.

The main features of the Oracle Database 12c are:

  • High Consolidation Density
  • Rapid Provisioning and Cloning
  • Rapid Patching and Upgrades
  • Managing Many Databases as One
  • Pluggable Database Resource Management.


The process of upgrading to Oracle Database may be costly and long and separated in many steps that should be done as required, but the final product is worth it. In the end, the Oracle Database 12c replaces all previous database versions and gives you the new start. Remember, the Premium Period of Oracle Support for is until June 2018 and the Extended Period of Oracle Support for is June 2021.

The above facts are taken from the following sources:

1) Oracle® Database Upgrade Guide 12c Release 1 (12.1) E41397-11

2) Nitin Maheshwari, PDF document “upgrade-to-oracle-database-12c-2412040-en-in”

3) Mike Dietrich, “Upgrade, Migrate, and Consolidate to Oracle Database 12c” , Oracle Webcast, 16 June 2015

4) Database Upgrade OTN website

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s