Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

Creating a single instance Oracle database on Windows


Before you begin

  • A node is available to be used for provisioning.
  • The node must meet all of the Oracle database prerequisites.

To create a single-instance Oracle database

  1. From the Management Console, select the domain within which you want to create a single-instance Oracle database.
  2. In the Node Configuration section, select Provision > Add Oracle Database.
  3. In the Database Naming Information page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  4. If the Custom Fields page appears, enter values for the custom fields and click Next.

    Note

    This page appears only when in the BMC Database Automation XML template, either custom fields are defined used for this provisioning activity or New in 8.9.02any custom fields are defined for the database options (present on the Database Options page in this wizard). If you have defined custom field for a database option, value of that database option on the Database Options page will be derived from this custom field. For more information, see Adding-custom-fields-to-a-template.

  5. In the Oracle Home Selection page, select an Oracle Home from the Use Existing Home list box or create a new one, and click Next.
     The Oracle Home Selection page appears only when an Oracle Home is not defined for the version of the database being provisioned.
  6. In the Oracle Home Information page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  7. In the Oracle Home Components page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  8. In the Database Options page, check the boxes for each of the database options you want.
    If you select an option with a list box, select a tablespace from the list box, and click Next.
     These options require a tablespace to place the data into.
  9. In the Database Configuration page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

    Note

    BMC Database Automation allows you to define a separate inventory for each Oracle Home that is created. If you create a global inventory pointer, BMC Database Automation verifies that the inventory information matches.

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

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  11. In the Database Parameters page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  12. In the Control Files page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  13. In the Directories page, provision the following fields, and click Next.

    Note

    For Oracle 11g, the Background, Core and User Dump directories are not shown in the Directories page. Instead, the Diagnostic Directory field is provided. Use this field to enter the path and directory of the Automatic Diagnostic Repository (ADR) Home. The ADR contains the diagnostics (trace, core, and incident files; alert logs) for each database instance.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  14. In the Tablespaces page, configure the various tablespace types as follows, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

  15. In the Redo Logs page, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

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

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

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

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

    Note

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

  18. 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.
  19. 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.

  20. Click Create Oracle Database.
  21. If you disabled the Automatically Continue If All Tests Succeed option, you are prompted to click Continue after the pre-verification steps are done.
     After verification, the activities are performed and the results appear.
  22. (Optional) Click the magnifying glass icon to view log file details.
  23. Check the Results section for the Success message.
     If this procedure was not successful, see Troubleshooting-Oracle-provisioning-problems.

    Note

    You can always return to a Job's Information page by using 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*