create oracle 19c database using dbca silent mode
dbca : DBCA stands for Database Configuration Assistant, a tool used to create and configure Oracle databases
Login as oracle user or user used to install the oracle binary
command :
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbName HRDB \
-sid HRDB \
-sysPassword Hrdb123# \
-systemPassword Hrdb123# \
-emConfiguration NONE \
-datafileDestination /u02/oradata \
-storageType FS \
-characterSet AL32UTF8 \
-sampleSchema true \
-enableArchive true -archiveLogMode auto \
-recoveryAreaDestination /u02/fast_recovery_area \
-databaseType MULTIPURPOSE \
-useOMF true \
-initParams db_unique_name=HRDB, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_dest_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \
-ignorePreReqs
[oracle@test ~]$ dbca -silent -createDatabase \
> -templateName General_Purpose.dbc \
> -gdbName HRDB \
> -sid HRDB \
> -sysPassword Hrdb123# \
> -systemPassword Hrdb123# \
> -emConfiguration NONE \
> -datafileDestination /u02/oradata \
> -storageType FS \
> -characterSet AL32UTF8 \
> -sampleSchema true \
> -enableArchive true -archiveLogMode auto \
> -recoveryAreaDestination /u02/fast_recovery_area \
> -initParams db_unique_name=HRDB, db_recovery_file_dest_size=10G, db_create_file_dest='/u02/oradata/', db_create_online_log_dest_1='/u02/oradata/', db_create_online_log_dest_2='/u02/fast_recovery_area/', dg_broker_start=false \
> -databaseType MULTIPURPOSE \
> -useOMF true \
> -ignorePreReqs
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
58% complete
60% complete
Completing Database Creation
66% complete
69% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/HRDB.
Database Information:
Global Database Name:HRDB
System Identifier(SID):HRDB
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/HRDB/HRDB.log" for further details.
[oracle@test ~]$
