Database Multicloud Integration for Oracle Database Cloud Services

Using the Console to Manage Database Multicloud Integration for Oracle Database Cloud Services

Learn how to manage database multicloud integration for Oracle Database Cloud Services.

Integrate Oracle Exadata with Azure Cloud services

Oracle Database@Azure Identity Connectors, Storage Containers, and Storage Mounts are key components in the integration of Oracle Exadata with Azure Cloud services.

Oracle Database@Azure Identity Connectors: These connectors enable seamless interaction between Oracle Exadata Database and Azure Cloud services by linking the Oracle database with Azure identity and access management. It allows for Azure-specific authentication and authorization to be utilized directly within the Exadata VM Cluster.

Azure Storage Containers: Azure Blob Storage is used to store large amounts of unstructured data such as text, images, videos, and backups. By connecting Oracle Exadata to Azure Blob Storage, users can leverage cloud storage for scalable and secure data storage.

Azure Storage Mounts: Azure Blob Storage Mount refers to the process of attaching an Azure Storage Container as a mounted file system on an Oracle Exadata Database Service VM. This mount allows database utilities like Data Pump (impdp/expdp) and RMAN to interact with Azure storage as if it were a local directory.

Creating an Identity Connector installs the Azure Arc agent on the Exadata VM Cluster VMs, registering them as Azure Arc-enabled virtual machines.

This enables secure communication with the Azure Key Management Service (KMS) using the Azure identity generated by the Arc agent. The Azure Arc agent can communicate with Azure services over either a public network or a private connectivity setup. Learn more about Azure Arc.

Each Exadata VM cluster must have an identity connector enabled to access Azure resources. The identity connector establishes either a public or private connection between the Exadata VM cluster and Azure Key Management resources, depending on the roles assigned.

To generate an access token for your current Azure account, see az account get-access-token .

You can create an identity connector in one of two ways—using the Oracle Exadata Database Service on Dedicated Infrastructure interface or the Database Multicloud Integrations interface.

Oracle Exadata Database Service on Dedicated Infrastructure

  1. Open the navigation menu. Click Oracle Database, then click Oracle Exadata Database Service on Dedicated Infrastructure.
  2. From the left menu, click Exadata VM Clusters under Oracle Exadata Database Service on Dedicated Infrastructure.
  3. From the list of Exadata VM Clusters, select the cluster you are using.
  4. Select VM Cluster information, and then navigate to Identity connector located under Multicloud information. Click the Create link.
    Note

    If an identity connector has not been created previously, it is displayed as None.

  5. The Identity connector name, Exadata VM cluster, Azure subscription id, and Azure resource group name are read-only fields and will be populated with values.
  6. Enter your Azure tenant id, and Access token.
  7. Expand the Show advanced options section.

    The Private connectivity information and Tags sections populate.

    To enable a private endpoint connection, enter the Azure arc private link scope name.

  8. To add tags for your resources, click Add tag, and then enter required values.
  9. Review your selections, and then click Create to create the identity connector.

Database Multicloud Integrations

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Select Identity Connectors from the left navigation menu.
  3. From the Compartment drop-down list, select your compartment that you are using.
  4. Once you select your compartment, the Identity connector name automatically populates a name.

    By default, the identity connector type is selected as Azure.

  5. Select ARC agent as an identity mechanism.
  6. Select your compartment from the Choose an Exadata VM cluster compartment list, and then select your Exadata VM Cluster from the Choose an Exadata VM cluster list.
  7. Enter your Azure tenant id. The Azure subscription id and Azure resource group name fields populate values based on your Exadata VM Cluster selection.
  8. Enter an Access token.
  9. Expand the Show advanced options section. The Private connectivity information and Tags sections populate. These fields are optional.
  10. To add tags for your resources, click Add tag, and then enter required values.
  11. Review your selections, and then click Create.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Identity Connectors to view the list of Identity Connectors.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Identity Connectors to view the list of Identity Connectors.
  3. Click the name of the identity connector to view it's details.

    The resulting details page displays information, including the Arc Agent status, indicating whether it is connected or disconnected.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Containers.
  3. Click Create Storage container.
  4. Enter the following on the resulting Create storage container page.
    • Compartment: Select a compartment where you want to create this storage container.
    • Name: Enter a descriptive name for the storage container.
    • Account name: Enter the Azure storage container user name.

      This typically refers to the identity or credentials used to authenticate and access an Azure Storage Container. Depending on the authentication method, it could be an Azure Active Directory (Azure AD) identity or an access key-based authentication.

    • Storage container name: Enter the name of the Azure storage container.

      This is the unique name assigned to a specific storage container within an Azure Storage Account. The container name helps organize and store blobs (files and data) within the account.

    • IP address: Enter the IP address of the Azure Storage Container.
    • DNS Alias: Enter the fully qualified domain name (FQDN) that points to the Azure Storage Container.

To discover Azure storage container using an identity connector, use this procedure.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Containers.
  3. Click Discover Azure storage containers.
  4. Enter the following on the resulting Discover Azure storage containers page.
    • Compartment: Select a compartment where you want to create this storage container.
    • Azure storage containers: Choose an Identity Connector.
  5. Click Discover.

    The list of Storage Containers name(s) is displayed.

  6. Select the check box located next to Storage Container name.
  7. Click Create.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Containers to view the list of storage containers.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Containers to view the list of storage containers.
  3. Click the name of the storage container to view it's details.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Mounts.
  3. Enter the following on the resulting Create storage mount page.
    • Compartment: Select a compartment where you want to create this storage mount.
    • Storage mount name: Enter a descriptive name for the storage mount.
    • Identity connector: Select an identity connector.
    • Blob container: Select a storage container.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Mounts to view the list of storage mounts.

  1. Open the navigation menu. Click Oracle Database, then click Database Multicloud Integrations.
  2. Click Storage Mounts to view the list of storage mounts.
  3. Click the name of the storage mount to view it's details.

Using the API to Manage Multi-Cloud Data Integration for Oracle Database Cloud Services

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.

The following resources will be made available to customers through OCI SDK, CLI, and Terraform. These APIs will be used by customers who wish to integrate Oracle Database on Exadata with Azure Cloud Services.

Table 5-11 oracle-db-azure-connectors

API Description
createOracleDbAzureConnector Captures Azure-specific details from the customer and automates the installation of the ARC Agent on the ExaDB-D VM Cluster.
updateOracleDbAzureConnector Updates Azure-specific details from the customer and modifies the Arc Agent configuration if required.
changeOracleDbAzureConnectorCompartment Changes the compartment of the Azure Connector resource but does not affect the Arc Agent installation.
deleteOracleDbAzureConnector Deletes the Azure Connector resource and uninstalls the Arc Agent from the ExaDB-D VM Cluster.
getOracleDbAzureConnector Fetches the details of a specific Azure Connector resource.
listOracleDbAzureConnectors Lists Azure Connector resources based on the specified filters.

Table 5-12 oracle-db-azure-blob-containers

API Description
createOracleDbAzureBlobContainer Capture the Azure Storage Account and Container details, which will be used when mounting the Azure Container in the ExaDB-C@C VM Cluster. Additionally, this operation will update the Azure Storage Account and Container details as needed.
updateOracleDbAzureBlobContainer Updates the Azure Storage Account and Container details.
changeOracleDbAzureBlobContainerCompartment Changes the compartment of the Azure Blob Container resource.
deleteOracleDbAzureBlobContainer Deletes the Azure Blob Container Resource.
getOracleDbAzureBlobContainer Retrieves a specific Azure Blob Container resource.
listOracleDbAzureBlobContainers Lists Azure Blob Container resources based on the specified filters.

Table 5-13 oracle-db-azure-blob-mounts

API Description
createOracleDbAzureBlobMount Captures the Azure Storage Account and Container details and mounts the Azure Container on the ExaDB-D VM Cluster.
updateOracleDbAzureBlobMount Updates the Azure Storage Account and Container details and, if required, updates the mount details of the Azure Container on the ExaDB-D VM Cluster.
changeOracleDbAzureBlobMountCompartment Changes the compartment of the Azure Blob Mount Resource without making any changes to the ExaDB-C@C VM Cluster.
deleteOracleDbAzureBlobMount Deletes the Azure Blob Mount Resource and unmounts the Azure Container from the ExaDB-D VM Cluster.
getOracleDbAzureBlobMount Retrieves a specific Azure Blob Mount Resource.
listOracleDbAzureBlobMounts Retrieves a list of Azure Blob Mount Resources.

Table 5-14 oracle-db-mci-work-requests

API Description
ListWorkRequests Retrieves a list of all work requests.
GetWorkRequest Retrieves details of a specific work request.
CancelWorkRequest Cancels the specified work request.
ListWorkRequestErrors Retrieves a list of errors associated with a work request.
ListWorkRequestLogs Retrieves a list of logs related to a work request.

Table 5-15 multi-cloud-resource-discoveries

API Description
ListMultiCloudResourceDiscoveries Retrieves a list of all multi-cloud resource discovery resources.
CreateMultiCloudResourceDiscovery Creates a new multi-cloud resource discovery resource.
ChangeMultiCloudResourceDiscoveryCompartment Moves a multi-cloud resource discovery resource to a different compartment.
GetMultiCloudResourceDiscovery Retrieves details of a specific multi-cloud resource discovery resource.
UpdateMultiCloudResourceDiscovery Updates the details of a specific multi-cloud resource discovery resource.
DeleteMultiCloudResourceDiscovery Deletes a specific multi-cloud resource discovery resource.

Table 5-16 oracle-db-azure-vaults

API Description
ListOracleDbAzureVaults Retrieves a list of all Oracle DB Azure vault resources.
CreateOracleDbAzureVault Creates a new Oracle DB Azure vault resource.
ChangeOracleDbAzureVaultCompartment Moves an Oracle DB Azure vault resource to a different compartment.
RefreshOracleDbAzureVault Refreshes the details of an Oracle DB Azure vault resource.
GetOracleDbAzureVault Retrieves details of a specific Oracle DB Azure vault resource.
UpdateOracleDbAzureVault Updates the details of a specific Oracle DB Azure vault resource.
DeleteOracleDbAzureVault Deletes a specific Oracle DB Azure vault resource.

Table 5-17 oracle-db-azure-keys

API Description
ListOracleDbAzureKeys Retrieves a list of all Oracle DB Azure keys.
GetOracleDbAzureKey Retrieves details of a specific Oracle DB Azure key.

Table 5-18 oracle-db-azure-vault-associations

API Description
ListOracleDbAzureVaultAssociations Retrieves a list of all Oracle DB Azure vault associations.
CreateOracleDbAzureVaultAssociation Creates a new association between an Oracle DB and an Azure vault.
ChangeOracleDbAzureVaultAssociationCompartment Moves an Oracle DB Azure vault association to a different compartment.
GetOracleDbAzureVaultAssociation Retrieves details of a specific Oracle DB Azure vault association.
UpdateOracleDbAzureVaultAssociation Updates the details of a specific Oracle DB Azure vault association.
DeleteOracleDbAzureVaultAssociation Deletes a specific Oracle DB Azure vault association.
CascadingDeleteOracleDbAzureVaultAssociation Deletes an Oracle DB Azure vault association and any dependent resources.