Database Configuration Assistant (DBCA) is a Java based GUI tool which is very useful to create, configure and drop databases. Oracle Database Configuration Assistant (DBCA) is a java based tool for creating, duplicating, dropping and configuring an Oracle database. Oracle strongly recommends using the Database Configuration Assistant (DBCA) to create a database. You can run DBCA in interactive mode or noninteractive/silent mode. Interactive mode provides a graphical interface and guided workflow for creating and configuring a database. Noninteractive/silent mode enables you to script database creation. This article provide brief information about the syntax and options for the Database Configuration Assistant (DBCA) silent mode commands. 

 

The command-line syntax of DBCA in silent mode

dbca [-silent] [command [options]] [-h|-help]

To view help for DBCA command-line arguments, enter the following command:

dbca -help

To view help for DBCA Silent Mode command-line arguments, enter the following command:

dbca -silent -help

You can display help for a specific command in silent mode by entering the following:

dbca -silent <command> -help

Example :
dbca -silent -createDatabase -help
dbca -silent -configureDatabase -help
dbca -silent -createDuplicateDB -help
dbca -silent -deleteDatabase -help

 

Creating Non-CDB Database In Silent Mode using DBCA

 

export ORACLE_HOME=/u01/app/oracle/19c
export PATH=$PATH:$ORACLE_HOME/bin
[oracle@ol79db01 ~]$ which dbca
/u01/app/oracle/19c/bin/dbca
[oracle@ol79db01 ~]$ $ORACLE_HOME/bin/dbca -silent -createDatabase -responseFile /home/oracle/db_create_DEV04DB.rsp