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|
|18.104.22.168 or higher||11.2.x|
|10.1.0.5 or higher||11.2.x|
|10.2.0.2 or higher||11.2.x|
|22.214.171.124 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 > 126.96.36.199||11.2.x|
|8.0.5 or lower version||8.0.6 > 188.8.131.52||11.2.x|
|8.1.7 or lower version||184.108.40.206 > 10.2.0.4||11.2.x|
|220.127.116.11 or lower version||18.104.22.168 >10.2.0.4||11.2.x|
|22.214.171.124 or lower version||126.96.36.199||11.2.x|
I will wait for any questions about the upgrade to 11g R2.
Talip Hakan Öztürk