Category: Oracle Database General

Oracle Database General

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

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 …

Continue reading

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 …

Continue reading

Apr 04

Evento Oracle OCW em SP – 2024

Hoje, 04 de Abril de 2024, ocorreu o Oracle OCW em São Paulo, no World Trade Center. O evento foi bem legal. Uma versão reduzida do OCW anual que ocorre em Las Vegas, dada a quantidade menor de pessoas. Minha sessão foi sobre “Por que você deveria modernizar o seu BD?” [LRN1010]. O banco de …

Continue reading