When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 18.104.22.168’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now.… [Read More]
I will start a series of blog posts on how to remove and clean up components from Oracle Database 11.2 – 12.2.
This series of blog posts is not meant to recommend the removal of any options from an Oracle Database. It is not meant to create any sort of negativeness on any of the components or options.… [Read More]
I did blog several times about how to remove an unwanted component from a database. But yesterday I came across this interesting scenario worth a blog post.
How to install a component afterwards in Single-/Multitenant?
I haven’t checked all the MOS Notes but I recognized that some MOS Notes explaining how to (re-)create a component such as JVM are not updated to deal with a Single and/or Multitenant environment as they simply call the scripts from SQL*Plus.… [Read More]
When Oracle Multitenant was launched Roy and I amongst many other people always mentioned that the requirement of having all options in a Container Database (CDB$ROOT), and therefore also for the PDB$SEED with the immediate result that all PDBs provisioned from the PDB$SEED will have all options as well, will hinder customer adoption significantly.… [Read More]
I doubt that many people are using the Oracle features “Rules Manager” and “Expression Filter” as usually people handle these things (such as ensuring that a zip code or a car number plate has a certain format) within the application code and not inside the database. Oracle Beehive for instance uses that just on the side.… [Read More]
Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 22.214.171.124 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.
Example: Component Dependencies in Oracle Database 11.1
As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components.… [Read More]