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
). - 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.
Parent topic: Preparing to Upgrade Oracle Database
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 |
The |
Review upgrade logs and trace files |
|
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. |
Parent topic: Checklists for Oracle Database Upgrade