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 …
May 21
How to bypass ORA-39405 Oracle Data Pump does not support importing error
If you found this blog post, you are probably facing the boring data pump error: “ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version X into a target database with TSTZ version Y.”. In this blog post, I will show how to bypass this error with just some extra …




