Removing an Oracle RAC database

This topic describes how to remove an Oracle RAC database.

Before you begin

  • A running Oracle RAC database with exactly one instance currently managed by BMC Database Automation must be available.
  • 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.
    ImportantIf the database you are deleting is not the last database associated with the Oracle Home directory, the Oracle Home directory will not be deleted.
    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.

      NoteIf 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.
      NoteIf 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 an Oracle RAC database

  1. From the Management Console, navigate to the database that you want to remove.
  2. Select Provision > Remove Database.

  3. (Optional) In the General page, select a template from the Template list box.

    Note

    For more information about templates, see Managing-templates-for-Oracle-on-Linux-and-UNIX.

  4. If you select a template, click Skip Ahead to advance directly to the next step that requires input. An informational message appears on these steps, in green type, listing the fields that require entries before advancing to the next step.
    If you do not select a template, go to the next step.

  5. In the Options page, provision 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:

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

  8. 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.
  9. 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.

  10. Enter Yes when you are prompted to confirm your decision, and click OK.
    BMC Database Automation prepares to remove the database. A progress page appears.

  11. Click Continue to remove the database.

    Warning

    This operation permanently removes the RAC database from the node.

    When the database is removed, BMC Database Automation removes the resources for the database and the resources for any listeners associated with the Oracle Home if the home is also being removed. The remove database process also performs a re-scan, to ensure the Management Console gets updated.

  12. If this procedure was not successful, see Troubleshooting.

    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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*