Database Server Upgrade/Downgrade Compatibility Matrix.
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.
SCOPE
This information applies to Oracle Database Server 9.2.0 to 11.2.0, and is intended for DBAs and anyone responsible for database upgrades and downgrades.
DETAILS
UPGRADE
Upgrade Compatibility Matrix for Upgrading to 12.1.x
Minimum Version of the database that can be directly upgraded to Oracle Database 12c Release 1
Source Database
| Destination Database |
|---|---|
10.2.0.5
|
12.1.x
|
11.1.0.7
|
12.1.x
|
11.2.0.2 (or higher)
|
12.1.x
|
The following database version will require an indirect upgrade path.
Source Database
|
Upgrade Path
|
Destination Database
|
|---|---|---|
11.2.0.1
|
=> 11.2.0.2 or higher =>
|
12.1.x
|
11.1.0.6
|
=> 11.1.0.7 or 11.2.0.2 or higher =>
|
12.1.x
|
10.2.0.4 (or earlier)
|
=> 10.2.0.5 or later direct upgrade version =>
|
12.1.x
|
10.1.0.5 (or earlier)
|
=> 10.2.0.5 or later direct upgrade version =>
|
12.1.x
|
9.2.0.8 (or earlier)
|
=> 9.2.0.8 --> 11.2.0.2 or higher =>
|
12.1.x
|
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
|
For more information, refer to the following link :
(The above link takes to Oracle Technology Network and requires OTN username and password)
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
|
For more information, refer to the following link :
(The above link takes to Oracle Technology Network and requires OTN username and password)
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
|
For more information, refer to the following link :
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
|
For more information, refer to the following link :
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
|
For more information, refer to the following link :
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)
|
For more information, refer to the following link :
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 more information, refer to the following link :
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)
|
For more information, refer to the following link :
Downgrade Compatibility Matrix for Downgrading from 10.1.x
Source Database
|
Downgrade Possible to
|
|---|---|
10.1.x
|
9.2.0.4.0 (or higher)
|
For more information, refer to the following link :
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)
|
For more information, refer to the following link :
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.
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.
******************************************************************************
Comments
Post a Comment
Oracle DBA Information