Drop Database Manually

Do list

Find the location of files of the database:

sqlplus / as sysdba

SQL> select name from v$datafile;

SQL> select name from v$controlfile;

SQL> select member from v$logfile;

Drop the database:

sqlplus / as sysdba

SQL> shutdown immediate;

SQL> startup mount exclusive restrict;

SQL> drop database;

Check if all the data files, control files and redo log files are removed.

Clean the database name from /etc/oratab