i am in charge for migrating existing oracle 9i running on windows server 2003 to windows server 2008 with oracle 11g,, could you please advise me on the procedures needed to accomplish that.
Any help would be highly appreciated.
It is advisable to upgrade latest oracle version 126.96.36.199
The minimum required 9i version to 188.8.131.52 is 184.108.40.206
In case db version is less than 220.127.116.11, upgrade db to 18.104.22.168 using patch number 4547809
22.214.171.124 patch set is a full release. There is no need to install 126.96.36.199 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.