Creating Oracle Database Homes on an Exadata Cloud@Customer System

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

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

Required IAM Policy for Creating Oracle Database Homes

Review the identity access management (IAM) policy for creating Oracle Database homes on Oracle Exadata Cloud@Customer Systems.

A policy is an IAM document that specifies who has what type of access to your resources. It is used in different ways:
  • An individual statement written in the policy language
  • A collection of statements in a single, named "policy" document, which has an Oracle Cloud ID (OCID) assigned to it
  • The overall body of policies your organization uses to control access to resources

A compartment is a collection of related resources that can be accessed only by certain groups that have been given permission by an administrator in your organization.

To use Oracle Cloud Infrastructure, you must be given the required type of access in a policy written by an administrator, whether you're using the Console, or the REST API with a software development kit (SDK), a command-line interface (CLI), or some other tool. If you try to perform an action, and receive a message that you don’t have permission, or are unauthorized, then confirm with your administrator the type of access you've been granted, and which compartment you should work in.

For administrators: The policy in "Let database admins manage DB systems" lets the specified group do everything with databases, and related database resources.

If you're new to policies, then see "Getting Started with Policies" and "Common Policies". If you want to dig deeper into writing policies for databases, then see "Details for the Database Service".

Using the Console to Create Oracle Database Home on Exadata 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.

  1. Open the navigation menu. Under Oracle Databases, click Exadata 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.
    • 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 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 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.

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

      Note

      Oracle recommends using a custom Database Software Image not older than N-3 from the latest.
      A Database Software Image will not be available for Database Home creation if:
      • The Database Software Images was created using EXADATA_SHAPE/VM_BM_SHAPE. Such images will not be available for Database Home provisioning for Exadata Cloud@Customer.
      • 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 API to Create Oracle Database Home on Exadata 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 Exadata Cloud@Customer, use the API operation CreateDbHome.

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