Create Oracle Database 18c on Windows – Advanced Configuration for the pros

If you are setting up a production system or similar, you will need to go through the advanced configuration. The best option is to choose “Set Up Software Only” in Oracle Universal Installer (OUI) to complete the Oracle software installation, then use Database Configuration Assistant (DBCA) to create a new database.

OUI and DBCA have the advanced configuration. The OUI advanced configuration is not “advanced” enough, DBCA lets you customize the database configuration options – good for an experienced DBA. In my opinion, Oracle should remove the “Advanced Configuration” option from OUI, thus make DBAs to force use DBCA. Let’s see the “Advanced” options difference when using the OUI to create the database vs using DBCA to create the database.