Workshop
digicode: OPATCH
Oracle Database Patching and Upgrades
Course facts
Download as PDF- Understanding the fundamentals of Oracle patching and upgrades, as well as the differences between patch types (RU, RUR, MRP, One-Off)
- Using the OPatch utility and the Oracle AutoUpgrade tool to perform patching and upgrade processes
- Comparing and implementing in-place and out-of-place patching strategies in various scenarios
- Performing database upgrades from Oracle 12c/18c to 19c and from 19c to 23ai
- Analyzing the migration from Non-CDB to CDB and converting Non-CDB databases to Pluggable databases
The process of patching and upgrading Oracle databases is constantly evolving. Since Oracle 19c became available, there have been several changes to the patches provided. The scope of the patches also changes frequently. Starting with Oracle 19.10, there are separate, additional DatePump patches. At the same time, the Oracle AutoUpgrade Tool is increasingly being adapted as a patching tool and is intended to replace DBUA starting with Oracle 23ai.
Since non-CDB databases are no longer supported as of Oracle 21c at the latest, the conversion from non-CDB to CDB is covered in detail.
The workshop is based on Oracle 19c and Oracle 23ai/26ai. The upgrade from Oracle 12c/18c to Oracle 19c, and from Oracle 19c to Oracle 23ai, is also covered.
Topics:
- Oracle Patching and Upgrade Basics
- RU, RUR, MRPs, OneOff
- Datapump Bundle Patches
- OPatch Utility
- Why to avoid unnecessary options
- Oracle AutoUpgrade
- Automated installation of a DB Home
- Creating Oracle databases
- In-place patching
- Out-of-place patching
- Upgrading from Oracle 19c to Oracle 23ai
- Converting non-CDB to pluggable databases
- Patching and upgrading using UNPLUG/PLUG
- Advanced topics and troubleshooting
Oracle Database Administrators
Experience as an SQL and Oracle administrator, as well as completion of the following course, is required.
Course environment (and Oracle licensing requirements)
This workshop requires an Oracle Enterprise database and may require additional licenses, which you, as a customer, must provide or own for your environment. If you have any questions about the required licenses, please contact us. Further information about the course environment and Oracle licensing can be found here.
SQL*Plus is used as the front end. While it is possible to use Oracle SQL*Developer or one of the many third-party tools (Toad, SolarWinds, etc.) in some cases, this will result in different exercise procedures.