Jul 12

Tranportable Tablespace to lower release? Is it possible?

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

Jul 09

Creating a 19c database with a lower COMPATIBLE parameter

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

Jun 08

Heading to the mothership!

Hello World! I'm extremely happy and excited to announce that, this week, I've just started a new Product Manager role at Oracle! I'm joining Roy Swonger, Mike Dietrich, Daniel Hansen and Bill Beauregard on the Oracle Database Migrations, Upgrades, Patching and Utilities PM team! After working more than 15 years on companies like IBM, Capgemini, …

Continue reading

Apr 30

New DBA_IMMUTABLE_TABLES view, starting on 19.11

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

Apr 30

Dissecting 210420 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. The following patches were analysed: 11.2.0.4 11.2.0.4.210420 DB PSU 11.2.0.4.210420 Exadata Bundle Patch 11.2.0.4.210420 OJVM PSU 12.1.0.2 12.1.0.2.210420 DB PSU 12.1.0.2.210420 Exadata Bundle Patch 12.1.0.2.210420 OJVM PSU 12.2.0.1 12.2.0.1.210420 …

Continue reading