I was very surprised when I saw it was impossible to uncheck options during container database creation proces in DBCA. I am running Oracle Standalone installation.

DBCA gui screen

The reason is that Oracle generally recommends that a CDB should have all options installed in order to avoid any issues with the plug-in of a PDB from another environment.

You can deselect the options only during the manual database creation proces, but you can leverage DBCA to create scripts for you. All you have to do then is just to edit the scripts by removing options you don’t really need and run them at the end.

You can follow these oracle support’s notes:

Customization of Database Options in a Multitenant Setup (Doc ID 1616554.1)
Creating A Container Database (CDB) With A Subset Of Options (Doc ID 2001512.1)

If you encounter a problem with perl library, check this blog note by Patrycjusz Konkol to find a workaround:


Thank you Patrycjusz for sharing!

About the author

maciej tokar
Maciej Tokar

An Oracle technology geek and crazy long distance runner, DBA24 Owner
Senior Oracle DBA / Consultant / [OCP10g, OCP12c, OCE RAC 10g] / [experience: 9y+]
Currently working for Bluegarden (Oslo Norway) by Miratech Group
Past: Mastercard / Trevica by Britenet, Citi International PLC, PZU

View Maciej Tokar's profile on LinkedIn         logoDB4
LinkedIn Auto Publish Powered By : XYZScripts.com