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