Category: Oracle Database General

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

If you follow my quarterly dissecting database patches series, you will note that on 19.11 (April-2021 CPU) oracle introduced a new USER/ALL/DBA_IMMUTABLE_TABLES view. This seems to be related with the new blockchain feature, but on 19.10 (the previous RU), oracle have already created USER/ALL/DBA_BLOCKCHAIN_TABLES. In this post I will investigate the differences among them. So, …

Continue reading