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.
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.
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: