Creating a single instance Oracle database on Windows

This topic describes how to add an Oracle single-instance database by using BMC Database Automation.

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.
4. If the Custom Fields page appears, enter the password, 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 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.

7. In the Oracle Home Components page, populate the following fields, and click Next.
8. In the Database Options page, check the boxes for each of the database options you want. 
    The following figure shows the Oracle Database Options page.
   
   
   The following figure shows the Oracle 11gR2 Database Options page.
   
   
   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.

   Warning

   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.

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

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

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

    Warning

    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.

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

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

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

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

    Warning

    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.

      Warning

      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.

    Warning

    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.