11g R2 Upgrade Compatibility Matrix

I get a lot of questions these days about how to upgrade our database to 11g R2 .

One of the questions:

From which version of Oracle database to 11g R2  can we do upgrade directly?

You can upgrade directly to 11g R2 from the versions are as follows;

Source Database	Target 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

You can not upgrade directly to 11g R2 from some versions . You need to do pre-upgrade for 11g R2 as follows:

Source Database	Pre-Upgrade Version	Target Database
7.3.3 or lower version	7.3.4 > 9.2.0.8	11.2.x
8.0.5 or lower version	8.0.6 > 9.2.0.8	11.2.x
8.1.7 or lower version	8.1.7.4 > 10.2.0.4	11.2.x
9.0.1.3 or lower version	9.0.1.4 >10.2.0.4	11.2.x
9.2.0.7 or lower version	9.2.0.8	11.2.x

I will wait for any questions about the upgrade to 11g R2.

Talip Hakan Öztürk

Advertisement