Oracle Cloud Infrastructure Documentation

Create Oracle Database Homes on an Oracle Exadata Database Service on Cloud@Customer System

Learn to create Oracle Database Homes on Oracle Exadata Database Service on Cloud@Customer.

Parent topic: How-to Guides

About Creating Oracle Database Homes on an Oracle Exadata Database Service on Cloud@Customer System

You can add Oracle Database homes (referred to as Database Homes in Oracle Cloud Infrastructure) to an existing VM cluster by using the Oracle Cloud Infrastructure Console, the API, or the CLI.

A Database Home is a directory location on the Exadata database virtual machines that contains Oracle Database software binary files.

Note

Avoid entering confidential information when assigning descriptions, tags, or friendly names to your cloud resources through the Oracle Cloud Infrastructure Console, API, or CLI.

You can also add and remove Database homes, and perform other management tasks on a Database home by using the dbaascli utility.

Using the Console to Create Oracle Database Home on Oracle Exadata Database Service on Cloud@Customer

To create an Oracle Database home in an existing VM cluster with the Console, be prepared to provide values for the fields required.

Note

Minimum requirements for provisioning a Database 26ai home:
  • Grid Infrastructure 26ai
  • Exadata Guest VM running Exadata System Software 23.1.8
  1. Open the navigation menu. Under Oracle AI Database, click Exadata Database Service on Cloud@Customer.
    VM Clusters is selected by default.
  2. Choose your Compartment.
    A list of VM Clusters is displayed for the chosen Compartment.
  3. In the list of VM clusters, click the VM cluster on which you want to create the Database Home.
  4. Under Resources, click Database Homes.
  5. Click Create Database Home.
  6. In the Create Database Home dialog, enter the following:
    • Database Home display name: The display name for the Database Home.
    • Unified Auditing: Select this check box to enable Unified Auditing framework.
      Note

      You cannot disable Unified Auditing after provisioning the Database Home.
      • For Oracle Database versions lower than 12.1: You cannot use the Unified Auditing framework and should instead use the Traditional Audit, the legacy Oracle Database audit framework.
      • For Oracle Database versions 12.1 or higher: You can enable Unified Auditing from the OCI Console. For Oracle Database versions 12.1 or higher but lower than version 26ai, the Unified Auditing check box is not selected by default. However, it is selected by default for Oracle AI Database 26ai.

        Unified Auditing field in the General Information section on the Database Home Details page displays if Unified Auditing is Enabled or Disabled.

    • Database image: Determines what Oracle Database version is used for the database. You can mix database versions on the Exadata VM Cluster, but not editions. By default, the latest Oracle-published database software image is selected.

      Click Change Database Image to use an older Oracle-published image or a custom Database Software Image that you have created in advance, then choose one of the options below on the Select a Database Software Image window.

      Oracle Provided Database Software Images: These images contain generally available versions of Oracle Database software.

      Custom Database Software Images: These images are created by your organization and contain customized configurations of software updates and patches.

      Use the Select a compartment and Select a Database version selectors to limit the list of custom Database Software Images to a specific compartment or Oracle Database software major release version.

      Use the Region filter to access the software images created in a different region.

      After choosing a software image, click Select to return to the Create Database Home dialog.

      Note

      For the Oracle Database major version releases available in Oracle Cloud Infrastructure, images are provided for the current version plus the three most recent older versions (N through N - 3). For example, if an instance is using Oracle Database 19c, and the latest version of 19c offered is 19.8.0.0.0, images available for provisioning are for versions 19.8.0.0.0, 19.7.0.0, 19.6.0.0 and 19.5.0.0.
      A Database Software Image will not be available for Database Home creation if:
      • The database version of Database Software Image is out of support. For example, Database Software Images created using 11.2.0.4 will not be available for Database Home provisioning after 31-Dec-2022.
      • The Exadata model should support the PSU/RU version of the Database Software Image. For example, for the 19c release, the X8M-2 model supports RU version 19.4 and greater.
      • Only Database Software Images created specifically in the context of Exadata Cloud@Customer service can be used while provisioning and patching Database Homes within the Exadata Cloud@Customer service.
      • The Database Software Image is not in Available state, that is, Deleted or is being Updated.

    • Show Advanced Options

      You have the option to configure advanced options.

      • Tags: (Optional) You can choose to apply tags. If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see "Resource Tags". If you are not sure if you should apply tags, then skip this option (you can apply tags later) or ask your administrator.

    Note that after Home install, patch to the latest if the latest patch is available.

  7. Click Create.
    When the Database Home creation is complete, the status changes from Provisioning to Available.

Using the Console to Create Custom GI Software Image from an Oracle Grid Infrastructure Home

To create a custom GI Software Image from an existing Oracle Grid Infrastructure Home, be prepared to provide values for the fields required.

  1. Open the navigation menu. Under Oracle AI Database, click Oracle Exadata Database Service on Cloud@Customer.

    VM Clusters is selected by default.

  2. Choose your Compartment.

    A list of VM Clusters is displayed for the chosen Compartment.

  3. In the list of VM clusters, click the VM cluster that contains the GI Home from which you want to create a custom GI software image.
  4. Click Grid Infrastructure homes.
  5. Choose the GI home, and select View details from the Actions menu (three dots).
  6. In the resulting Grid infrastructure Home Information page, click Create software image.
  7. In the resulting Create Grid Infrastructure software image dialog, provide a display name and select a compartments where you want this image to be created.
  8. Click Create.

    The Software Image details displays the details of the Work Request.

Using the Console to Create Oracle Grid Infrastructure Home on Oracle Exadata Database Service on Cloud@Customer

To create an Oracle Grid Infrastructure home in an existing VM cluster with the Console, be prepared to provide values for the fields required.

  1. Open the navigation menu. Under Oracle AI Database, click Exadata Database Service on Cloud@Customer.

    VM Clusters is selected by default.

  2. Choose your Compartment.

    A list of VM Clusters is displayed for the chosen Compartment.

  3. In the list of VM clusters, click the VM cluster on which you want to create the GI Home.
  4. Click Grid Infrastructure homes.
  5. Click Create Grid Infrastructure home.
  6. In the Create Grid Infrastructure home dialog, enter the following:
    • Grid Infrastructure Home display name: The display name for the Database Home.
    • Select Grid Infrastructure version: From the list, choose the GI software release that you want to deploy.
    • Grid Infrastructure image: Determines what GI version is used for the VM Cluster.
      • Click Change Grid Infrastructure Image to use an Oracle-published image or a custom Grid Infrastructure Software Image that you have created in advance, then choose one of the options below on the Select a Grid Infrastructure Software Image window.
        Note

        You can create a new Grid Infrastructure home only by using a Grid Infrastructure software image whose version is later than the current Grid Infrastructure version running on the cluster.
        • Use Oracle Grid Infrastructure Software Images: These images contain generally available versions of Oracle Grid Infrastructure software.
        • Use existing Custom Grid Infrastructure Software Images: These images are created by your organization and contain customized configurations of software updates and patches.

          Use the Select a compartment and Select a Grid Infrastructure version selectors to limit the list of custom Grid Infrastructure Software Images to a specific compartment or Oracle Grid Infrastructure software major release version.

        • After choosing a software image, click Select to return to the Create Grid Infrastructure home dialog.
    • Show Advanced Options You have the option to configure advanced options.
      • Tags: (Optional) You can choose to apply tags. If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see "Resource Tags". If you are not sure if you should apply tags, then skip this option (you can apply tags later) or ask your administrator.
    Note

    Only the active Grid Infrastructure home associated with the VM cluster can be patched using an in-place update. Newly created Grid Infrastructure homes cannot be patched until they become the active Grid Infrastructure home.
  7. Click Create.

    When the Grid Infrastructure Home creation is complete, the status changes from Provisioning to Available.

Using the API to Create Oracle Database Home on Oracle Exadata Database Service on Cloud@Customer

To create an Oracle Database home, review the list of API calls.

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

To create Database Homes in Oracle Exadata Database Service on Cloud@Customer, use the API operation CreateDbHome.

For the complete list of APIs, see Database Service API.