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 …
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 …
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, …
Aug 01
Online COMPATIBLE raise starting with 23.9
Oracle Database 23ai is introducing many new features over the Release Updates. Most of those changes can be tracked via https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/release_updates.html . However, not all of them are documented, and sometimes, I find interesting stuff on https://oradiff.oracle.com, like this one: As we can see, the COMPATIBLE parameter is now instance modifiable and ISSYS_MODIFIABLE has changed …
Nov 07
Downloading Oracle Patches using CLI with AutoUpgrade Patching
Since October 2024, the Oracle Database Upgrade team has made many improvements in AutoUpgrade Patching. The most expressive one is adding the capability for it to connect on MOS, download patches automatically, create a new Oracle home with all those patches applied, and finally move the database from the old Oracle home to a new …




