Donald K. Burleson
Oracle MIG utility
Once all the prerequisites are met,
you can run ODMA simply by CD'ing to the Oracle bin directory and
typing “ODMA” at the command line (see
The screen in Figure 1.27 will be displayed once ODMA configures.
Most problems with ODMA come from improper settings for PATH,
CLASSPATH, and LD_LIBRARY_PATH. If you have multiple databases, each
will be shown on the main screen and you can select the one you wish
Figure 1.27 ODMA main screen.
In the next screen, you have the opportunity to change
initialization files, database password entry, and Oracle home
Figure 1.28). Following this screen, the Assistant
retrieves database information from your system (see
Once the database information is retrieved, the options screen is
Figure 1.30). The allowed options consist only of the
capability to move datafiles and to recompile PL/SQL packages
(Figures 1.31 and 1.32). Note that you are limited to only one
location to which to move the datafiles.
Once you have selected the two options, the conversion is ready to
begin. The Assistant reminds you to back up your database, as shown
Once you to either back up your database or skip this screen, you
are given a summary screen and one more chance to back out as shown
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.
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.