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