Removing a single instance Oracle database on Linux and UNIX

This topic describes how to remove a single instance Oracle database on Linux/UNIX.

• Before you begin
• To remove a single-instance Oracle database on Linux/UNIX

Before you begin

New in 8.9.02Starting with version 8.9.02, you can retain or delete the Oracle Home directory when deleting its last associated Oracle database.

To enable the option to retain or delete the Oracle Home directory, you need to add a parameter, delete_homes_prompt, to the d2500_config file, as follows:

To enable the option to retain or delete the Oracle Home directory

1. Log on to the BMC Database Automation Manager server and navigate to the following directory: /app/clarity/dmanager/etc.
2. Edit the d2500_config file with a text editor and append the following parameter to the file:
   delete_homes_prompt=True
3. Save the file.

After you add the parameter, you can use one of the following methods to retain or delete the Oracle Home directory. If the last database is removed, but the Oracle Home is kept, it is re-discovered and appears in the Pending Approval > Oracle > Oracle Homes Pending Approval section.

• Use the Delete Home option: When you set the value of delete_homes_prompt to True, the Delete Home option becomes available on the Remove Oracle Database wizard. By default, this option is already selected. You can clear this option if you do not want to delete the Oracle Home directory.
  
  

  Note

  If you do not insert the delete_homes_prompt parameter in the d2500_config file or set its value to False, the Delete Home option will not be available on the Remove Oracle Database wizard and Oracle Home is removed automatically.

• Use the <delete_homes> tag in the template: Modify the template that you want to use while deleting an Oracle Database. Add the XML tag to the template as follows:
  

  XML tag	Description
  <delete_homes> </delete_homes>	Valid values are: True: The Oracle Home directory is automatically deleted when its last associated Oracle database is removed. False: The Oracle Home directory is not automatically deleted when its last associated Oracle database is removed.

  Note

  If you do not insert the delete_homes_prompt parameter in the d2500_config file or set its value to False, value of the <delete_homes> tag in the template is not considered and Oracle Home is removed automatically.

To remove a single-instance Oracle database on Linux/UNIX

1. From the Management Console, navigate to the domain that contains the Oracle database that you want to remove, and click the database name.
2. In the right pane, under Database Configuration, select Provision > Remove Database.

3. In the Remove Oracle Database page, update the fields as follows, and click Next.
4. If the Custom Fields page appears, update fields as desired, and click Next.
    The Custom Fields page appears only when custom fields are defined in the BMC Database Automation XML template used for this provisioning activity. See Adding-custom-fields-to-a-template.

5. In the Options page, update the following fields, and click Next.

6. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.

7. In the Job Options page, specify any of the following Job options, and click Next.

8. If the Change Control page displays, populate the following fields, and click Next.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

9. In the Summary page, review the provisioning information.
   To make changes, do the following:
   1. Click Go to to return to the provisioning step that you want to edit.
   2. Make your changes.
   3. Click Save and Review to return to the Summary page.
10. Specify your verification preferences.
     For additional information, see Understanding pre-verification tests.
    • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

    • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      Note

      The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

11. Click Remove Database. You are prompted to confirm that you want to remove the database.

    Warning

    This operation permanently deletes the database files from the node.

12. Click OK.
    A status page appears, and a confirmation message appears when the database has been removed.

    Note

    If you select the Automatically Continue If All Tests Succeed option while the removal is in progress, the removal process continues automatically after the tests have been completed successfully.

13. Click Continue to complete this step and return to the Contents view of this domain.
     If this procedure was not successful, see Troubleshooting.

14. Click Done.

    Note

    Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring-jobs-and-viewing-job-history.