Tag Archives: delete database using dbca

Delete database using DBCA silent mode

Delete database using DBCA silent mode

AIM: We want delete database POCNDEV using DBCA silent mode

[oracle@rac2 ~]$ ps -ef | grep pmon
oracle    3542     1  0 05:13 ?        00:00:00 asm_pmon_+ASM
oracle    3686     1  0 05:14 ?        00:00:00 ora_pmon_COLLEGE
oracle    3877  3976  0 07:12 pts/1    00:00:00 grep pmon
oracle    5045     1  0 05:33 ?        00:00:00 ora_pmon_POCNDEV <---
oracle    6436     1  0 05:54 ?        00:00:00 ora_pmon_FICO
[oracle@rac2 ~]$ . oraenv
ORACLE_SID = [POCNDEV] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 21 07:13:35 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
POCNDEV   READ WRITE

SQL> shut immediate; <---
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac2 ~]$ ps -ef | grep pmon
oracle    3542     1  0 05:13 ?        00:00:00 asm_pmon_+ASM
oracle    3686     1  0 05:14 ?        00:00:00 ora_pmon_COLLEGE
oracle    3957  3976  0 07:14 pts/1    00:00:00 grep pmon
oracle    6436     1  0 05:54 ?        00:00:00 ora_pmon_FICO
[oracle@rac2 ~]$
[oracle@rac2 ~]$ which dbca
/u01/app/oracle/product/11.2.0.4/db_1/bin/dbca
Please don't try in your office machines
[oracle@rac2 ~]$ dbca -silent -deleteDatabase -sourceDB POCNDEV -sysDBAUserName sys -sysDBAPassword sys
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/POCNDEV.log" for further details.
[oracle@rac2 ~]$

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar