Oracle Database - Create DB DBCA silent mode (18c)

If you have followed my previous blog on DB Creation on 18c, you now should be aware of creating a database 18c on Linux with the tweak to start the instance. 

Now how do you speed it up and use dbca.

Below is a simple dbca command which can be used for the same. 
This will create your db instance and you are ready to work on it. 

The key parameter again is exadata features which I have higlighted in bold green


dbca -silent -createDatabase -gdbName ORCL -sid ORCL -responseFile NO_VALUE \
-templateName /u01/app/oracle/product/181/db1/assistants/dbca/templates/General_Purpose.dbc  \
-dbOptions JSERVER:false,DV:false,SPATIAL:false,CWMLITE:false \
-redoLogFileSize 150 -automaticMemoryManagement false \
-characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -databaseConfigType SI   \
-datafileDestination '{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/' \
-enableArchive false  -sysPassword Oracle123 -systemPassword Oracle123  \
-variables 'DB_UNIQUE_NAME=ORCL_PR,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=ORCL,ORACLE_HOME=/u01/app/oracle/product/181/db1,SID=ORCL' \
-initParams 'undo_tablespace=UNDOTBS1,processes=640,db_recovery_file_dest_size=8192MB,nls_language=AMERICAN,pga_aggregate_target=512MB,sga_target=2048MB,dispatchers=(PROTOCOL=TCP) (SERVICE=ORCLXDB),db_recovery_file_dest={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME},db_block_size=8192BYTES,diagnostic_dest={ORACLE_BASE},audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,nls_territory=AMERICA,control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl"),db_name=ORCL,audit_trail=db,remote_login_passwordfile=EXCLUSIVE,use_large_pages=ONLY,db_unique_name=ORCL_PR,open_cursors=300,_exadata_feature_on=true'