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…

Use your own templates in DBCA to create databases

Another advice regarding database creation: Use your own templates in DBCA to create databases. This way you can configure not only the options and components to create but also redo log layout, your set of parameters and much more. And it is less error prone than a “create database” script. Use your own template in DBCA Creating your own template in DBCA (Database Configuration Assistant) is quite easy and straight forward. In DBCA select “Manage Templates”: and create a new template: from an existing database template: Choose the “Custom Database” template as blueprint: Choose the components you’d like to have…

Always create databases as CUSTOM databases

I’m giving this advice to customers for many years: When you create a fresh Oracle database ALWAYS create databases as CUSTOM databases. Via template or not doesn’t matter. In the DBCA better use your own and wisely configured template rather than the prebuilt (we used to call them: seed) databases. The seed databases for “Data Warehouse” and “General Purpose or Transaction Processing” have all options and components included. I use them for testing from time to time. As the upgrade duration mainly depends on the number of installed components I’d recommend to choose the components to install, and configure redo…