Category: Oracle Database General

Today my experiment will be upgrading 12.2 (Oct 2021 RU & OJVM), running in the non-CDB mode, to the latest 19c version (currently it is 19.13) in multitenant architecture. The idea of this scenario is to validate and test not only the upgrade process but especially the downgrade strategy. I will keep the COMPATIBLE parameter …

Continue reading

Today is October 11th, #JoelKallmanDay, a day where the Oracle community appreciates all Joel Kallman’s work and effort to improve the huge Oracle community we have. I share a lot the thoughts and feelings of what Daniel has written (https://dohdatabase.com/2021/10/11/i-never-meet-joel-but-i-have-met-his-spirit-joelkallmanday/). Unfortunately, I didn’t have the chance to know him in person, even though I can …

Continue reading

Today my experiment will be upgrading 18c (18.14) to the latest 19c version (currently it is 19.12) in multitenant architecture with 2 PDBs. The idea of this scenario is to validate and test not only the upgrade process but especially the downgrade strategy. Please note I will keep the COMPATIBLE parameter of my target 19c …

Continue reading

Those days, I was testing if it is possible to create a snapshot sparse clone in one database referencing a PDB on a lower release (like 19.11), and later applying datapatch on this cloned PDB to take it to the higher release (like 19.12). Technically I couldn’t see any constraint, given the Snapshot Copy requirements …

Continue reading

Oracle Database 21c (21.3.0) was just released last Friday (14/Aug/2021) for Linux x86_64! If you open the New Features APEX page (https://apex.oracle.com/database-features/) and filter with “21c” and “New features only“, you will see there are about 215 features, which is impressive! However, sometimes you want to understand better the changes performed by a new release …

Continue reading