How to delete a 10g Database Manually

Today I came across an issue with dbca.... Usually you can easily drop an oracle database using dbca. However today I was forced to manually to delete the database in question....

The following steps will help you to manually drop a database.

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

$export ORACLE_SID=yoursid

2.)Connect to SQL*Plus as SYSDBA privilege.

$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

3.)Mount the database in restricted mode.

SQL> startup RESTRICT mount

ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 2019288 bytes
Variable Size 92274728 bytes
Database Buffers 67108864 bytes
Redo Buffers 6369280 bytes
Database mounted.

4.)Drop the database.

SQL> drop database;
Database dropped.