Oracle Database 18c: Drop Database using dbca in silent Mode

In this short blog, I am going to cover how to create a drop a RAC Database using dbca in silent mode. 


Step 1 
Set the environment to the instance you want to work on (.oraenv)
i. Find out unique name of database 
show parameter unique in sqlplus
ii. Also see registered name in cluster
srvctl config database

Step 2
Drop the database in silent mode 
dbca -silent -deleteDatabase -sourceDB PRBRM
Enter SYS user password:


Connecting to database
9% complete
14% complete
19% complete
23% complete
28% complete
33% complete
38% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instances and datafiles
66% complete
80% complete
95% complete
100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/PRBRM.log" for further details.

Optionally when dropping the database you have the option to de-register from cloud control without doing additional work on Cloud Control 
The command is -deRegisterEMCloudControl

The complete help for delete database is as below. 

-deleteDatabase - Command to Delete a database.
-sourceDB Database unique name for RAC database or SID for Single Instance database
[-deRegisterEMCloudControl ]
-emUser EM Admin username to add or modify targets
-omsHost EM management server host name
-omsPort EM management server port number
[-emPassword EM Admin user password]
[-forceArchiveLogDeletion To delete archive logs of a database]
[-sid Database system identifier]
[-sysDBAPassword Password for sysDBAUserName user name]
[-sysDBAUserName User name with SYSDBA privileges]