Well, to start with, the Server is Huge and Powerful. That's what I would say as a summarized version. We carried out a simulated migration on the new server, and it was well-planned, quite simple and successful.
- Oracle 10g R2 base release installation was done first,
- Oracle 10.2.0.4 patchset was applied to the 10gR2 base home,
- A new Database was created with optimum configurations (as of the 9iR2 production database),
- Fresh export full dump of the 9iR2 production database was taken (created using 9i exp utility),
- The data migration/import was carried out using (10g imp utility) into the new database,
- Data migration/import had some invalid objects, which were fixed (most of them pertaining to invalid synonyms),
- Oracle Enterprise Manager Database Control had some configuration issues related to SSL, which were fixed.
Oracle Enterprise Manager Database Control is awesome. It gives amazing "on the finger tip" information availability. But, kind of miss those script runs at times; probably because I am more comfortable at command prompt.
A complete checklist has been provided to the Developers for an in-depth application testing on the new server, so as to avoid any unforeseen scenarios on the day of the migration.
I will keep you posted on when and how we will be planning the server migration. For now, the entire team is carrying out the system/application testing.
