Creating and Deleting Database in Silent Mode using DBCA?

In this article, I’m going to demonstrate to you, Creating and Deleting Database in Silent Mode using DBCA (Database Configuration Assistant) steps by steps. Through DBCA we can create a new Database, Delete the database, and modify the Database. As well as it can manage templates and Pluggable Databases in Oracle 12c. These actions are possible in silent mode using the DBCA command.

DBCA Response File

This response file providing all the answers to that questions which is asked by DBCA command graphically. You can find a response file in the following path ($ORACLE_HOME/assistants/dbca/dbca.rsp).

Let’s see practically:
Firstly go inside the ORACLE_HOME path suing following path.

cd /u01/app/oracle/product/11.2.0.4/db_1/assistants/dbca/

Now run the below command

dbca -silent -responseFile ./dbca.rsp (Default name of the database is orcl11g)

Enter SYS user password: (enter here the admin password)
Enter SYSTEM user password: (enter here the admin password)
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.

For more detail you can monitor the log file same like below.

cat /u01/app/oracle/cfgtoollogs/dbca/orcl11g/orcl11g.log
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 26%
DBCA_PROGRESS : 37%
Creating and starting Oracle instance
DBCA_PROGRESS : 40%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 50%
DBCA_PROGRESS : 55%
DBCA_PROGRESS : 56%
DBCA_PROGRESS : 60%
DBCA_PROGRESS : 62%
Completing Database Creation
DBCA_PROGRESS : 66%
DBCA_PROGRESS : 70%
DBCA_PROGRESS : 73%
DBCA_PROGRESS : 85%
DBCA_PROGRESS : 96%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/orcl11g.
Database Information:
Global Database Name:orcl11g.us.oracle.com
System Identifier(SID):orcl11g

Now how to delete Database in silent mode using DBCA command.

dbca -silent -deleteDatabase -sourceDB orcl11g 
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl11g.log" for further details.

Note: The same response file we can use to take the multiple actions against the database, the response file is complicated and it’s very big file.

• CREATEDATABASE
• DELETEDATABASE
• generateScripts
• CONFIGUREDATABASE
• DELETEINSTANCE
• createTemplateFromDB
• createCloneTemplate
• ADDINSTANCE
• UNPLUGDATABASE
• CREATEPLUGGABLEDATABASE
• CONFIGUREPLUGGABLEDATABASE
• DELETEPLUGGABLEDATABASE

Creating and Deleting Database in Silent Mode using DBCA complete our tutorial, if you learn something please write in comment box.

Read - Managed space in Tablespace

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: https://www.linkedin.com/in/shripal-singh
Twitter: https://twitter.com/ocptechnology
Facebook: https://www.facebook.com/ocptechnology
YouTube:https://www.youtube.com/ocptechnology