Checklists for Oracle Database Upgrade

Use checklists to plan and carry out Oracle Database upgrades.

Oracle recommends that you use checklists as part of your upgrade planning and implementation process. Using checklists can help you to use available upgrade utilities, and can help you to ensure you carry out a successful upgrade.

Source Server Preparation Upgrade Checklist

To obtain a checklist of tasks you must complete before upgrade, run the Pre-Upgrade Information Tool (preupgrade.jar).

Before starting your upgrade, make sure that you have a new release Oracle Database installed and configured that you can use as the target for your upgrade. When your target Oracle Database is prepared, then run the Pre-Upgrade Information Tool (preupgrade.jar), using the instructions that you can find in this guide.

Oracle requires that you run the Pre-Upgrade Information Tool before you upgrade Oracle Database. The tool scripts can resolve many issues, and the tool can identify issues for you to address before you start your upgrade.

Tip:

Consider reviewing Oracle’s upgrade blog for tips and suggestions that can assist you with your upgrade preparations.

Target Server Post-Upgrade Checklist

After you configure your environment and install the new release software, complete these checks on the upgraded database in the higher-versioned Oracle Home.

Note:

You must have the upgrade completed before using these scripts. To review the scripts, you must at least have completed a software-only image installation of the new release Oracle Database software.

Table 2-1 Target Server Post-Upgrade Checklist

Task Description

Run postinstallation SQL scripts

  • $ORACLE_HOME/rdbms/admin/utlrp.sql

  • $ORACLE_HOME/rdbms/admin/utlu122s.sql

  • $ORACLE_BASE/cfgtoollogs/SID/preupgrade/postupgrade_fixups.sql

The postupgrade_fixups.sql script is placed in the directory you specify. The path described here in $ORACLE_BASE is correct if you accepted the default output directory when you started the preupgrade script.

Review upgrade logs and trace files

  • $ORACLE_BASE/cfgtoollogs/DBUA/upgradeTimestamp

    (Look under $ORACLE_HOME if $ORACLE_BASE is not set). Also, folders with the system identifier (SID) of individual database are in this timestamp folder. The SID folders contain files for individual databases for the preupgrade and upgrade process.

    alert_SID.log

Create Oracle Database system files

Create an SPFILE from the PFILE

Back up the database

To ensure that you can recover from data loss if the need arises, back up your database after completing your upgrade.