This content has been marked as final. Show 4 replies
It is advisable to upgrade latest oracle version 22.214.171.124
The minimum required 9i version to 126.96.36.199 is 188.8.131.52
In case db version is less than 184.108.40.206, upgrade db to 220.127.116.11 using patch number 4547809
18.104.22.168 patch set is a full release. There is no need to install 22.214.171.124 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.