Delete the Oracle database 11gR2 (11.2.0.4) using DBCA Silent mode
Posted by Mir Sayeed Hassan on October 20th, 2019
Delete the Oracle database 11gR2 (11.2.0.4) using DBCA Silent mode
Database status
[oracle@testdb ~]$ sqlplus / as sysdba SQL> select instance_name,status,version from V$instance; INSTANCE_NAME STATUS VERSION ------------- ----------------------------------------- testdb OPEN 11.2.0.4.0
Or
[oracle@testdb ~]$ ps -ef | grep pmon oracle 3872 3644 0 21:09 pts/1 00:00:00 grep --color=auto pmon oracle 21363 1 0 Sep17 ? 00:24:59 ora_pmon_testdb
To delete the database in silent mode, you need to shutdown the database
SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit
Delete the database using silent mode
[oracle@testdb ~]$ dbca -silent -deleteDatabase -sourceDB testdb -sysDBAUserName sys -sysDBAPassword testdb Connecting to database 4% complete 9% complete 14% complete 19% complete 23% complete 28% complete 47% complete Updating network configuration files 52% complete Deleting instance and datafiles 76% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/testdb.log" for further details.
[oracle@testdb ~]$ sqlplus / as sysdba SQL> select status from v$instance; select status from v$instance * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0
=====Hence the database is deleted, tested & verified in our test env=====