Oracle 18c - Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 18c
(Doc ID 2418045.1)
Last updated on AUGUST 14, 2020
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Standard Edition - Version 11.2.0.3 to 18.1.0.0.0 [Release 11.2 to 18]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 18.1.0.0.0 [Release 11.2 to 18]
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
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 11gR2 (11.2) or Oracle 12c Release 1 (12.1) or Oracle 12c Release 2 (12.2) to Oracle 18c Release
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 18.1 Oracle database |
| Minimum version of the database that can be directly upgraded to Oracle 18.1 |
| Intermediate upgrades needs to be carried for following releases |
| Step 2: Requirements and recommendations for source database |
| Step3: Requirements and recommendations for target ORACLE_HOME |
| Step 4: Pre-upgrade checks |
| Clean up database |
| Check materialized views |
| Copying Transparent Encryption Oracle Wallets |
| Understanding Password Case Sensitivity |
| Running Upgrades with Read-Only Tablespaces |
| Preparing the New Oracle Home for Upgrading |
| Prerequisites for Preparing Oracle Home on Windows |
| Databases That Use Oracle Label Security and Oracle Database Vault |
| Backing Up Oracle Database for Upgrading |
| Manually remove DB control with emremove.sql |
| Ensure no files are in Back up mode before starting the upgrade |
| Purge Recycle bin |
| Performance |
| Checking Time zone settings |
| About Upgrading Oracle OLAP Data Security Policies |
| Step 5: Preupgrade step |
| Preupgrade fixup script |
| Dependencies on Network Utility Packages |
| Check Time zone version |
| Step 6: Upgrade Database to 18c |
| Step 7: Post-upgrade |
| Setting Environment variables on Linux and Unix |
| Update oratab entries |
| Post-upgrade fixup script |
| Recovery Catalog Upgrade |
| Upgrade the Time Zone File Version After Upgrading Oracle Database |
| Upgrading Statistics Tables |
| References |