11g
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName bpxtest -sid bpxtest -sysPassword oracle -systemPassword oracle -storageType ASM -diskGroupName DATADG -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -databaseType OLTP -redoLogFileSize 500 -nodeList wqqone2,wqqone1 -initparams sga_target=4096,pga_aggregate_target=3072,db_create_online_log_dest_1=+DATADG,cpu_count=32,resource_manager_plan=default_plan
cat log file "/opt/oracle/cfgtoollogs/dbca/bpxtest/bpxtest.log"
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 15%
DBCA_PROGRESS : 21%
DBCA_PROGRESS : 27%
DBCA_PROGRESS : 30%
Creating and starting Oracle instance
DBCA_PROGRESS : 32%
DBCA_PROGRESS : 36%
DBCA_PROGRESS : 40%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 50%
Creating cluster database views
DBCA_PROGRESS : 52%
DBCA_PROGRESS : 70%
Completing Database Creation
DBCA_PROGRESS : 73%
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 77%
DBCA_PROGRESS : 78%
DBCA_PROGRESS : 79%
DBCA_PROGRESS : 88%
DBCA_PROGRESS : 97%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/bpxtest.
Database Information:
Global Database Name:bpxtest
System Identifier(SID) Prefix:bpxtest
19c CDB
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName bpxtest -sid bpxtest -sysPassword oracle -systemPassword oracle -storageType ASM -diskGroupName DATADG -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -databaseType OLTP -redoLogFileSize 2000 -createAsContainerDatabase -useLocalUndoForPDBs true -numberOfPDBs 2 -pdbName bpxtest -pdbAdminPassword oracle -ignorePreReqs -nodeList qone1,qone2 -RACOneNode -RACOneNodeServiceName bpxtestsrv -initparams sga_target=31641m,pga_aggregate_target=3686m,db_create_online_log_dest_1=+SHOEDG,cpu_count=8,resource_manager_plan=default_plan
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName bpxtest -sid bpxtest -sysPassword oracle -systemPassword oracle -storageType ASM -diskGroupName SSDDG -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -databaseType OLTP -redoLogFileSize 500 -createAsContainerDatabase true -useLocalUndoForPDBs true -numberOfPDBs 2 -pdbName bpxtest -pdbAdminPassword oracle -ignorePreReqs -nodeList qcom1,qcom2 -RACOneNode -RACOneNodeServiceName bpxtestsrv -initparams sga_target=10240m,pga_aggregate_target=10240m,db_create_online_log_dest_1=+SSDDG,cpu_count=8,resource_manager_plan=default_plan