DBCA silent mode

This article describes how to create a new database using the Database Configuration Assistant (DBCA) in silent mode.

When you work in real-time on a remote server, you might not have access to graphical user interface. In such situations, you would need to run DBCA in silent mode to create a database.

There is a difference between Oracle 11g and Oracle 12c DBCA silent mode database creation. You will find examples of both 11g & 12c silent mode database creation below.

DBCA create database 11g

To run DBCA in silent mode, you just need to add -silent while running the DBCA utility. The below command will create testdb database in silent mode (oracle 11g version)

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname testdb -sid testdb -characterSet AL32UTF8 -memoryPercentage 20 -emConfiguration NONE

Notice the parameters:

  • -silent will run dbca in silent mode
  • -createDatabase specifies the option you want to perform
  • -templateName specifies the database template you using
  • -gdbname is your global database name
  • -sid is your database identifier

DBCA create database 12c

As Oracle 12c has PDB and CDB concepts, the DBCA silent mode has some more parameters compared to Oracle 11g.

The below command creates Oracle 12c database by running DBCA in silent mode. This commands works for both Oracle 12cR1 and Oracle 12cR2.

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName testdb -sid testdb -createAsContainerDatabase false -emConfiguration NONE -datafileDestination /u01/data/oracle/testdb/db_files -storageType FS -characterSet AL32UTF8 -totalMemory 2048 -recoveryAreaDestination /u01/app/oracle/fast_recovery_area

Notice new parameters:

  • -createAsContainerDatabase specifies if you want to create a container database
  • -datafileDestination specifies the location of your data files
  • -recoveryAreaDestination specifies the fast recovery area location

Note: you can also specify all the parameters inside a response file and provide the location of response file.

dbca -silent -responseFile /tmp/create_database.rsp

There are many parameters and many variations of dbca commands you will find. Not all the parameters are mandatory, but if you forget to specify mandatory parameters, dbca will ask for the value before proceeding. 

Do not panic when you see a different dbca silent mode command. Its just matter of parameters. Some commands will have only the required parameters and some will have all the parameters (required + optional). 

For complete reference of DBCA silent mode commands, check below link:

DBCA command reference for silent mode

DBCA delete database

You can use DBCA to delete database from a Linux server. Use below command to run DBCA in silent mode and delete a database

dbca -silent -deleteDatabase -sourceDB testdb -sysDBAUserName sys

Was this article helpful?

Related Articles


  1. dbca -silent -deleteDatabase -sourceDB testdb -sysDBAUserName sys

    This is not correct command to delete database. You also have to add -sysDBAPassword sys

    dbca -silent -deleteDatabase -sourceDB ORCL11g -sysDBAUserName sys -sysDBAPassword sys

    Note: You have to use your user name and password according to your server

  2. dear sir

    once i use 12c non cdb silent installation by db.rsp file my and execute command than
    my curser work as backspace key and all screen character earies.

  3. Should you create the /u01 directory before running the scrip or will the script create the directory?

    1. You have to create it as root user and give ownership to oracle user

      mkdir /u01
      chown -R oracle:oinstall /u01
      chmod -R 775 /u01

  4. I guess my question was on the DBCA create database 12c

Leave a Comment