Friday, August 16, 2024

How to create oracle database in silent mode using dbca ?

Create oracle database in silent mode using dbca


export ORACLE_SID=POC1


dbca -silent -createDatabase \

 -templateName General_Purpose.dbc \

 -gdbname POC1 -sid POC1 -responseFile NO_VALUE \

 -characterSet AL32UTF8 \

 -enableArchive true -archiveLogMode auto \

 -recoveryAreaDestination /u02/fast_recovery_area \

 -initParams db_unique_name=POC1, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_de

st_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \

 -sysPassword Welcome2 \

 -systemPassword Welcome2 \

 -createAsContainerDatabase true \

 -numberOfPDBs 1 \

 -pdbName PDB1 \

 -pdbAdminPassword Welcome2 \

 -databaseType MULTIPURPOSE \

 -memoryMgmtType auto_sga \

 -totalMemory 1000 \

 -storageType FS \

 -datafileDestination "/u02/oradata/" \

 -useOMF true \

 -redoLogFileSize 50 \

 -emConfiguration NONE \

 -sampleSchema true \

 -ignorePreReqs


No comments:

Post a Comment