My Oracle Support Banner

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 later
Oracle Database - Standard Edition - Version to [Release 11.2 to 18]
Oracle Database - Enterprise Edition - Version to [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.


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


Database Administrators, Support 


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
 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
 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

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