3.8 Deleting an Oracle RAC Database Using DBCA

Deleting an Oracle RAC database using Oracle Database Configuration Assistant (DBCA) involves deleting the database and database objects.

DBCA first deletes the database, and then removes the database's initialization parameter files, instances, Optimal Flexible Architecture (OFA) structure, and the Oracle network configuration for the database.

1. Start DBCA on one of your cluster nodes.
   DBCA displays the Operations page, displaying different database deployment options.
2. Select Delete a database, and click Next.
   DBCA displays a list of all Oracle RAC and single-instance databases running from the Oracle home where DBCA is run.
3. If your user ID and password are not operating-system authenticated, then the List of Cluster Databases page displays the user name and password fields. If these fields appear, then enter a user ID and password for a user account that has SYSDBA privileges.
4. Select the database to delete, and click Finish.
   After you click Finish, DBCA displays a dialog box to confirm the database and instances that you have configured DBCA to delete.
5. Click OK to begin the deletion of the database and its associated files, services, and environment settings, or click Cancel to stop the operation.

When you click OK, DBCA continues the operation and deletes all the associated instances for this database. DBCA also removes the parameter files and password files.

At this point, you have accomplished the following:

• Deleted the selected Oracle RAC database from the cluster

• Deleted the selected Oracle RAC Database Oracle services on Windows-based platforms

• Deleted high availability services assigned to the Oracle RAC database

• Deleted the Oracle Net configuration for the Oracle RAC database

• Deconfigured Oracle Enterprise Manager for the Oracle RAC database

• Deleted the OFA directory structure for that Oracle RAC database from the cluster

• Deleted the Oracle RAC database data files