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 |