Upgrading to 19c Oracle Database on Gen 1 Exadata Cloud at Customer
(Doc ID 2709284.1)
Last updated on NOVEMBER 28, 2022
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/AInformation 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 |