Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
(Doc ID 1503653.1)
Last updated on JUNE 13, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 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
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Purpose
This document is created for use as a guideline and checklist when manually upgrading from Oracle 10gR2 (10.2) , Oracle 11gR1 (11.1) or Oracle 11gR2 (11.2) to Oracle 12c Release 1 (12.1)
Scope
Database Administrators, Support.
Details
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
| Purpose |
| Scope |
| Details |
| Step 1: Upgrade Path for Oracle Database to Oracle 12c Release 1 (12.1) |
| Step 2 : Requirements and recommendations for Source database |
| Step 3 : Check for the integrity of the source database. |
| Step 4 : Pre-Upgrade Steps |
| 4.1 Deprecated CONNECT Role |
| 4.2 Update Access Control Lists and Network Utility Packages |
| 4.3 Dependencies on Network Utility Packages |
| 4.4 Database Links with Passwords from Earlier Releases |
| 4.5 TIMESTAMP WITH TIME ZONE Data Type |
| 4.6 Optimizer Statistics |
| 4.7 Save Database Control Files and Data with the emdwgrd Utility |
| 4.8 Verify That Materialized View Refreshes Have Completed Before Upgrading |
| 4.9 Ensure That No Files Need Media Recovery Before Upgrading |
| 4.10 Ensure That No Files Are in Backup Mode Before Upgrading |
| 4.11 Resolve Outstanding Distributed Transactions Before Upgrading |
| 4.12 Purge the Database Recycle Bin Before Upgrading : |
| 4.13 Synchronize the Standby Database with the Primary Database When Upgrading |
| 4.14 Disable all batch and cron jobs |
| 4.15 Verify SYS and SYSTEM Default tablespace |
| 4.16 Check whether database has any externally authenticated SSL users |
| 4.17 Location of datafiles, redo logs and control files |
| 4.18 Remove Enterprise Manager Database Control repository : |
| 4.19 Run olspreupgrade.sql : |
| 4.20 Drop Oracle 12c Release 1 supplied users and roles ,if exist in the source database |
| 4.21 Review and Remove any unnecessary hidden/underscore parameters |
| 4.22 Check the XDB ACLs has start_date and end_date ACE attributes |
| 4.23 Check the Mitigation patch has been applied on the source Oracle home ,it disables the Java development in the Database which cause error during upgrade |
| 4.24 Changing Or Choosing the Database Character Set |
| 4.25 if upgrading database from 10g |
| 4.26 if upgrading database from 11.2.0.3 |
| Step 5 : Requirements and recommendations for target database |
| Step 6 : Upgrading Database to 12cR1 |
| Step 7: Post Upgrade Steps |
| 7.1 Environment Variables and oratab file |
| 7.2 Initialization parameter file |
| 7.3 Password File |
| 7.4 COMPATIBLE Initialization Parameter |
| 7.5 Change passwords for Oracle-Supplied Accounts. |
| 7.6 Upgrade the Recovery Catalog After Upgrading Oracle Database |
| 7.7 Upgrade the Time Zone File Version After Upgrading Oracle Database |
| 7.8 Upgrade Statistics Tables Created by the DBMS_STATS Package |
| 7.9 Upgrade Externally Authenticated SSL Users |
| 7.10 Install Oracle Text Supplied Knowledge Bases After Upgrading Oracle Database |
| 7.11 Update Your Oracle Application Express Configuration |
| 7.12 Configure Fine-Grained Access to External Network Services |
| 7.13 Enable Oracle Database Vault |
| 7.14 Identify Invalid Objects With the utluiobj Script |
| 7.15 Enable all batch and cron jobs diable at step 4.14 |
| References |