| |
 |
|
Donald K. Burleson
Oracle Tips |
Oracle MIG utility
11. Run the MIG utility on the Oracle7
database according to the directions for your system. This creates
an Oracle data dictionary and a binary convert file. You will need
1.5 times the amount of space that your current dictionary occupies
as free space in your SYSTEM tablespace area for the new dictionary.
If you aren’t sure you have the space, run MIG in CHECK_ONLY mode
first. You aren’t past the point of no return…yet. This step
obliterates the Oracle7 catalog views, but you can recover them by
doing the following if you need to abandon the migration at this
point:
a. Start up the Oracle7 database in normal mode.
b. Drop the user “migrate.”
c. Rerun CATALOG.SQL.
d. If using parallel server, rerun CATPARR.SQL.
e. If using Symmetric Replication, run CATREP.SQL.
Note
This will be a 7.3.4 database if you abandon at this point.
12. Remove any obsolete initialization parameters from the databases
init<SID>.ora file.
a. Set compatible to 9.0.0.0 or not at all.
b. Change the locations specified by the control_files parameter to
a new location.
This is an
excerpt by Mike Ault’s book “Oracle
Administration & Management”. If you want more current Oracle tips
by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or
Ault’s Oracle Scripts Download.
|
