Create Oracle Database Homes on an Exadata Cloud Infrastructure System

Learn to create Oracle Database Homes on Exadata Cloud Infrastructure.

Parent topic: How-to Guides

About Creating Oracle Database Homes on an Exadata Cloud Infrastructure 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.

Related Topics

Parent topic: Create Oracle Database Homes on an Exadata Cloud Infrastructure System

To create a new Database Home in an existing Exadata Cloud Infrastructure instance

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. Click Oracle AI Database, then click Oracle Exadata Database Service on Dedicated Infrastructure
  2. Choose your Compartment.
  3. Navigate to the cloud VM cluster you want to create the new Database Home on:

    • Cloud VM clusters (new resource model): Under Oracle Exadata Database Service on Dedicated Infrastructure, click Exadata VM Clusters. In the list of VM clusters, find the VM cluster you want to access and click its highlighted name to view the details page for the cluster.

  4. Under Resources, click Database Homes.
    A list of Database Homes is displayed.
  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. Avoid entering confidential information.

      Database image: Determines what Oracle Database version is used for the database. You can have databases with different minor versions the same database home. The major versions must remain the same. By default, the latest Oracle-published database software image is selected.

      Click Change Database Image to use a desired Oracle-published image or a custom database software image that you have created in advance, then select an Image Type:

      • 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, Select a region, and Select a Database version selectors to limit the list of custom database software images to a specific compartment, region, or Oracle Database software major release version.

        Region filter defaults to the currently connected region and lists all the software images created in that region. When you choose a different region, the software image list is refreshed to display the software images created in the selected region.

        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.

        Note:

        The custom database software image must be based on an Oracle Database release that meets the following criteria:

        • The release is currently supported by Oracle Cloud Infrastructure.
        • The release is supported by the hardware model on which you are creating the Database Home.

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

    • 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 23, the Unified Auditing check box is not selected by default. However, it is selected by default for Oracle Database version 23.
      Unified Auditing field in the General Information section on the Database Home Details page displays if Unified Auditing is Enabled or Disabled.

    • Click Show Advanced Options to specify advanced options for the Database Home.

      • 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 whether to apply tags, skip this option (you can apply tags later) or ask your administrator.
  7. Click Create.

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

Parent topic: Create Oracle Database Homes on an Exadata Cloud Infrastructure System

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 Dedicated Infrastructure.

    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.

Parent topic: Create Oracle Database Homes on an Exadata Cloud Infrastructure System

To create Oracle Grid Infrastructure Home on Oracle Exadata Database Service on Dedicated Infrastructure

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 Oracle Exadata Database Service on Dedicated Infrastructure.

    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 OptionsYou 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.

Parent topic: Create Oracle Database Homes on an Exadata Cloud Infrastructure System

To create a database software image from a Database Home

  1. Open the navigation menu. Click Oracle AI Database, then click Oracle Exadata Database Service on Dedicated Infrastructure .
  2. Choose your Compartment.
  3. Navigate to the Database Home: Under Oracle Exadata Database Service on Dedicated Infrastructure, click Exadata VM Clusters. In the list of VM clusters, find the VM cluster you want to access and click its highlighted name to view the details page for the cluster.
  4. Click Database Homes under Resources.
  5. Find the Database Home you want to use to create the database software image in the list of Database Homes. Click the name of the Database Home to display details about it.
  6. Click Create Image from Database Home.
  7. In the Create Database Software Image panel, enter a Display name and select a compartment for the software image.
  8. Click Create.

Parent topic: Create Oracle Database Homes on an Exadata Cloud Infrastructure System

Using the API to Create Oracle Database Home on Exadata Cloud Infrastructure

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 Exadata Cloud Infrastructure, use the API operation CreateDbHome.

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

Related Topics

Parent topic: Create Oracle Database Homes on an Exadata Cloud Infrastructure System