My Oracle Support Banner

Complete Checklist for Manual Upgrades to 10gR2 (Doc ID 316889.1)

Last updated on SEPTEMBER 02, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 10.2]
Oracle Database - Standard Edition - Version to [Release 8.1.7 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


This document is created for use as a guideline and checklist when manually upgrading Oracle 8i, Oracle 9i or Oracle 10gR1 to Oracle 10gR2 on a single server.

If the database instance is being moved from one server to another as part of the upgrade process, additional steps for that move may need to be performed which are not included in this checklist.

This document is divided into three major sections.
-- Preparing to Upgrade
-- Upgrading to the New Oracle Database 10g Release 2
-- After Upgrading a Database

Please read the whole article before starting to perform an upgrade.

Additional Note:

These instructions are incomplete for taking an 8i OPS cluster into a 10gR2 RAC cluster due to the differences in OPS vs RAC.


Database administrators


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Steps for Upgrading the Database to 10g Release 2
 Preparing to Upgrade
 Useful Hints
 Appendix A: Initialization Parameters Obsolete in 10g
 Appendix B: Initialization Parameters Deprecated in 10g
 Known issues
 Community Discussions
 Revision History

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.