DBCA Silent Mode 19c

create 19c database

for file system 
 -storageType FS  
 -datafileDestination /u01/db_files 

select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

export Oracle home and sid 

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ${ORACLE_SID} -sid ${ORACLE_SID}  -characterSet AL32UTF8  -sysPassword xxxxx  -systemPassword xxxxx  -createAsContainerDatabase false  -totalMemory 6000  -storageType ASM  -datafileDestination '+DATA' -emConfiguration NONE  -ignorePreReqs -sampleSchema true

for RAC

 ./dbca -silent -nodelist ora1,ora2 -createDatabase -templateName General_Purpose.dbc -gdbName ORCL -sid ORCL -SysPassword test123 -SystemPassword test123 -emConfiguration none -redoLogFileSize 1024 -recoveryAreaDestination '+DATA1' -storageType ASM -asmsnmpPassword welcome1 -diskGroupName '+DATA1' -recoveryGroupName '+DATA1' -listeners LISTENER -registerWithDirService false -characterSet WE8ISO8859P9 -nationalCharacterSet AL16UTF16 -databaseType MULTIPURPOSE -automaticMemoryManagement true -totalMemory 60480 -sampleSchema true &


====

another db creation 




https://anuj-singh.blogspot.com/search?q=General_Purpose.dbc

 which dbca
/u01/app/oracle/product/19.0.0/dbhome1/bin/dbca


[oracle@oragrid ~]$ ls -ltr /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
-rw-r----- 1 oracle oinstall 4768 Apr 17  2019 /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc
[oracle@oragrid ~]$





/u01/app/oracle/product/19.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
-gdbName v14mpc \
-sid v14mpc \
-sysPassword sys \
-systemPassword sys \
-createAsContainerDatabase true \
-numberofPDBs 1 \
-pdbname v14mpcpdb \
-pdbAdminUserName pdba \
-pdbAdminPassword password \
-emConfiguration LOCAL \
-dbsnmpPassword dbsnmp123 \
-storageType ASM \
-datafiledestination +DATA \
-recoveryAreaDestination +DATA \
-databaseType MULTIPURPOSE \
-responseFile NO_VALUE \
-totalmemory 4096 \
-characterset AL32UTF8 \
-nationalcharacterset AL16UTF16 \
-automaticmemorymanagement FALSE \
-templateName /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc


[oracle@oragrid ~]$ /u01/app/oracle/product/19.0.0/dbhome1/bin/dbca -CreateDatabase -silent \
> -gdbName v14mpc \
> -sid v14mpc \
> -sysPassword sys \
> -systemPassword sys \
> -createAsContainerDatabase true \
> -numberofPDBs 1 \
> -pdbname v14mpcpdb \
> -pdbAdminUserName pdba \
> -pdbAdminPassword password \
> -emConfiguration LOCAL \
> -dbsnmpPassword dbsnmp123 \
> -storageType ASM \
> -datafiledestination +DATA \
> -recoveryAreaDestination +DATA \
> -databaseType MULTIPURPOSE \
> -responseFile NO_VALUE \
> -totalmemory 4096 \
> -characterset AL32UTF8 \
> -nationalcharacterset AL16UTF16 \
> -automaticmemorymanagement FALSE \
> -templateName /u01/app/oracle/product/19.0.0/dbhome1/assistants/dbca/templates/General_Purpose.dbc



[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
   CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
7% complete
Registering database with Oracle Restart
11% complete
Copying database files
33% complete
Creating and starting Oracle instance
35% complete
38% complete
42% complete
45% complete
48% complete
Completing Database Creation


53% complete
55% complete
56% complete
Creating Pluggable Databases
60% complete
78% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/v14mpc.
Database Information:
Global Database Name:v14mpc
System Identifier(SID):v14mpc
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/v14mpc/v14mpc0.log" for further details.