Upgrading to 19c Oracle Database on Exadata Database Service (ExaDB)
(Doc ID 2628228.1)
Last updated on OCTOBER 11, 2023
Applies to:
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]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 Database Service on Dedicated Infrastructure (ExaDB-D) and Exadata Database Service on Cloud@Customer (ExaDB-C@C).
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 |
| Phase 1 - 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 - Prepare Target 19c Oracle Home on the Primary and Standby Systems |
| 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 |
| Phase 2 - 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 |
| Phase 3 - Post Upgrade Steps |
| Step 3.1 - Drop Guaranteed Restore Point on Standby and Primary (Optional) |
| 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 |