Wednesday, July 11, 2012

Oracle: Upgrade Compatibility Matrix


For Upgrade 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


Following database version requires 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 Upgrade 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 Upgrade 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 Upgrade 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 Upgrade 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


Note:
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. 


Source:
Database Server Upgrade/Downgrade Compatibility Matrix [ID 551141.1]







1 comment: