Category: Oracle Database General

Starting this patch cycle (July-2021), I will write quarterly blog posts giving much more details about the internal changes performed by patches in Oracle internal dictionary views and files. In the past, those changes included only code changes. To understand better the new features included, check this official page. Please leave in the comments if …

Continue reading

Today, I was downloading all the patches released on the latest July-2021 CPU cycle, to check the differences and new features, as I quarterly do. One of the things that surprised me, when I opened the Download Assitant MOS Note to get the 19c RURs: And when opening this entry: Shouldn't it be "19.10.2" ?! …

Continue reading

Those days, when trying to connect a 19c PDB back to a 12.1.0.2 CDB, I was receiving a strange ORA-00600 error: SQL> alter pluggable database PDB12C open; alter pluggable database PDB12C open * ERROR at line 1: ORA-00600: internal error code, arguments: [ktfbhget:objdchk_kcbgcur_3], [4294967295], [13], [0], [0], [0], [], [], [], [], [], [] In …

Continue reading

Imagine you want to migrate your Oracle Database from 12.1.0.2 to 19c. To allow a fallback plan, you most probably will create your 19c database with the same COMPATIBLE as the source database, 12.1.0.2.0. Talking now about Local Undo, it was first released on 12.2. So what if I try to create my 19c with …

Continue reading

Today my experiment will be trying to run a transportable tablespace to a lower release. The reason for this experiment is to evaluate a possible fast fallback plan in case I want to roll back a migration+upgrade (eg: 12c NON-CDB to 19c PDB). The first important thing to note is that the non-cdb to pdb …

Continue reading