My Oracle Support Banner

Upgrading to 19c Oracle Database on Gen 1 Exadata Cloud at Customer (Doc ID 2709284.1)

Last updated on MARCH 19, 2021

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to 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 Gen 1 Exadata Cloud at Customer.

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 
 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 - Create a Guaranteed Restore Point on the Standby (Only Data Guard)
 Step 2.2 - Check the Standby LAG (Only Data Guard) 
 Step 2.3 - Move the Standby Database to the 19c RDBMS Home (Only Data Guard)
 Step 2.3.1 - For Registered Standby Databases
 Step 2.3.2 - For Unregistered Standby Databases
 Step 2.4 - Upgrade the Primary Database
 Step 2.5 - Start Customer Created Listeners
 Step 2.6 - Check the Standby LAG (Only Data Guard) 
 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
 Step 3.4 - Update DB Version Information in PSM via REST API
 Step 3.5 - Purge the Original DB Home After a Successful Upgrade
 Troubleshooting
 Downgrading Oracle Database to an Earlier Release
References

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