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 (BDA). This includes creating Container Databases (CDBs) on Oracle versions 12.1.0.1 and later.

For information about creating a clustered Oracle database, see Creating-an-Oracle-cluster.

For information about adding a database to an Oracle cluster, see Adding-a-database-to-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 node within which you want to create an 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 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.
   If you selected Create New Home, proceed to the next step.
   If you selected an existing home, proceed to step 8.

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 Configuration page, populate the following fields, and click Next.
9. In the Database Options page, check the boxes for each of the database options you want.
   The following figure shows the Oracle 12.1.02 Database Options page:
   
   If you select an option from a list, select a tablespace from the list box, and click Next. These options require a tablespace to place the data into.

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 Done and 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.