9i DB to 10g DB Export/Import Migration Cookbook
Below is a list of procedures I've compiled for migrating from 9i to 10g using imp/exp.
Feel free to add (or remove) anything on the list you believe is or isn't necessary and, if you have time, the reasons why you would or would not do something.
The migration will take place in several weeks and, as an aspiring DBA, I need all the help I can get. Your assistance would be greatly appreciated.
Thx
I'm currently reviewing the 10g R2 Upgrade Guide and DOC ID 132904.1.
---------------------------------------
To obtain the cleanest possible export, run INVALID.SQL script to check for invalid objects on 9i DB (source server) and run VALIDATE.SQL (UTLRP.SQL?)to recompile any invalid objects
Export the 9i DB
Shutdown the 9i DB to stop users from establishing a session
Copy the Oracle 9i EXPORT.DMP and IMPORT.PAR files to the 10g DB (destination server)
Ensure tablespaces have been created/configured in the 10g DB to coincide with the 9i DB
Take the 10g DB out of ARCHIVELOG mode
Import the 9i DB into the 10G DB
Check import logs for errors
Reset passwords for system (and other) 10g accounts back to the original 9i DB accounts
Make sure users are pointing to proper tablespaces
Run INVALID.SQL script on 10g DB again to check for invalid objects and run VALIDATE.SQL (UTLRP.SQL?) to recompile any invalid objects
Recompile all PL/SQL modules that may be in an INVALID state, including packages, and types on 10G DB using UTLRP.SQL (is this same as above?)
Check the local applications and DB links on the 10g DB
Ensure MS Access apps are able to connect and work
Give the Oracle Devs the OK to change the hardcoded connect string from the old to the new
Give the MS Access Devs the OK to change the ODBC Connect String from the old to the new
Deploy the new Oracle registry key LOCAL default parameter key connect string to all WS
Put the 10g DB back into ARCHIVELOG mode
Verify the nightly backup client is configured properly
Monitor the alert log and dump directories for possible issues and
---------------------------------------