Manually Drop an Oracle Database

1)Set the Oracle SID of the database which you interested to drop.

$ export ORACLE_SID=XXXX

2)Connect to SQL*Plus as SYSDBA privilege.

3)Mount the database.

SQL> startup force mount

4)Enable restricted session.

SQL> alter system enable restricted session;

5)Drop the database.

SQL> drop database