Oracle Tidbits – September 2018 #oratidbit
Oracle Tidbits #oratidbit are little technical nuggets related to Oracle technology. Published daily on Biju’s Twitter / Facebook / Google+.
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.