2 - Database Creation Assistant (DBCA)

• Création Silent sans fichier de réponse

MULTITENANT

 dbca -silent -createDatabase \
 -templateName General_Purpose.dbc \
 -gdbname cdb1 -sid cdb1 -responseFile NO_VALUE \
 -initParams db_unique_name=CDB1 \
 -characterSet AL32UTF8 \
 -sysPassword OraPasswd1 \
 -systemPassword OraPasswd1 \
 -createAsContainerDatabase true \
 -numberOfPDBs 1 \
 -pdbName pdb1 \
 -pdbAdminPassword OraPasswd1 \
 -databaseType MULTIPURPOSE \
 -memoryMgmtType auto_sga \
 -totalMemory 1536 \
 -storageType FS \
 -datafileDestination "/u02/oradata/" \
 -redoLogFileSize 50 \
 -useOMF true \
 -emConfiguration NONE \
 -ignorePreReqs

NON MULTITENANT

  dbca -silent -createDatabase \
 -templateName General_Purpose.dbc \
 -gdbname DB1 -sid db1 -responseFile NO_VALUE \
 -initParams db_unique_name=DB1 \
 -characterSet AL32UTF8 \
 -sysPassword OraPasswd1 \
 -systemPassword OraPasswd1 \
 -createAsContainerDatabase false \
 -databaseType MULTIPURPOSE \
 -memoryMgmtType auto_sga \
 -totalMemory 1536 \
 -storageType FS \
 -datafileDestination "/u02/oradata/" \
 -redoLogFileSize 50 \
 -useOMF true \
 -emConfiguration NONE \
 -ignorePreReqs

• dbca logs

cd $ORACLE_BASE/cfgtoollogs/dbca

• Suppression Silent

dbca -silent -deletedatabase -sourceDB <SID>