January 2026 archive

Jan 14

Upgrade a full CDB from Oracle 19c to 26ai between two different servers using AutoUpgrade

In this article, I’ll walk through upgrading an entire 19c CDB by relocating it from Server A to Server B and upgrading it to 26ai using AutoUpgrade. Note: this approach is handy when the target database version or operating system differs from the source. If you want to just move a single PDB instead, which …

Continue reading

Jan 14

Upgrade from Oracle 19c to 26ai between two different servers using PDB unplug/plug with AutoUpgrade

In this article, I’ll walk through upgrading a single 19c PDB by relocating it from Server A to Server B and upgrading it to 26ai using AutoUpgrade. Note: this approach is handy when the target database version or operating system differs from the source, or when a full CDB upgrade is not desirable. Scope and …

Continue reading

Jan 14

Upgrade from Oracle 19c to 26ai between two different servers using PDB unplug/plug with Replay Upgrade

In this article, I’ll walk through upgrading a single 19c PDB by relocating it from Server A to Server B and upgrading it to 26ai using Replay Upgrade. Note: this approach is handy when the target database version or operating system differs from the source, or when a full CDB upgrade is not desirable. If …

Continue reading

Jan 13

ORA-65047: Object is invalid or was compiled with errors in the root.

If you have unplugged your PDB from 19c and plugged it back on 23ai/26ai, and open it, this will automatically trigger the Replay Upgrade. This method of upgrading a database is basically “replaying” all the captured changes that would bring a database from 19c to 23ai/26ai release. However, sometimes objects are changed in the database, …

Continue reading