About the Oracle AutoUpgrade Utility
The AutoUpgrade utility automates the upgrade process before, during, and after database upgrades, including post-upgrade checks and configuration migration.
AutoUpgrade is the recommended tool for
upgrades on all supported platforms. When you perform upgrades,
Oracle recommends that you download the most recent version of the
AutoUpgrade utility (autoupgrade.jar) to prepare
for and deploy your upgrade. After you download the binaries for the
new database release and set up new Oracle homes, use AutoUpgrade to
manage upgrades. AutoUpgrade enables you to upgrade multiple
database deployments simultaneously using a single configuration
file customized for each deployment. You can download the latest
AutoUpgrade utility release directly from the Database
Upgrades and Migrations page without logging in to My
Oracle Support: Download the
AutoUpgrade utility
The autoupgrade.jar file exists by default in the Oracle home
(Oracle_home/rdbms/admin).
However, before you use AutoUpgrade, Oracle strongly recommends that you download the
latest AutoUpgrade version. AutoUpgrade is included with each release update (RU), but
the most recent AutoUpgrade version is always available from the Database Upgrades and
Migrations page.
Note:
AutoUpgrade is available for Oracle Database Enterprise Edition and Oracle Database Standard Edition. It is not available for other Oracle Database editions.
Prevent issues with Analyze and Fixup Modes
Before the upgrade, in Analyze mode, the AutoUpgrade utility performs read-only analysis of databases before upgrade, so that it can identify issues that require fixing. You can run the utility during normal database operations. In Fixup Mode, the AutoUpgrade utility detects and identifies both fixes that require manual intervention, and fixes that the AutoUpgrade utility can perform during the upgrade deployment phase.
Upgrade databases with Deploy and Upgrade Modes
In the Deploy phase, AutoUpgrade modifies the databases you specify in your configuration file. In many cases, the AutoUpgrade utility can perform automatic fixes to databases during the upgrade process without requiring manual intervention.
Perform postupgrade tasks with Deploy and Upgrade Postupgrade Checks and Fixes
After an upgrade completes with either Deploy or Upgrade modes, AutoUpgrade performs
postupgrade checks. It provides a process where you can enable your custom scripts
to be run on each of the upgraded databases, in accordance with the configuration
instructions you provide in the AutoUpgrade configuration file. AutoUpgrade can run
automatic postupgrade fixups as part of the postupgrade process. In Deploy mode,
AutoUpgrade also confirms that the upgrade has succeeded, and copies database files
such as sqlnet.ora, tnsname.ora, and
listener.ora from the source home to the target home. After
these actions are complete, the upgraded Oracle Database release is started in the
new Oracle home.
Use our Hands-On Lab on Oracle LiveLabs
Oracle LiveLabs offers a free environment for your testing. Daniel Overby Hansen demonstrates how to set up a lab in Oracle Cloud using LiveLabs to use AutoUpgrade and new Oracle AI Database features.