Oracle recently announced the ability to upgrade your Grid Infrastructure and database on the Oracle Base Database Service from 19c to 23c. You can find more details about this update here and here. However, some people have asked if they can use AutoUpgrade to upgrade the database. The short answer is yes, but there are…

In case you missed the previous posts: In Part 3, I covered the process of performing a traditional upgrade from a 19c PDB to 23ai.In Part 5, I covered the process of performing a traditional upgrade from a 19c PDB to 23ai with the fallback to 19c option when you duplicate the pdb datafiles.Now, I’ll demonstrate how to fallback from 23ai to 19c using catdwgrd.sql / dbdowngrade.This technique has one caveat: It requires the…

In case you missed the previous posts: As mentioned in a previous post, I was working on a workaround to have a 23ai database created with the Compatible parameter set to 19. Having the Compatible set to 19, you will be able to use some of the known techniques to rollback the database upgrade, including:…

In case you missed the previous posts: In Part 3, I covered the process of performing a traditional upgrade from a 19c PDB to 23ai.Now, I’ll demonstrate how to fallback from 23ai to 19c using AutoUpgrade with target_pdb_copy_option.The only caveat with this technique is that it requires additional space to duplicate your PDB. Let’s create…

In case you missed the previous posts: When upgrading Oracle Databases in Oracle Cloud, there are several fallback options to ensure minimal risk and maximum reliability during the upgrade process. These options provide flexibility and safeguards in case the upgrade needs to be reverted or issues arise. Honestly, in 23 years of consulting, I never…

Oracle CPAT serves as the single source of truth for Oracle Database migrations. We are continuously enhancing the tool to incorporate more comprehensive information and provide an even better experience for users. Let me walk you through some of the new features now available in CPAT. Source Cloud Vendor: CPAT will try to identify the…

In case you missed the previous posts: This post will cover the traditional upgrade from a 19c pdb to 23ai.I’ll also rename the PDB to demonstrate this capability. Why should I use AutoUpgrade? It’s worth mentioning that the same steps can be applied if you’re using Oracle Exadata Database Service on Cloud@Customer (ExaCC). What you can do:…

In case you missed the previous post: Part 1 – Refreshable Clone PDBs This post will cover the traditional upgrade from a non-cdb 19c to 23ai pdb.You can also use the same approach to upgrade from 19c pdb to 23ai. Why should I use AutoUpgrade? One thing to point out is you can use the same…

There are many ways to upgrade your database to 23ai. You can use the OCI Console, OCI command-line tools, and AutoUpgrade. Why should I use AutoUpgrade? In this post, I will cover the Refreshable Clone PDBs. One thing to point out is you can use the same steps if you are on Oracle Exadata Database…

CPAT currently includes more than 80 possible checks. Purpose: Identify issues that may interfere with the migration of the source database to the target. Each CPAT Check: The results of Checks are Listed from Most Serious to Least Serious. Action Required means there’s a significant chance that something from the source database will not be…