My Oracle Support Banner

Upgrading to 19c Oracle Database on Exadata Cloud Service (Doc ID 2628228.1)

Last updated on OCTOBER 02, 2020

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Information in this document applies to any platform.

Goal

This document provides step-by-step instructions for upgrading Oracle Database, from Oracle Database 11.2.0.4 and higher to Oracle Database Release 19c on Exadata Cloud Service.

Solution

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
Goal
Solution
 Overview
 Database 19c Upgrade Prerequisites
 Step 1.1 - Validate Upgrade Steps on Test
 Step 1.2 - Golden Gate Supported Versions
 Step 1.3 - Oracle Application Express(APEX) Supported Versions
 Step 1.4 - Validate Minimum Software Requirements
 Step  1.4.1 - Required Exadata Database Server Software version
 Step 1.4.2 - Required Grid Infrastructure version
 Step 1.5 - Install the latest Cloud Tooling
 Step 1.6 - Database Prerequisites
 Step 1.7 - Create Target Database 19c ORACLE HOME
 Step 1.7.1 - Create an empty 19c ORACLE HOME
 Step 1.7.2 - Apply any one-off or merge patches
 Step 1.7.3 - Validate the new 19c ORACLE HOME version
 Step 1.8 - Run Pre-Checks Information Tool on Primary DB
 Step 1.8.1 - Run Pre-Checks on Primary DB 
 Step 1.8.2 - Review Pre-Upgrade information tool output
 Step 1.8.3 - Handle obsolete and underscore parameters
 Step 1.8.4 - Run Pre-Checks on Standby DB (Only Data Guard)
 Step 1.9 - Check standby LAG (Only Data Guard)
 Step 1.10 - Run latest exachk and Address Critical Alerts
 Step 1.11 - Copy Customer Created Listeners
 Upgrade the Database to 19c
 Step 2.1 - Check the Standby LAG (Only Data Guard) 
 Step 2.2 - Move the Standby Database to the 19c RDBMS Home (Only Data Guard)
 Step 2.3 - Upgrade the Primary Database
 Step 2.4 - Start Customer Created Listeners
 Post Upgrade Steps
 Step 3.1 - Drop Guaranteed Restore Point on Standby and Primary
 Step 3.2 - Run Exachk
 Step 3.3 - Optionally set the COMPATIBLE Parameter
 Troubleshooting
 Downgrading Oracle Database to an Earlier Release
 Appendix
 Move the Unregistered Standby Database to the 19c RDBMS Home (Only Data Guard)
  Revision History
References

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