Wednesday, October 19, 2011

Database Upgrade/Downgrade Compatibility Matrix

Source Database Downgrade Possible to

10.2.x - 9.2.0.6.0 (or higher)
10.2.x - 10.1.0.4.0 (or higher)

Downgrade Compatibility Matrix for Downgrading from 10.1.x


Source Database Downgrade Possible to

10.1.x 9.2.0.4.0 (or higher)


Downgrade Compatibility Matrix for Downgrading from 9.2.x


Source Database Downgrade Possible to

9.2.x 9.0.1.3.0 (or higher)
9.2.x 8.1.7.3.0 (or higher)

UPGRADE


Upgrade Compatibility Matrix for Upgrading to 11.2.x

Minimum Version of the database that can be directly upgraded to Oracle 11g Release 2

Source Database Destination Database

9.2.0.8 (or higher) 11.2.x
10.1.0.5 (or higher) 11.2.x
10.2.0.2 (or higher) 11.2.x
11.1.0.6 (or higher) 11.2.x


The following database version will require an indirect upgrade path.

Source Database Upgrade Path Destination Database

7.3.3 (or lower) => 7.3.4.0 => 9.2.0.8 => 11.2.x
8.0.5 (or lower) => 8.0.6.x => 9.2.0.8 => 11.2.x
8.1.7 (or lower) => 8.1.7.4 => 10.2.0.4 => 11.2.x
9.0.1.3 (or lower) => 9.0.1.4 => 10.2.0.4 => 11.2.x
9.2.0.7 (or lower) => 9.2.0.8 => 11.2.x

Upgrade Compatibility Matrix for Upgrading to 11.1.x

Minimum Version of the database that can be directly upgraded to Oracle 11g Release 1

Source Database Destination Database

9.2.0.4 (or higher) 11.1.x
10.1.0.2 (or higher) 11.1.x
10.2.0.1 (or higher) 11.1.x

The following database version will require an indirect upgrade path.

Source Database Upgrade Path Destination Database

7.3.3 (or lower) => 7.3.4.0 => 9.2.0.8 => 11.1.x
8.0.5 (or lower) => 8.0.6.x => 9.2.0.8 => 11.1.x
8.1.7 (or lower) => 8.1.7.4 => 9.2.0.8 => 11.1.x
9.0.1.3 (or lower) => 9.0.1.4 => 9.2.0.8 => 11.1.x
9.2.0.3 (or lower) => 9.2.0.4.0 => 11.1.x



Upgrade Compatibility Matrix for Upgrading to 10.2.x

Minimum Version of the database that can be directly upgraded to Oracle 10.2.x

Source Database Destination Database

8.1.7.4 (or higher) 10.2.x
9.0.1.4 (or higher) 10.2.x
9.2.0.4 (or higher) 10.2.x
10.1.0.2 (or higher) 10.2.x


The following database version will require an indirect upgrade path.

Source Database Upgrade Path Destination Database

7.3.3 (or lower) => 7.3.4 => 8.1.7 =>8.1.7.4 => 10.2.x
7.3.4 (or lower) =>8.1.7 => 8.1.7.4 => 10.2.x
8.0.n (or lower) =>8.1.7 => 8.1.7.4 => 10.2.x
8.1.n (or lower) =>8.1.7 => 8.1.7.4 => 10.2.x



Upgrade Compatibility Matrix for Upgrading to 10.1.x

Minimum Version of the database that can be directly upgraded to Oracle 10.1.x

Source Database Destination Database

8.0.6 (or higher) 10.1.x
8.1.7 (or higher) 10.1.x
9.0.1 (or higher) 10.1.x
9.2.0 (or higher) 10.1.x


The following database version will require an indirect upgrade path.


Source Database Upgrade Path Destination Database

7.3.4 (or lower) => 8.0.6 => 10.1.x
8.0.5 (or lower) => 8.0.6 => 10.1.x
8.1.6 (or lower) => 8.1.7 => 10.1.x


Upgrade Compatibility Matrix for Upgrading to 9.2.x

Minimum Version of the database that can be directly upgraded to Oracle 9.2.x

Source Database Destination Database

7.3.4 (or higher) 9.2.x
8.0.6 (or higher) 9.2.x
8.1.7 (or higher) 9.2.x
9.0.1 (or higher) 9.2.x


The following database version will require an indirect upgrade path

Source Database Upgrade Path Destination Database

7.3.3 (or lower) => 7.3.4 => 9.2.x
8.0.5 (or lower) => 8.0.6 => 9.2.x
8.1.6 (or lower) => 8.1.7 => 9.2.x


DOWNGRADE



Downgrade Compatibility Matrix for Downgrading from 11.2.x

Source Database Downgrade Possible to

11.2.x 10.1.0.5.0 (or higher)
11.2.x 10.2.0.3.0 (or higher)
11.2.x 11.1.0.6.0 (or higher)


Downgrade Compatibility Matrix for Downgrading from 11.1.x

Source Database Downgrade Possible to

11.1.x 10.1.0.5.0 (or higher)
11.1.x 10.2.0.3.0 (or higher)


Downgrade Compatibility Matrix for Downgrading from 10.2.x

Source Database Downgrade Possible to

10.2.x 9.2.0.6.0 (or higher)
10.2.x 10.1.0.4.0 (or higher)

Downgrade Compatibility Matrix for Downgrading from 10.1.x

Source Database Downgrade Possible to

10.1.x 9.2.0.4.0 (or higher)


Downgrade Compatibility Matrix for Downgrading from 9.2.x

Source Database Downgrade Possible to

9.2.x 9.0.1.3.0 (or higher)
9.2.x 8.1.7.3.0 (or higher)



NOTE
1 : If you have applied a patchset since upgrading then it will not be possible to downgrade.
For example: If you upgraded from 9.2.0.6 to 10.2.0.1 and then applied the 10.2.0.3 patchset, then you cannot downgrade from 10.2.0.3 to 9.2.0.6. (You can only downgrade from 10.2.0.3 to 9.2.0.6 if you upgraded from 9.2.0.6 to 10.2.0.3)


2 : You can only downgrade to a version if you previously upgraded from that version.
For example: You can downgrade an 11.1.0.6 database to 10.2.0.3 only if you upgraded the database from 10.2.3. If you created a new 11.1.0.6 database, then you cannot downgrade the database to 10.2.0.3. Also, if you upgraded directly from 9.2.0.8 to 11.1.0.6, then you cannot downgrade to 10.2.0.3 since you did not upgrade from 10.2.0.3.


3 : You cannot downgrade if the database parameter COMPATIBLE was ever set higher than the version you upgraded from.
For example: If you upgraded from 10.2.0.3 to 11.1.0.6, then after the upgrade set COMPATIBLE to 11.1.0.6, then no downgrade is possible. Also, if you upgraded directly from 9.2.0.8 to 11.1.0.6, then after upgrade set COMPATIBLE to 10.2.0.1, then
no downgrade is possible.

4 : You cannot upgrade database binaries from one major release to another.
For example : You cannot upgrade the binaries from 10.1.0.2.0 to 10.2.0.1.0. Major releases must be installed in a separate oracle home. You cannot install 10.2.0.x on any other major release to upgrade the oracle home.

Refer Metalink note : 551141.1

3 comments:

  1. Thanks for providing this information.
    I have not found what I´m looking for but perhaps you have this information.
    What are my options for downgrading an Oracle Enterprise Edition Database 11g release 1 (11.1.0.7.0)?
    Thanks loads!

    ReplyDelete
  2. Downgrade Compatibility Matrix for Downgrading from 11.1.x

    Source Database Downgrade Possible to

    11.1.x -> 10.1.0.5.0 (or higher)
    11.1.x -> 10.2.0.3.0 (or higher)

    For downgrading the database, the database should be upgraded from lower to the higher version, we cannot downgrade a new database which is created in 11g to the lower version. Thanks

    ReplyDelete
    Replies
    1. Hi ,

      We are planning for upgrade our Database from 9.2.0.6.0 to 11.1.X problem is that we have Oracle EBS 11.5.10.2 but we do not have idea to upgrade EBS. only Database need to upgrade so if we upgrade from 9.2.0.6.0 to 11.1.0 is that EBS will support that version ?

      Regards,
      sekar S

      Delete