Be aware of database options selections for PDBs in DBCA

I did blog about several things-to-know with DBCA (Database Configuration Assistant) in the past. And one issue came up in our internal mailing list the other day. Be aware of database options selections for PDBs in DBCA. Missing one or the other “click” may bring you in trouble later on. I blogged about this already a while ago but this was only part of a larger post: Create Multitenant Databases with DBCA – Things to Know. Be aware of database options selections for PDBs in DBCA When you create a custom container database with DBCA you will see this screen….

Create Multitenant databases with DBCA – Things to Know

When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 12.2.0.1’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. Be careful … Previous posts I did blog several times about the DBCA already: Always create databases as customer databases Use your own templates in DBCA when you create databases Does DBCA execute datapatch in Oracle Database 12.2? Create Container databases with less options And there…

Remove and Clean Up Components from Oracle Database 11.2 – 12.2

I will start a series of blog posts on how to remove and clean up components from Oracle Database 11.2 – 12.2. Precaution 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. It’s is only meant to give you some advice and guideline in the case you’ll need to remove something. The OUI (Oracle Universal Installer) installed everything on disk – and there’s a very good reason to do this. The purpose of…

What or who is JOX? And what happens if …

Are you worried because of the title of this blog post? Don’t worry … it will be about the Oracle database and not about miraculous additives. Months back I wrote about how to remove options from the Oracle database’s kernel by either using chopt or linking options off: Removing Options from the Oracle Database kernel in 12c Recently a very interesting case was logged in relation to a bug: A customer had linked off the JOX option from the database kernel. . What is JOX?  Well, do a quick search for “JOX” in the Oracle Documentation and you’ll get “zero results” (or you…

Removing Options from the Oracle Database kernel in 12c

Sometimes people have the desire to remove options from the database kernel (i.e. from the oracle executable). It’s a matter of fact that by default you’ll get plenty of things linked into your kernel in Oracle Database 12c. In case you’d like to remove things the chopt utility does still exist in Oracle Database 12c – but you may recognize a difference between Oracle 11.2 and Oracle 12.1. Anyhow, ideally you’ll do these changes before you create a database directly after the installation has been completed. See the documentation for Post Installation Tasks first: Oracle 11.2 – chopt utility options:…

Rules Manager and Expression Filter getting removed

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. Anyway, just learned today that Rules Manager and Expression Filter components will get removed once our next database release most likely called Oracle Database 12c will get released. So before upgrading to Oracle Database 12c you can remove EXF and RUL components (SELECT COMP_ID…

Database Registry: Component Dependencies

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 11.2.0.2 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. If you’ll query DBA_REGISTRY (or the underlying REGISTRY$) you’ll spot all the installed (and usually configured) database components. And the more…