Creating a single instance Oracle database on Linux and UNIX

This topic describes how to add an Oracle single-instance database by using BMC Database Automation. For information about creating a clustered Oracle database, see Creating-an-Oracle-cluster.

Before you begin

• A node must be available 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.

   Note

   If you select a template for your database, some fields in subsequent pages for this task would be pre-configured and, depending the template specification, non-editable. This allows administrators to enforce standards across the environment.

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.

   Note

   The following rules apply for provisioning Oracle Base and Oracle Home:

   • For a restart-enabled database (any version), there are no restrictions (Oracle home can be under Oracle base).
   • For a standalone database (any version), there are no restrictions (Oracle home can be under Oracle base).

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

   Note

   The fields that appear vary depending on the version of Oracle installed on the node. Differences are noted in the table.
8. In the Database Options page, check the boxes for each of the database options that 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.

9. In the Database Configuration page, populate the following fields, and click Next.

   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, populate the following fields, and click Next.

    Note

    For Oracle 11g, the Background, Core and User Dump directories are not shown in the Directories step. 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.

    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.
     If you disabled the Automatically Continue If All Tests Succeed and Skip Pre-Verification Tests options, you are prompted to click Continue after the pre-verification steps are done.
    The database creation process begins and a progress page appears.

    Note

    If you close your browser, the operation continues. You can return to this page by using the Jobs page.

21. (Optional) Click the magnifying glass icon to view log file details.
22. Check the Results section for the Success message.
     If this procedure was not successful, see Troubleshooting-Oracle-provisioning-problems.

23. Click Doneand return to the Contents view of this domain.

    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.