DBCA Silent Mode Oracle

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.

• DBCA Silent Mode 19c

• DBCA Silent Mode 12c

• DBCA Silent Mode 11g

• DBCA Silent Mode Delete Database

DBCA Silent Mode 19c

Fire DBCA to create 19c database

dbca -silent -createDatabase                            \
     -templateName General_Purpose.dbc                  \
     -gdbname ${ORACLE_SID} -sid  ${ORACLE_SID}         \
     -characterSet AL32UTF8                             \
     -sysPassword enterDB#123                           \
     -systemPassword enterDB#123                        \
     -createAsContainerDatabase false                   \
     -totalMemory 2000                                  \
     -storageType FS                                    \
     -datafileDestination /u01/db_files                 \
     -emConfiguration NONE                              \
     -ignorePreReqs -sampleSchema true

DBCA Silent Mode 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/db_files -storageType FS -characterSet AL32UTF8 -totalMemory 2048 -recoveryAreaDestination /u01/FRA -sampleSchema true

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

DBCA Silent Mode 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 Silent Mode 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

Further Read

• DBCA command reference for silent mode