We are hosting a webinar series on migrating to Autonomous Database. You can find more details here. In this series, we will use two databases. Simple Database: is based on Oracle Sample Schemas. https://github.com/oracle-samples/db-sample-schemas Complex Database: is based on Oracle Sample Schemas + Manually created objects: We can download the script here if you want…

Moving Oracle databases to the cloud isn’t always straightforward. Sometimes, it requires careful planning and analysis. That’s where Oracle’s Cloud Premigration Advisor Tool (CPAT) comes in. It helps analyze your database to ensure a smooth transition.But running CPAT can be tricky, especially if you’re not familiar with command-line tools. That’s where Cloud Premigration Advisor Tool…

What happens if you are running a database in a source system that supports HCC (Hybrid Columnar Compression) and need to move the tablespace to another system that does not support HCC using the transportable tablespace method? For a regular Data Pump export/import, you can use transform=table_compression_clause:none. For a physical standby, if you need to…

In case you missed the previous posts: This post covers the migration of a 19c database from a non-CDB to a PDB in the multitenant architecture. When planning an upgrade to 23ai, some customers prefer a two-step approach: first migrating to the multitenant architecture, then upgrading to 23ai. First Step Remember to always download the latest AutoUpgrade…

Hi, During some tests with object storage and SQL*Loader, I came across an issue. As usual, I created the credentials in the database: However, when I attempted to list the files from my bucket, I received the following error: After checking MOS, I found a relevant note discussing the use of an API Key: ‘ORA-20401:…

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…