July 2021 archive

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

Those days, I was trying to create a 19c database with a lower COMPATIBLE, so I could have a fallback plan after plugin a PDB from a lower release. However, when trying to create it using DBCA command: dbca -silent -createDatabase \ -gdbName cdb19c \ -templateName General_Purpose.dbc \ -characterSet AL32UTF8 \ -createAsContainerDatabase true \ -numberOfPDBs …

Continue reading