Create Database Using DBCA in Silent Mode Oracle 19c

In this article, we will explore how to create a database in silent mode, without using a GUI.

Step 1: Export ORACLE_HOME and Verify DBCA Path:

[oracle@dba-simplified ~]$ export ORACLE_HOME=/home/app/oracle/product/19.3.0/db_1
[oracle@dba-simplified ~]$ which dbca
/home/app/oracle/product/19.3.0/db_1/bin/dbca

Step 2: Navigate to the DBCA assistants directory and create your own response file:

[oracle@dba-simplified ~]$ cd $ORACLE_HOME/assistants/dbca
[oracle@dba-simplified dbca]$
[oracle@dba-simplified dbca]$ pwd
/home/app/oracle/product/19.3.0/db_1/assistants/dbca
[oracle@dba-simplified dbca]$ vi dbcreate.rsp
[oracle@dba-simplified dbca]$
[oracle@dba-simplified dbca]$ cat dbcreate.rsp
gdbName=orclcdb
sid=orclcdb
templateName=General_Purpose.dbc
sysPassword=Redhat#321
systemPassword=Redhat#321

Step 3: Create a database using DBCA in silent mode:

[oracle@dba-simplified dbca]$ dbca -silent -CreateDatabase -responseFile dbcreate.rsp
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% 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:
 /home/app/oracle/cfgtoollogs/dbca/orclcdb.
Database Information:
Global Database Name:orclcdb
System Identifier(SID):orclcdb
Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orclcdb/orclcdb.log" for further details.

Step 4: Verify the database entry in the oratab file:

[oracle@dba-simplified dbca]$ cat /etc/oratab | grep orclcdb
orclcdb:/home/app/oracle/product/19.3.0/db_1:N

Step 5: Verify listener status:

[oracle@dba-simplified ~]$ lsnrctl status | grep orclcdb
Service "orclcdb" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclcdbXDB" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...

Step 6: Connect to the newly created database and verify the details:

[oracle@dba-simplified ~]$ . oraenv
ORACLE_SID = [orclcdb] ?
The Oracle base remains unchanged with value /home/app/oracle
[oracle@dba-simplified ~]$
[oracle@dba-simplified ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 20 13:56:20 2025
Version 19.27.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0

SQL> select name, open_mode from v$database;
NAME      OPEN_MODE
--------- --------------------
ORCLCDB   READ WRITE

SQL> select name from v$datafile;
NAME
----------------------------------------------------
/home/app/oracle/oradata/ORCLCDB/system01.dbf
/home/app/oracle/oradata/ORCLCDB/sysaux01.dbf
/home/app/oracle/oradata/ORCLCDB/undotbs01.dbf
/home/app/oracle/oradata/ORCLCDB/users01.dbf

Database was successfully created using the DBCA utility in silent mode, and all related Oracle services are running as expected.

Note: This procedure is intended for learning or testing purposes. It is not recommended to perform these steps directly on a production environment. If you choose to do so, proceed at your own risk and ensure you have proper backups and change control in place.