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 |