Oracle OpenWorld has evolved into Oracle CloudWorld, and this year it’s been rebranded as Oracle AI World. Alongside product managers, engineers, and database experts, we’re eager to meet you there—to talk real challenges, roadmaps, and solutions around upgrades, migrations, and patching. Bring your toughest questions, share your war stories, and let us know where the…
CPAT New Features (September-2025) – Cloud Premigration Advisor Tool – Version 25.9.0
We’re excited to share that CPAT version 25.9.0 is now available as of September 2025. If you’re not familiar with the tool, you’ll find links at the end of this post to previous articles containing everything you need to know. My favorite new feature in this version is the ability to filter data directly within…
LAOUC Community Tour 2025
Last week, I had the honor of speaking at the northern stop of the LAOUC Community Tour 2025.The last time I participated in these countries was back in 2016—nine years ago—when I was an ACE Director. All the events took place at universities, and it was truly inspiring to see so many students eager to…
CPAT – How to Use a Parameter File
As I mentioned in my previous post about CPAT enhancements, we have extended the existing CPAT functionality to support the use of a parameter file.For example, if you have many databases to analyze, or if you prefer not to list all the options directly on the command line, using a parameter file becomes especially useful….
CPAT New Features (June-2025) – Cloud Premigration Advisor Tool
We’re excited to announce the release of CPAT version 25.6.0, available since June 17, 2025. This update introduces powerful new features designed to enhance your migration experience and reinforces CPAT’s commitment to simplifying and streamlining cloud migrations through comprehensive reporting and flexible execution modes. My favorite addition is the option: This option was created to…
Webinar – Migration to Oracle Autonomous Database – Sample Databases
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 Based on Oracle Sample Schemas: https://github.com/oracle-samples/db-sample-schemas Schemas to install: HR: Human ResourcesCO: Customer OrdersSH: Sales History Scripts to Run: Complex Database Based on Oracle Sample Schemas + manually…
Cloud Premigration Advisor Tool (CPAT) Composer
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…
HCC and Transportable Tablespaces
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…
Moving to Multitenant Architecture using AutoUpgrade – Exadata Database Service on Dedicated Infrastructure (ExaDB-D) or Exadata Database Service on Cloud@Customer (ExaC@C) – NON-CDB to PDB – 19c
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…
ORA-20401: Authorization failed for URI using Auth Token
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:…

