askMLabs

In this post, Let us discuss the steps to delete database in silent mode. For steps to install Database 18c refer my other posts Oracle Database 18c Simple Installation and Install Oracle Database 18c In Silent Mode.

For complete deinstallation of the Oracle Database 18c refer my other post Deinstall/Uninstall Oracle Database 18c.

The complete syntax of dbca to delete database is here …

[oracle@askm18c response]$ $ORACLE_HOME/bin/dbca -silent -deleteDatabase -help
         -deleteDatabase - Command to Delete a database.
                 -sourceDB <Database unique name for RAC database or SID for Single Instance database>
                 [-unregisterWithDirService <true | false>]
                         -dirServiceUserName <User name for directory service>
                         [-dirServicePassword <Password for directory service>]
                         [-walletPassword <Password for database wallet>]
                 [-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>]
                 [-sysDBAUserName <User name  with SYSDBA privileges>]
                 [-forceArchiveLogDeletion <To delete archive logs of a database>]
                 [-sysDBAPassword <Password for sysDBAUserName user name>]
                 [-sid <Database system identifier>]

Use the following syntax to delete database

[oracle@askm18c response]$ $ORACLE_HOME/bin/dbca -silent -deleteDatabase -sourceDB db18c -sysDBAUserName sys
Enter SYSDBA user password:

[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
35% complete
39% complete
42% complete
45% complete
48% complete
52% complete
65% complete
Updating network configuration files
68% complete
Deleting instance and datafiles
84% complete
100% complete
Database deletion completed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/db18c/db18c0.log" for further details.
[oracle@askm18c response]$

The logfiles to monitor the progress of the database 18c deletion are ….

[root@askm18c db18c]# ls -lrt
-rw-r-----. 1 oracle oinstall     1088 Aug 15 23:46 DBDetails.log
-rw-r-----. 1 oracle oinstall        0 Aug 15 23:46 trace.log_2018-08-15_11-46-19PM.lck
-rw-r-----. 1 oracle oinstall      460 Aug 15 23:46 db18c0.log
-rw-r-----. 1 oracle oinstall   327879 Aug 15 23:46 trace.log_2018-08-15_11-46-19PM
-rw-r-----. 1 oracle oinstall      437 Aug 15 23:46 ShutdownInst.log
[root@askm18c db18c]#

One question to the readers :  Do we need to keep the database up or down for executing the dbca database deletion command ? Please leave your response in comments.

Hope this information helps….