Minimum Supported Version for Database Upgrades

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?”

Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below.

Upgrade?

When I speak about database upgrades, I mean you’ll use either the command line upgrade (i.e. catupgrd.sql or catctl.pl) or the GUI tool, the Database Upgrade Assistant (DBUA). Other techniques such as Data Pump or Transportable Tablespaces are usually version independent. But the upgrade process is supported in an exact defined scope.

Oracle Database 18c

Versions for direct database upgrades to Oracle 18c:

  • Oracle 11.2.0.3
  • Oracle 11.2.0.4
  • Oracle 12.1.0.1
  • Oracle 12.1.0.2
  • Oracle 12.2.0.1

See: Oracle Database Upgrade Guide 18c

Oracle Database 12.2.0.1

Versions for direct database upgrades to Oracle 12.2.0.1:

  • Oracle 11.2.0.3
  • Oracle 11.2.0.4
  • Oracle 12.1.0.1
  • Oracle 12.1.0.2

See: Oracle Database Upgrade Guide 12.2.0.1

Oracle Database 12.1.0.2

Versions for direct database upgrades to Oracle 12.1.0.2:

  • Oracle 10.2.0.5
  • Oracle 11.1.0.7
  • Oracle 11.2.0.2
  • Oracle 11.2.0.3
  • Oracle 11.2.0.4
  • Oracle 12.1.0.1

See: Oracle Database Upgrade Guide 12.1.0.2

Oracle Database 11.2.0.4

Database upgrades to Oracle 11.2.0.4 were supported from:

  • Oracle 9.2.0.8
  • Oracle 10.1.0.5
  • Oracle 10.2.0.2
  • Oracle 10.2.0.3
  • Oracle 10.2.0.4
  • Oracle 10.2.0.5
  • Oracle 11.1.0.6
  • Oracle 11.1.0.7
  • Oracle 11.2.0.1
  • Oracle 11.2.0.2
  • Oracle 11.2.0.3

See: Oracle Database Upgrade Guide 11.2.0.4

Further Information

In case you are seeking for a solution for a non-directly supported version upgrade please have a look at:

–Mike

[Update Feb 18, 2018 – Added Oracle Database 18c information]

Leave a Reply

Your email address will not be published. Required fields are marked *