Dropping or Removing the Database and DeInstallation of Oracle DB server

Dropping or Removing the Database:

-- There are 3 ways to drop or remove the database from the Oracle DB Server. They are

                1). Mannually
             
                2). Silent Mode

                3). using DBCA utility

1). Dropping or Removing Database Mannually:

-- If the database(TEST) which you want to drop is in open mode, you should shutdown the database to drop

      sql>shut immediate

      sql>ho


-- Check the list of databases you have

      $cat /etc/oratab

     $exit


-- You should startup database in mount mode exclusively with restrict option

      sql>startup mount exclusive restrict

   
-- After the database is opened in mount mode, Then drop the database

      sql>drop database;
      sql>ho


-- Check the list of databases you have

      $cat /etc/oratab

2). Dropping or Removing Database in Silent Mode:

-- Using this below command You can also drop the database directly

Syntax:
=====

$dbca
-silent
-deleteDatabase
-sourceDB <database-name>
-sysDBAUserName <dbausername>
-sysDBAPassword <dbapassword>


To drop the database:
===============

$. .bash_profile

$cat /etc/oratab

$dbca -silent -deleteDatabase -sourceDB test -sysDBAUserName sys -sysDBAPassword sys

$cat /etc/oratab

3). Dropping or Removing Database using DBCA utility:

#xhost +

$su - oracle

$. . bash_profile

$cat /etc/oratab

$dbca

-- Now check the list of databases you have

      $cat /etc/oratab

DeInstallation of Oracle DB Server:

-- To UnInstall the Oracle DB Server from Operating Syste m, At first, It is better to remove all the  databases by following any of the above methods.

-- And now go for DeInstallation of Oracle DB Server STEPS..


$cd $ORACLE_HOME

$ls

$cd deInstall/

$ls

$ ./deInstall


-- After completing the deInstallation process, Check your oracle home directory...