Drop Database Manually in Oracle

Sometimes we need to drop the unusable oracle database from the server to free up the resources. So in this article, we are going to learn step by step how to drop database manually in oracle.


Before the drop, must be sure about the database which you want to drop, then find below details of the database.

  • Controlfile Location
  • Datafile Location
  • Online Redo Log Location

We will be cross verify the file after it the dropped, using the following queries.

SQL> select name from v$controlfile;
SQL> select name from v$datafile;
SQL> select member from v$logfile;
Drop Database Manually

Steps to Drop Database manually.

Follow the below steps carefully.

Step 1: Login in Database as sysuser

$ export ORACLE_SID=ocp
$ sqlplus sys/pass as sysdba

Step 2: Shutdown the Database

SQL> shu immediate;

Step 3: Mount Database in restrict mode

SQL> startup mount exclusive restrict;

Step 4: Drop the Database

SQL> drop database;

After dropping the database you must verify the physical locations and remove the related directories also disable the cronjobs. drop database including contents and datafiles.

Read More:

  1. How do I manually drop a database?

    Using the above commands you can drop the database.

  2. How do I delete a database without Dbca?

    The manual method you can use to drop the database, read the above article.

  3. How do I drop a database in Windows?

    The same manual method you can use in the windows platforms.

5 thoughts on “Drop Database Manually in Oracle”

Leave a Comment