|
In this Document
|
|
Upgrade Compatibility Matrix for Upgrading to 12.1.x
|
|
|
Upgrade Compatibility Matrix for Upgrading to 11.2.x
|
|
|
Upgrade Compatibility Matrix for Upgrading to 11.1.x
|
|
|
Upgrade Compatibility Matrix for Upgrading to 10.2.x
|
|
|
Upgrade Compatibility Matrix for Upgrading to 10.1.x
|
|
|
Upgrade Compatibility Matrix for Upgrading to 9.2.x
|
|
|
Downgrade Compatibility Matrix for Downgrading
from 12.1.x
|
|
|
Downgrade Compatibility Matrix for Downgrading
from 11.2.x
|
|
|
Downgrade Compatibility Matrix for Downgrading
from 11.1.x
|
|
|
Downgrade Compatibility Matrix for Downgrading from 10.2.x
|
|
|
Downgrade Compatibility Matrix for Downgrading from 10.1.x
|
|
|
Downgrade Compatibility Matrix for Downgrading from
9.2.x
|
APPLIES TO:
Oracle Database - Enterprise Edition - Version 9.2.0.1 and
later
Information in this document applies to any platform.
This note gives a summary of the compatibility
matrix for Oracle Database Server upgrade and downgrade.
This information applies to Oracle Database Server 9.2.0
and higher, and is intended for DBAs and anyone responsible for database
upgrades and downgrades.
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 :
http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#UPGRD12358
(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 :
http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/preup.htm#CEGEIBHC
(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 :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#CEGEIBHC
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 :
http://download.oracle.com/docs/cd/B14117_01/server.101/b10763/preup.htm#CEGEIBHC
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 :
http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migprep.htm#1006863
DOWNGRADE
Downgrade Compatibility
Matrix for Downgrading from 12.1.x
|
Source Database
|
Downgrade Possible to
|
|
12.1.x
|
11.1.0.7.0
|
|
12.1.x
|
11.2.0.2.0 (or higher)
|
For more information, refer to the following link :
http://docs.oracle.com/cd/E16655_01/server.121/e17642/downgrade.htm#i1010267
Note:
You cannot downgrade back to release 10.2.0.5 because the minimum
compatibility setting for Oracle Database 12c is 11.0.
You cannot downgrade a database that was upgraded from Oracle Database
Express Edition.
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.2.0 (or higher)
|
|
11.2.x
|
11.1.0.6.0 (or higher)
|
For more information, refer to the following link :
http://docs.oracle.com/cd/E11882_01/server.112/e23633/downgrade.htm#UPGRD00710
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 :
http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/downgrade.htm#i1010243
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 :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/downgrade.htm#i1010243
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 :
http://download.oracle.com/docs/cd/B14117_01/server.101/b10763/downgrade.htm#i1010243
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 :
http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/downgrad.htm#1008177
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.
|
No comments:
Post a Comment