How to drop RAC database using dbca? Multitenant DB

https://youtu.be/gSf2Qz2Vo7M

Different Methods or Approaches for database drop :

1. We can drop using manual method

- Manual method is tedious and involves lots manual efforts before and after the database drop 

High level Steps for Manual method to Drop database:

Step 1: Stop database using srvctl 

srvctl stop database -d <DB_NAME>

Step 2: Start database instance in nomount mode on only node1

. oraenv >>> SID1

env |grep ORA

sqlplus / as sysdba

SQL> startup nomount 

Step 3: set cluster_database=false 

alter system set cluster_database=false;

Step 4: stop database instance which started on node1 

SQL> shut immediate 

Step 4: start database in mount restrict exclusive mode only on node1 

SQL> startup mount exclusive restrict; 

Step 5: drop database 

SQL> drop database;

Step 6: Post cleanup after the database drop 

- Remove entry from /etc/oratab file from all RAC nodes 

- Remove entry from cluster 

srvctl remove database -d <DB_NAME>

2. We can drop using GUI using dbca method 

- dbca methos is easy and fully automated 

High level Steps for Manual method to Drop database:

Step 1: drop database using dbca by launcing dbca GUI mode 

cd $ORACLE_HOME/bin 

./dbca >>> select delete database option and drop the database