Oracle Cloud Infrastructure Documentation

Monitoring Exadata Database Services in Azure

Oracle Database@Azure provides a mechanism within Microsoft Azure to monitor Exadata Database Services. Azure is responsible for collection and storage of observability data.

Metrics for successfully provisioned Oracle Exadata VM Clusters can be seen as follows:

  1. Follow the steps to Access the Resource Blade.
  2. Select the Oracle Exadata VM Cluster tab.
  3. In the Name field, select the link for an Available Exadata VM Cluster.
  4. In the left-menu, select Monitoring > Metrics.
  5. You will be able to view all supported metrics under the Monitoring tab of the provisioned Exadata VM Cluster.

Topics:

Exadata Database Services Metrics Resources

Metrics published by OCI Oracle Exadata VM Cluster will be available with the following exceptions.

Note: Any metric available under the namespaces oracle_oci_database, oci_database, or oci_database_cluster but not mentioned in Metrics for Exadata Cloud Infrastructure in the Database Management Service or Metrics for Oracle Exadata Database Service on Dedicated Infrastructure in the Monitoring Service will not be published to Azure.

Monitor Exadata Infrastructure Logs and Events

Monitoring Exadata Infrastructure logs and events enables you to troubleshoot issues effectively, validate system health, and integrate with enterprise-wide observability platforms. This topic explains the required steps to monitor your Exadata Infrastructure logs and events from the Azure portal using Event Hubs, Storage Account, Log Analytics workspace and Azure Monitor partner solutions.

Prerequisites:

  1. You must create diagnostic settings.
    For the list of events for Exadata Infrastructure, see Oracle Exadata Database Service on Dedicated Infrastructure Event Types .
    Note

    The following event shown in the table is not supported. Logs of this event will not be displayed or exported to the destination.

    Table 1-2

    Name Event Type
    Cloud Exadata Infrastructure - Create Begin com.oraclecloud.databaseservice.createcloudexadatainfrastructure.begin

    For the list of maintenance events for Exadata Infrastructure, see Oracle Exadata Database Service on Dedicated Infrastructure Maintenance Event Types.

  2. You must create a storage account. For more information, see Create an Azure storage account.
  3. You must create an Azure Event Hubs namepace. For more information, see Create an event hub using Azure portal.
  4. You must create a Log Analytics workspace. For more information, see Create a Log Analytics workspace.
  5. You must create a new instance for Dynatrace. For more information, see Get started with Dynatrace.
  6. You must enable SSO log-in using Azure portal before creating any Dynatrace resource in Azure. For more information, see Configure pre-deployment.

Create Diagnostic Settings for an Exadata Infrastructure and Send Logs to a Storage Account

Learn how to edit and create diagnostic settings for your Exadata Infrastructure to send events and logs to Azure Storage.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata Infrastructures tab.
  3. From the Name column, select your Exadata Infrastructure that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic settings, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to automatically mark all categories, or choose individual checkboxes for specific data categories to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges.
    3. From the Destination details dropdown list, select Archive to a storage account.
      1. Select your Subscription and Storage account from the dropdown list.
        Note

        If you do not have a Storage account, you must create one before you proceed. For more information, see Create an Azure storage account.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor Storage Account Logs

After creating diagnostic settings to send the metrics and logs of your Exadata Infrastructure to Azure Storage, you can monitor your logs in a Storage account.

  1. From the Azure portal, select Storage accounts.
  2. Select your storage account from the Name column, and then select the Containers link from the Data Storage section.
    Note

    From the Diagnostic settings page, copy your Storage account, and then navigate to the Storage accounts page. Enter your information into the Filter for any field field to filter the list.
  3. From the Containers page, you can see a list of containers under the Name column that have been automatically created for the logs and events categories you selected previously. Select the container, and then select the Download button to download and monitor your logs.

Create Diagnostic Settings for an Exadata Infrastructure and Send Logs to an Event Hub

Learn how to edit and create diagnostic settings for your Exadata Infrastructure to send events and logs to Azure Event Hubs.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata Infrastructures tab.
  3. From the Name column, select your Exadata Infrastructure that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to mark all the checkboxes for each data category you want to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges.
    3. From the Destination details dropdown list, select Stream to an event hub.
      1. Select your Subscription and Event hub namespace from the dropdown list.
        Note

        If you do not have an Event hub namespace, you must create one before you proceed. For more information, see Create an event hub using Azure portal.
      2. The Event hub name field is optional. If you do not select an event hub name, for each log category, an event hub will be created. For multiple categories, it is recommended to specify a name to limit the number of event hubs created. For more information, see Azure Event Hubs quotas and limits.
      3. The Event hub policy name is an optional field. For more information, see Event Hubs features.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor Event Hub Events

After creating diagnostic settings to send the metrics and logs of your Exadata Infrastructure to Event Hubs, you can monitor your events in Event Hub.

  1. From the Azure portal, select Event Hubs
  2. Select your event hub from the Name column, and then select the Data Explorer.
  3. From the Data Explorer page, complete the following substeps:
    1. From the Event Hub dropdown list, select your event hub.
    2. By default, the Partition ID field is set to All partition IDs.
    3. By default, the Consumer group field is set to $Default.
    4. Select your Event position. By default, this field is set to Oldest position.
    5. Select the View events button which populates all events. Select the event from the list, and then select the Event Body tab and Event properties to view the details of it.

Create Diagnostic Settings for an Exadata Infrastructure and Send Logs to an Log Analytics workspace

Learn how to edit and create diagnostic settings for your Exadata Infrastructure to send events and logs to Log Analytics workspace.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata Infrastructures tab.
  3. From the Name column, select your Exadata Infrastructure that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to automatically mark all categories, or choose individual checkboxes for specific data categories to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges. For more information, see Supported Resource log categories for Azure Monitor.
    3. From the Destination details dropdown list, select Send to Log Analytics workspace.
      1. Select your Subscription and Log Analytics workspace from the dropdown list.
        Note

        If you do not have an Log Analytics workspace, you must create one before you proceed. For more information, see Create a Log Analytics workspace.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor an Exadata Infrastructure Logs in Azure Monitor

The Log Analytics tool in the Azure portal allows you to run and edit log queries of data stored in Azure Monitor Logs.

Complete the following steps:

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata Infrastructures tab.
  3. From the Name column, select your Exadata Infrastructure that you are using.
  4. Expand the Monitoring section, select the Logs link.
  5. From the Logs list, select the Log Analytics workspace you previously created.
  6. From the Log Analytics workspace page, select Logs.
  7. From the Select a scope page, complete the following substeps:
    1. From the dropdown list, select your Resource group.
    2. From the dropdown list, select your Oracle Exadata Infrastructure as Resource types.
    3. From the Locations dropdown list, select your location.
    4. From the Scope list, select your Exadata Infrastructure(s) .
      Note

      You can select multiple Exadata Infrastructures.
    5. Review your selection, and then select the Apply button.
  8. From the Queries hub section, select the query that you want to use. Then, select the Run button to display the log results.

Create Diagnostic Settings for an Exadata Infrastructure and Send Logs to Partner Solutions (Dynatrace)

Learn how to edit and create diagnostic settings for your Exadata Infrastructure to send events and logs to Dynatrace.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata Infrastructures tab.
  3. From the Name column, select your Exadata Infrastructure that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to automatically mark all categories, or choose individual checkboxes for specific data categories to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges.
    3. From the Destination details dropdown list, select Send to partner solution.
      1. Select your Subscription and Destination from the dropdown list.
        Note

        If you do not have an instance for Dynatrace, you must create one before you proceed. For more information, see Get started with Dynatrace.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor an Exadata Infrastructure Logs in Dynatrace

Dynatrace in the Azure portal allows you to monitor your logs and events.

Complete the following steps:

  1. From the Azure portal, select Azure Native Dynatrace Service.
  2. From the list, select your resource to review the details of it.
  3. From the Overview page, navigate to Dynatrace environment, and then select the Go to Dynatrace link.
  4. From the Dynatrace page, navigate to Logs section, and then select it.
  5. The Logs section populates all logs of events that has been triggered. Select the log that you want to review details of it.

Monitor Exadata VM Cluster Logs and Events

Monitoring Exadata VM Cluster logs and events enables you to troubleshoot issues effectively, validate system health, and integrate with enterprise-wide observability platforms. This topic explains the required steps to monitor your Exadata VM Cluster logs and events from the Azure portal using Event Hubs, Storage Account, Log Analytics workspace and Azure Monitor partner solutions.

Prerequisites:

  1. You must create diagnostic settings.
    For the list of events for Exadata VM Cluster, see Exadata Cloud Infrastructure VM Cluster Event Types.
    Note

    The following event shown in the table is not supported. Logs of this event will not be displayed or exported to the destination.

    Table 1-3

    Name Event Type
    Cloud VM Cluster - Create Begin com.oraclecloud.databaseservice.createcloudvmcluster.begin
  2. You must create a storage account. For more information, see Create an Azure storage account.
  3. You must create an Azure Event Hubs namepace. For more information, see Create an event hub using Azure portal.
  4. You must create a Log Analytics workspace. For more information, see Create a Log Analytics workspace.
  5. You must create a new instance for Dynatrace. For more information, see Get started with Dynatrace.
  6. You must enable SSO log-in using Azure portal before creating any Dynatrace resource in Azure. For more information, see Configure pre-deployment.

Create Diagnostic Settings for an Exadata VM Cluster and Send Logs to a Storage Account

Learn how to edit and create diagnostic settings for your Exadata VM Cluster to send metrics and logs to Azure Storage.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata VM Clusters tab.
  3. From the Name column, select your Exadata VM Cluster that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to automatically mark all categories, or choose individual checkboxes for specific data categories to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges.
    3. From the Destination details dropdown list, select Archive to a storage account.
      1. Select your Subscription and Storage account from the dropdown list.
        Note

        If you do not have a Storage account, you must create one before you proceed. For more information, see Create an Azure storage account.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor Storage Account Logs

After creating diagnostic settings to send the metrics and logs of your Exadata VM Cluster to Azure Storage, you can monitor your logs in a Storage account.

  1. Select Storage accounts from the Azure portal.
  2. Select your storage account from the Name column, and then select the Containers link from the Data Storage section.
  3. From the Containers page, you can see a list of items under the Name column. The folder contains the logs of your chosen event. Select the Download button to monitor your logs.

Create Diagnostic Settings for an Exadata VM Cluster and Send Logs to an Event Hub

Learn how to edit and create diagnostic settings for your Exadata VM Cluster to send metrics and logs to Azure Event Hubs.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata VM Clusters tab.
  3. From the Name column, select your Exadata VM Cluster that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to mark all the checkboxes for each data category you want to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges.
    3. From the Destination details dropdown list, select Stream to an event hub.
      1. Select your Subscription and Event hub namespace from the dropdown list.
        Note

        If you do not have an Event hub namespace, you must create one before you proceed. For more information, see Create an event hub using Azure portal.
      2. The Event hub name field is optional. If you do not select an event hub name, for each log category, an event hub will be created. For multiple categories, it is recommended to specify a name to limit the number of event hubs created. For more information, see Azure Event Hubs quotas and limits.
      3. The Event hub policy name is an optional field. For more information, see Event Hubs features.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor Event Hub Events

After creating diagnostic settings to send the metrics and logs of your Exadata VM Cluster to Event Hubs, you can monitor your events in Event Hub.

  1. Select Event Hubs from the Azure portal.
  2. Select your event hub from the Name column, and then select the Data Explorer.
  3. From the Data Explorer page, complete the following substeps:
    1. From the Event Hub dropdown list, select your event hub.
    2. By default, the Partition ID field is set to All partition IDs.
    3. By default, the Consumer group field is set to $Default.
    4. Select your Event position. By default, this field is set to Oldest position.
    5. Select the View events button which populates all events. Select the event from the list , and then select the Event Body tab and Event properties to view the details of it.

Create Diagnostic Settings for an Exadata VM Cluster and Send Logs to an Log Analytics workspace

Learn how to edit and create diagnostic settings for your Exadata VM Cluster to send metrics and logs to Log Analytics workspace.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service, and then select the Oracle Exadata VM Clusters tab.
  3. From the Name column, select your Exadata VM Cluster that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to automatically mark all categories, or choose individual checkboxes for specific data categories to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges. For more information, see Supported Resource log categories for Azure Monitor.
    3. From the Destination details dropdown list, select Send to Log Analytics workspace.
      1. Select your Subscription and Log Analytics workspace from the dropdown list.
        Note

        If you do not have an Log Analytics workspace, you must create one before you proceed. For more information, see Create a Log Analytics workspace.
      2. The Destination table field has two options. These options are Azure diagnostics and Resource specific. Select the destination where resource data is stored. For more information, see Destinations.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor an Exadata VM Cluster Logs in Azure Monitor

The Log Analytics tool in the Azure portal allows you to run and edit log queries of data stored in Azure Monitor Logs.

Complete the following steps:

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service and then select the Oracle Exadata VM Clusters tab.
  3. From the Name column, select your Exadata VM Cluster that you are using.
  4. Expand the Monitoring section, select the Logs link.
  5. From the Logs list, select the Log Analytics workspace you previously created.
  6. From the Log Analytics workspace page, select Logs.
  7. From the Select a scope page, complete the following substeps:
    1. From the dropdown list, select your Resource group.
    2. From the dropdown list, select your Oracle Exadata VM Cluster as Resource types.
    3. From the Locations dropdown list, select your location.
    4. From the Scope list, select your Exadata VM Cluster(s) .
      Note

      You can select multiple Exadata VM Clusters.
    5. Review your selection, and then select the Apply button.
  8. From the Queries hub section, select the query that you want to use. Then, select the Run button to display the log results.

Create Diagnostic Settings for an Exadata VM Cluster and Send Logs to Partner Solutions (Dynatrace)

Learn how to edit and create diagnostic settings for your Exadata VM Cluster to send events and logs to Dynatrace.

  1. From the Azure portal, select Oracle Database@Azure.
  2. From the resource menu, select Oracle Exadata Database Service and then select the Oracle Exadata VM Clusters tab.
  3. From the Name column, select your Exadata VM Cluster that you are using.
  4. Expand the Monitoring section, and then select Diagnostic settings located within it.
  5. If you want to create diagnostic setting, select the + Add diagnostic setting button, and then complete the following substeps from the Diagnostic setting page:
    1. Enter a name in the Diagnostic setting name field.
    2. From the Logs section, select your Category groups. Select the audit checkbox to automatically mark all categories, or choose individual checkboxes for specific data categories to send to the destinations.
      Note

      Category groups consist of different logs that support different monitoring goals. These groups are defined dynamically and Microsoft may add or remove categories as the product evolves, resulting in new charges.
    3. From the Destination details dropdown list, select Send to partner solution.
      1. Select your Subscription and Destination from the dropdown list.
        Note

        If you do not have an instance for Dynatrace, you must create one before you proceed. For more information, see Get started with Dynatrace.
    4. Review your information and then select the Save button.
  6. If you have existing diagnostic settings on your resource, you will see a list of settings. Select the Edit setting link to edit your existing diagnostic settings. Once you complete the necessary changes, select the Save button.

Monitor an Exadata VM Cluster Logs in Dynatrace

Dynatrace in the Azure portal allows you to monitor your logs and events.

Complete the following steps:

  1. From the Azure portal, select Azure Native Dynatrace Service.
  2. From the list, select your resource to review the details of it.
  3. From the Overview page, navigate to Dynatrace environment, and then select the Go to Dynatrace link.
  4. From the Dynatrace page, navigate to Logs section, and then select it.
  5. The Logs section populates all logs of events that has been triggered. Select the log that you want to review details of it.