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 logs, parameters and other things wisely instead of relying on a standard which may not fit for you.
Always create databases as CUSTOM databases
First of all it is important to hit the ADVANCED CONFIGURATION button in the Database Creation Assistant (DBCA). Otherwise you will never get to the screen where you can choose between the options to install into your fresh database.
Then you must choose CUSTOM DATABASE from the template’s section as otherwise you’ll have no control over the process.
Once you followed this guideline you’ll see the screen where you can choose which components to install into your Oracle database:
Ideally build your own templates having exactly the options you would like to have. Use your own template to create a custom database. It takes a bit longer but it’s worth it. Don’t forget to adjust the parameters as well.
Quite often customers complain in my workshops:
“Oracle has removed the screen to select the options to install” or “All options are greyed out” in Oracle 12c.
This is not really correct. First of all you’ll have to create a CUSTOM DATABASE. And second, in Oracle 12.1.0.x in case you wanted to create a Multitenant Container database the screen was greyed out indeed – but there’s a workaround for this case:
Just on the side:
This is not a recommendation to remove or delete options at no reason. But I hear this requirement and the complaints quite often and therefore wanted to clarify how to configure a database with the options you want.
how can I do that in pure script-based installations?
Currently, I am using the dbca in combination with a seed database to provide “naked”, currently still non-multitenant database instances.
do you mean “Oracle SW Installation” or just the creation of a database?
For the latter dbca -silent does the job. You can pass in your precreated template.
For the installation itself the OUI please find information here:
Thanks for the post , is there a way to create the custom template in silent mode if the GUI is not enabled in the environment
Yes, you can – I think this should be documented as well.
if you have time, Could you please point me to the documentation where it mentions how to create a custom template in silent mode especially removing the extra cost options
With 19c, dbca custom database option mandates bigfile tablespace by default.I can not change after selecting custom database.So I choose to select “General Purpose”.
I find a blog post abut this issue: