7 Postupgrade Tasks for Oracle Database
After you upgrade Oracle Database, complete required postupgrade tasks, and consider recommendations for the new release.
Note:
If you use AutoUpgrade to complete the upgrade, then many of these tasks may be done automatically as part of the upgrade.- Check the Upgrade With Post-Upgrade Status Tool
Review the upgrade spool log file and use the Post-Upgrade Status Tool,utlusts.sql
. - How to Show the Current State of the Oracle Data Dictionary
To check the state of the Oracle Data Dictionary for diagnosing upgrades and migrations, use one of three methods. - Required Tasks to Complete After Upgrading Oracle Database
Review and complete these required tasks that are specified for your environment after you complete your upgrade. - Recommended and Best Practices to Complete After Upgrading Oracle Database
Oracle recommends that you complete these good practices guidelines for updating Oracle Database. Except where noted, these practices are recommended for all types of upgrades. - Recommended Tasks After Upgrading an Oracle RAC Database
Decide if you want to configure clients to use SCAN or node listeners for connections. - Recommended Tasks After Upgrading Oracle ASM
After you have upgraded Oracle ASM, Oracle recommends that you perform tasks such as resetting the Oracle ASM passwords and configuring disk groups. - Migrating Oracle Database Express Edition to Oracle Database Free
You cannot directly upgrade previous releases of Oracle Database Express Edition (XE), but you can export data from earlier Oracle Database XE releases to Oracle Database 23ai Free - Tasks to Complete After Testing Your Oracle Database Upgrade
After you complete your upgrade testing, you may want to complete additional tasks, depending on your system.