4 Post-Upgrade Tasks for Oracle Database

After you upgrade Oracle Database, complete required post-upgrade tasks, and consider recommendations for the new release.

Topics:

• Check the Upgrade With Post-Upgrade Status Tool
  Review the upgrade spool log file and use the Post-Upgrade Status Tool, utlu122s.sql.
• How to Show the Current State of the Oracle Data Dictionary
  Use one of three methods to check the state of the Oracle Data Dictionary for diagnosing upgrades and migrations.
• 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. These practices are recommended for both manual and DBUA 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.
• Recommended Tasks After Upgrading Oracle Database Express Edition
  Use DBCA or run manual scripts to install additional components into Oracle Database.
• Tasks to Complete Only After Manually Upgrading Oracle Database
  After you complete your upgrade, you must perform the tasks described here if you upgrade your database manually instead of using DBUA.
• Patch Set Updates and Requirements for Upgrading Oracle Database
  Before starting upgrades, update your new release Oracle Database to the latest Oracle bundle patch, patch set update (BP or PSU), or Release Update (Update), or Release Update Revision (Revision).

Patch Set Updates and Requirements for Upgrading Oracle Database

Before starting upgrades, update your new release Oracle Database to the latest Oracle bundle patch, patch set update (BP or PSU), or Release Update (Update), or Release Update Revision (Revision).

The software for new Oracle Database releases contains a full release that includes all the latest patches and updates for Oracle Database at the time of the release.

Before you start an upgrade or downgrade process, Oracle strongly recommends that you update both your earlier release and your new release Oracle Database. For Oracle Database 12c or earlier releases, update to the latest Oracle bundle patch, or patch set update (BP or PSU). For Oracle Database 12c release 2 (12.2), Oracle Database 18c, or later releases, update to the latest quarterly Release Update (Update) or Release Update Revision (Revision).

My Oracle Support provides detailed notes about how you can obtain the latest patches, as well as tools for lifecycle management and automated patching. For example:

• My Oracle Support note 854428.1 contains information about patch sets and updates.

• My Oracle Support note 730365.1 contains an upgrade reference list for most available Oracle Database releases, including download information, patch numbers, and links to other notes.

• My Oracle Support note 2414935.1 contains lists of one-off patches for upgrades, downgrades, and coexistence with previous releases.

• My Oracle Support note 1227443.1 contains a list of Oracle Database PSU/BP/Update/Revision known issues. This note provides information about all known issues notes for Oracle Database, Oracle Grid Infrastructure, and the Oracle JavaVM Component (OJVM).

• My Oracle Support note 2118136.2 contains a download assistant to help you select the updates, revisions, Patch Set Updates (PSU), SPU (CPU), Bundle Patches, Patchsets, and Base Releases that you need for your environment. Oracle highly recommends that you start here.