Aug 04

Dissecting Oracle Database 19.10.3 vs 19.10.2

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 why it is 19.10.3 and not 19.10.2, check this article. Please leave in the comments …

Continue reading

Aug 04

Dissecting Oracle Database 19.12.0 vs 19.11.0

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

Jul 23

19.10.3 ? How is it possible to have a third RUR over a RU ?

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

Jul 23

ORA-00600 ktfbhget:objdchk_kcbgcur_3 when trying to plug PDB back to 12.1.0.2

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

Jul 13

Local Undo and Compatible 12.1.0.2 ?

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