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 18.104.22.168
The minimum required 9i version to 22.214.171.124 is 126.96.36.199
In case db version is less than 188.8.131.52, upgrade db to 184.108.40.206 using patch number 4547809
220.127.116.11 patch set is a full release. There is no need to install 18.104.22.168 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.