| |
 |
|
Donald K. Burleson
Oracle Tips |
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
Figure 1.26).
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
to update.
Figure 1.27 ODMA main screen.
In the next screen, you have the opportunity to change
initialization files, database password entry, and Oracle home
location (see
Figure 1.28). Following this screen, the Assistant
retrieves database information from your system (see
Figure 1.29).
Once the database information is retrieved, the options screen is
displayed (see
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
in
Figure 1.32.
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
in
Figure 1.33.
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.
|
