This content has been marked as final. Show 4 replies
Pl post exact versions of "9i" and "11g", along with how big your database is and how much downtime you can afford
It is advisable to upgrade latest oracle version 184.108.40.206
The minimum required 9i version to 220.127.116.11 is 18.104.22.168
In case db version is less than 22.214.171.124, upgrade db to 126.96.36.199 using patch number 4547809
188.8.131.52 patch set is a full release. There is no need to install 184.108.40.206 software
First refer the upgrade path from below document
Oracle Database Upgrade Path Reference List (Doc ID 730365.1)
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 837570.1 : Complete Checklist for Manual Upgrades to 11gR2
Note 870814.1 : Complete checklist to upgrade the database to 11gR2 using DBUA
Adding to what Krishna Sir suggested...
Just a important point to keep upgrade go smooth is to build the source 9i database as 9i in destination....when the source DB is migrated as 9i to destination..just do soem basic health checks and start the 11gr2 upgrade.....
This is best way to do instead of upgrading the DB in source and then migrating to destination.