Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




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.




Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.