Oracle Cloud Infrastructure Documentation

Oracle Exadata Database Service on Cloud@Customer Events

Oracle Exadata Database Service on Cloud@Customer resources emit events, which are structured messages that indicate changes in resources.

Parent topic: Reference Guides for Oracle Exadata Database Service on Cloud@Customer

About Event Types on Oracle Exadata Database Service on Cloud@Customer

Learn about the event types available for Oracle Exadata Database Service on Cloud@Customer resources.

Oracle Exadata Database Service on Cloud@Customer resources emit events, which are structured messages that indicate changes in resources. For more information about Oracle Cloud Infrastructure Events, see Overview of Events. You may subscribe to events and be notified when they occur using the Oracle Notification service, see Notifications Overview.

Exadata Infrastructure Event Types

Review the list of event types that Exadata Infrastructure instances emit.

Table 7-2 Exadata Infrastructure Event Types

Friendly Name Event Type

Activate Begin

com.oraclecloud.databaseservice.activateexadatainfrastructure.begin

Activate End

com.oraclecloud.databaseservice.activateexadatainfrastructure.end

Change Compartment

com.oraclecloud.databaseservice.changeexadatainfrastructurecompartment

Configuration File Download

com.oraclecloud.databaseservice.downloadexadatainfrastructureconfigfile

Create Begin

com.oraclecloud.databaseservice.createexadatainfrastructure.begin

Create End

com.oraclecloud.databaseservice.createexadatainfrastructure.end

Delete Begin

com.oraclecloud.databaseservice.deleteexadatainfrastructure.begin

Delete End

com.oraclecloud.databaseservice.deleteexadatainfrastructure.end

Update Begin

com.oraclecloud.databaseservice.updateexadatainfrastructure.begin

Update End

com.oraclecloud.databaseservice.updateexadatainfrastructure.end

Exadata Infrastructure - Connectivity Status

com.oraclecloud.databaseservice.exadatainfrastructureconnectstatus

Example 7-59 Exadata Infrastructure Example

This is a reference event for Exadata Infrastructure instances:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createexadatainfrastructure.begin",
    "source": "databaseservice",
    "eventTypeVersion": "version",
    "eventTime": "2019-08-29T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_exadata_infra",
      "resourceId": "ExadataInfra-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "shape": "ExadataCC.Base3.48",
        "timeZone": "US/Pacific",
        "displayName": "testDisplayName"
      }
    }
  }
This is a reference event for Exadata Infrastructure - Connectivity Status:
{
  "eventType" : "com.oraclecloud.databaseservice.exadatainfrastructureconnectstatus",
  "cloudEventsVersion" : "0.1",
  "eventTypeVersion" : "2.0",
  "source" : "DatabaseService",
  "eventTime" : "2020-06-02T06:07:40.141Z",
  "contentType" : "application/json",
  "data" : {
    "compartmentId" : "ocid1.compartment.oc1..aaaaaaaayrygl4guhplo5rtiumx3eh4mk7grrkrqspzaltmvbxecnbvhkrga",
    "compartmentName" : "DBaaSInteg20160918ExaccTest",
    "resourceName" : "MVM_HR",
    "resourceId" : "ocid1.exadatainfrastructure.oc1.ap-hyderabad-1.abuhsljrp2vzzenmqmctqciwro6euhhsmlrewiiemiktov5xyfsu5hiufjsq",
    "availabilityDomain" : "",
    "additionalDetails" : {
      "timeCreated" : "2020-05-28T00:23:18Z",
      "timeUpdated" : "2020-06-02T06:07:40Z",
      "lifecycleState" : "DISCONNECTED",
      "lifecycleDetails" : "Exadata Infrastructure is not reachable. Please lodge a Service Request (SR) with Oracle Support and provide Infrastructure-id: ocid1.exadatainfrastructure.oc1.ap-hyderabad-1.abuhsljrp2vzzenmqmctqciwro6euhhsmlrewiiemiktov5xyfsu5hiufjsq.",
      "shape" : "ExadataCC.Half3.200",
      "timeZone" : "UTC"
    },
    "definedTags" : {
      "Oracle-Tags" : {
        "CreatedBy" : "test-user@example.com",
        "CreatedOn" : "2020-05-28T00:23:18.291Z"
      }
    }
  },
  "eventID" : "cde92d45-a06b-4b69-a125-6005dd8c2f0c",
  "extensions" : {
    "compartmentId" : "ocid1.compartment.oc1..aaaaaaaayrygl4guhplo5rtiumx3eh4mk7grrkrqspzaltmvbxecnbvhkrga"
  }
}

VM Cluster Network Event Types

Review the list of event types that VM cluster networks emit.

Table 7-3 VM Cluster Network Event Types

Friendly Name Event Type

Create Begin

com.oraclecloud.databaseservice.createvmclusternetwork.begin

Create End

com.oraclecloud.databaseservice.createvmclusternetwork.end

Network Validation File Download

com.oraclecloud.databaseservice.downloadvmclusternetworkconfigfile

Terminate Begin

com.oraclecloud.databaseservice.deletevmclusternetwork.begin

Terminate End

com.oraclecloud.databaseservice.deletevmclusternetwork.end

Update Begin

com.oraclecloud.databaseservice.createvmclusternetwork.begin

Update End

com.oraclecloud.databaseservice.createvmclusternetwork.end

Validate Begin

com.oraclecloud.databaseservice.validatevmclusternetwork.begin

Validate End

com.oraclecloud.databaseservice.validatevmclusternetwork.end

Example 7-60 VM Cluster Network Example

This is a reference event for VM cluster networks:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createvmclusternetwork.begin",
    "source": "databaseservice",
    "eventTypeVersion": "version",
    "eventTime": "2019-08-29T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_vmcluster_network",
      "resourceId": "VmClusterNetwork-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExadataInfra-unique_ID",
        "displayName": "testDisplayName"
      }
    }
  }

VM Cluster Event Types

Review the list of event types that VM clusters emit.

Table 7-4 VM Cluster Event Types

Friendly Name Event Type

Change Compartment

com.oraclecloud.databaseservice.changevmclustercompartment

Create Begin

com.oraclecloud.databaseservice.createvmcluster.begin

Create End

com.oraclecloud.databaseservice.createvmcluster.end

Terminate Begin

com.oraclecloud.databaseservice.deletevmcluster.begin

Terminate End

com.oraclecloud.databaseservice.deletevmcluster.end

Update Begin

com.oraclecloud.databaseservice.updatevmcluster.begin

Update End

com.oraclecloud.databaseservice.updatevmcluster.end

Example 7-61 VM Cluster Example

This is a reference event for VM clusters:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createvmclusternetwork.begin",
    "source": "databaseservice",
    "eventTypeVersion": "version",
    "eventTime": "2019-08-29T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_vmcluster_network",
      "resourceId": "VmClusterNetwork-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExadataInfra-unique_ID",
        "displayName": "testDisplayName"
      }
    }
  }

This is a reference event for VM Cluster Create Begin:

{
  "cloudEventsVersion": "0.1",
  "eventId": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.createvmcluster.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "Vmcluster-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-09-03T12:00:00.000Z",
      "timeUpdated": "2019-09-03T12:30:00.000Z",
      "displayName": "testDisplayName",
      "lifecycleDetails": "detail message",
      "exadataInfrastructureId": "ExatraInfra-unique_ID",
      "vmClusterNetworkId": "VmCluster-unique_ID",
      "cpuCoreCount": 2,
      "dataStorageSizeInTBs": 4,
      "dbVersion": "19.0.0.0",
      "licenseType": "BRING_YOUR_OWN_LICENSE",
      "giVersion": "19.0.0.0",
      "dbNodeIds": "[ocid1.dbnode.1, ocid1.dbnode.2,...]",
      "timeZone": "US/Pacific"
    }
  }
}

Backup Destination Event Types

Review the list of event types that backup destinations emit.

Table 7-5 Backup Destination Event Types

Friendly Name Event Type

Change Compartment

com.oraclecloud.databaseservice.changebackupdestinationcompartment

Create

com.oraclecloud.databaseservice.createbackupdestination

Terminate

com.oraclecloud.databaseservice.deletebackupdestination

Update

com.oraclecloud.databaseservice.updatebackupdestination

Example 7-62 Backup Destination Example

This is a reference event for backup destinations:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createbackupdestination",
    "source": "databaseservice",
    "eventTypeVersion": "version",
    "eventTime": "2019-08-29T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_backupdestination",
      "resourceId": "BackupDestination-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {}
    }
  }

Database Node Event Types (Oracle Exadata Database Service on Cloud@Customer)

Review the list of event types that database nodes emit.

Table 7-6 Database Node Event Types

Friendly Name Event Type

Update Begin

com.oraclecloud.databaseservice.dbnodeaction.begin

Update End

com.oraclecloud.databaseservice.dbnodeaction.end

Example 7-63 Database Node Example

This is a reference event for database nodes:
{
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.dbnodeaction.begin",
  "source": "databaseservice",
  "eventTypeVersion": "version",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_dbnode",
    "resourceId": "DbNode-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-08-26T12:00:00.000Z",
      "timeUpdated": "2019-08-26T12:30:00.000Z",
      "dbSystemId": "ocid1.dbsystem.oc1.phx.unique_ID",
      "lifecycleDetails": "detail message",
      "vmClusterId": "VmCluster-unique_ID",
      "dbHostId": "dbHost-unique_ID",
      "nodeNumber": 2,
      "powerAction": "HardReset",
      "hostName": "testHostName"
    }
  }
}

Database Home Event Types (Oracle Exadata Database Service on Cloud@Customer)

Review the list of event types that Database Homes emit.

Table 7-7 Database Home Event Types

Friendly Name Event Type

Create Begin

com.oraclecloud.databaseservice.createdbhome.begin

Create End

com.oraclecloud.databaseservice.createdbhome.end

Terminate Begin

com.oraclecloud.databaseservice.deletedbhome.begin

Terminate End

com.oraclecloud.databaseservice.deletedbhome.end

Update Begin

com.oraclecloud.databaseservice.updatedbhome.begin

Update End

com.oraclecloud.databaseservice.updatedbhome.end

Example 7-64 Database Home Example

This is a reference event for Database Homes:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createdbhome.begin",
    "source": "databaseservice",
    "eventTypeVersion": "version",
    "eventTime": "2019-08-29T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_dbhome",
      "resourceId": "DbHome-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbSystemId": "DbSystem-unique_ID",
        "dbVersion": "19.0.0.0",
        "recordVersion": 4,
        "displayName": "testDisplayName"
      }
    }
  }

Database Event Types (Oracle Exadata Database Service on Cloud@Customer)

Review the list of event types that databases emit.

Table 7-8 Database Event Types

Friendly Name Event Type

Create Begin

com.oraclecloud.databaseservice.createdatabase.begin

Create End

com.oraclecloud.databaseservice.createdatabase.end

Delete Backup Begin

com.oraclecloud.databaseservice.deletebackup.begin

Delete Backup End

com.oraclecloud.databaseservice.deletebackup.end

Restore Begin

com.oraclecloud.databaseservice.restoredatabase.begin

Restore End

com.oraclecloud.databaseservice.restoredatabase.end

Terminate Begin

com.oraclecloud.databaseservice.deletedatabase.begin

Terminate End

com.oraclecloud.databaseservice.deletedatabase.end

Update Begin

com.oraclecloud.databaseservice.updatedatabase.begin

Update End

com.oraclecloud.databaseservice.updatedatabase.end

Example 7-65 Database Example

This is a reference event for databases:
{
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.restoredatabase.begin",
  "source": "databaseservice",
  "eventTypeVersion": "version",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "Database-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-08-26T12:00:00.000Z",
      "timeUpdated": "2019-08-26T12:30:00.000Z",
      "dbSystemId": "dbSystem-unique_ID",
      "displayName": "testDisplayName",
      "lifecycleDetails": "detail message",
      "vmClusterId": "VmCluster-unique_ID",
      "backupType": "FULL",
      "dbHomeId": "dbHome-unique_ID",
      "dbVersion": "19.0.0.0",
      "databaseEdition": "ENTERPRISE_EDITION_EXTREME",
      "autoBackupsEnabled": "true",
      "recoveryWindow": 30,
      "backupDestinationId": "backupDestination-unique_ID",
      "backupDestinationType": "OBJECT_STORAGE",
      "backupDestinationName": "my_backup_destination_name",
      "exadataInfrastructureId": "ExadataInfrastructure-unique_ID",
      "dbUniqueName": "akv_tgh_unqna"
    }
  }
}

Database and Grid Infrastructure Patching Event Types

Review the list of event types that Database and Grid Infrastructure Patching emit.

Table 7-9 Database and Grid Infrastructure Patching Events

Friendly Name Event Type

VM Cluster - Patch Begin

com.oraclecloud.databaseservice.patchvmcluster.begin

VM Cluster - Patch End

com.oraclecloud.databaseservice.patchvmcluster.end

DB Home - Patch Begin

com.oraclecloud.databaseservice.patchdbhome.begin

DB Home - Patch End

com.oraclecloud.databaseservice.patchdbhome.end

Database - Move Begin

com.oraclecloud.databaseservice.movedatabase.end

Database - Move End

com.oraclecloud.databaseservice.movedatabase.end

Example 7-66 Database Example

This is a reference event for VM Cluster - Patch Begin:
{
    "cloudEventsVersion": "0.1",
    "eventId": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.patchvmcluster.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_database",
      "resourceId": "Vmcluster-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-09-03T12:00:00.000Z",
        "timeUpdated": "2019-09-03T12:30:00.000Z",
        "displayName": "testDisplayName",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExatraInfra-unique_ID",
        "vmClusterNetworkId": "VmCluster-unique_ID",
        "cpuCoreCount": 2,
        "dataStorageSizeInTBs": 4,
        "dbVersion": "19.0.0.0",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "giVersion": "19.0.0.0",
        "dbNodeIds": "[ocid1.dbnode.1, ocid1.dbnode.2,...]",
        "timeZone": "US/Pacific"
      }
    }
  }
This is a reference event for DB Home - Patch Begin:
{
    "cloudEventsVersion": "0.1",
    "eventId": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.patchdbhome.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_dbhome",
      "resourceId": "DbHome-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbSystemId": "DbSystem-unique_ID",
        "dbVersion": "19.0.0.0",
        "recordVersion": 4,
        "displayName": "testDisplayName"
      }
    }
  }
This is a reference event for Database - Move Begin:
{
    "cloudEventsVersion": "0.1",
    "eventId": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.movedatabase.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_database",
      "resourceId": "Database-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-08-26T12:00:00.000Z",
        "timeUpdated": "2019-08-26T12:30:00.000Z",
        "dbSystemId": "ocid1.dbsystem.oc1.phx.unique_ID",
        "displayName": "testDisplayName",
        "lifecycleDetails": "detail message",
        "vmClusterId": "VmCluster-unique_ID",
        "dbSystemId": "dbSystem-unique_ID",
        "backupType": "FULL",
        "dbHomeId": "dbHome-unique_ID",
        "dbVersion": "19.0.0.0",
        "databaseEdition": "ENTERPRISE_EDITION_EXTREME",
        "autoBackupsEnabled": "true",
        "recoveryWindow": 30,
        "backupDestinationId": "backupDestination-unique_ID",
        "backupDestinationType": "OBJECT_STORAGE",
        "backupDestinationName": "my_backup_destination_name",
        "exadataInfrastructureId": "ExadataInfrastructure-unique-ID",
        "dbUniqueName": "akv_tgh_unqna"
      }
    }
  }

Autonomous VM Cluster Event Types

Review the list of event types that Autonomous VM clusters emit.

Table 7-10 Autonomous VM Cluster Events

Friendly Name Event Type

Autonomous VM Cluster - Change Compartment

com.oraclecloud.databaseservice.changeautonomousvmclustercompartment

Autonomous VM Cluster - Create Begin

com.oraclecloud.databaseservice.createautonomousvmcluster.begin

Autonomous VM Cluster - Create End

com.oraclecloud.databaseservice.createautonomousvmcluster.end

Autonomous VM Cluster - Terminate Begin

com.oraclecloud.databaseservice.deleteautonomousvmcluster.begin

Autonomous VM Cluster - Terminate End

com.oraclecloud.databaseservice.deleteautonomousvmcluster.end

Autonomous VM Cluster - Update Begin

com.oraclecloud.databaseservice.updateautonomousvmcluster.begin

Autonomous VM Cluster - Update End

com.oraclecloud.databaseservice.updateautonomousvmcluster.end

Example 7-67 Autonomous VM Cluster Examples

This is a reference event for Autonomous VM Cluster - Change Compartment:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.changeautonomousvmclustercompartment",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-06-27T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_database",
      "resourceId": "AutonomousVmCluster-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-09-03T12:00:00.000Z",
        "timeUpdated": "2019-09-03T12:30:00.000Z",
        "displayName": "testDisplayName",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExatraInfra-unique_ID",
        "vmClusterNetworkId": "VmClusterNetwork-unique_ID",
        "cpuCoreCount": "2",
        "availableCpus": "1",
        "dataStorageSizeInTBs": "4",
        "availableDataStorageSizeInTBs": "1",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "timeZone": "US/Pacific"
      }
    }
  }
This is a reference event for Autonomous VM Cluster - Create Begin
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createautonomousvmcluster.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-06-27T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_database",
      "resourceId": "AutonomousVmCluster-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-09-03T12:00:00.000Z",
        "timeUpdated": "2019-09-03T12:30:00.000Z",
        "displayName": "testDisplayName",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExatraInfra-unique_ID",
        "vmClusterNetworkId": "VmClusterNetwork-unique_ID",
        "cpuCoreCount": "2",
        "availableCpus": "1",
        "dataStorageSizeInTBs": "4",
        "availableDataStorageSizeInTBs": "1",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "timeZone": "US/Pacific"
      }
    }
  }
This is a reference event for Autonomous VM Cluster - Terminate Begin
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.deleteautonomousvmcluster.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-06-27T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_database",
      "resourceId": "AutonomousVmCluster-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-09-03T12:00:00.000Z",
        "timeUpdated": "2019-09-03T12:30:00.000Z",
        "displayName": "testDisplayName",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExatraInfra-unique_ID",
        "vmClusterNetworkId": "VmClusterNetwork-unique_ID",
        "cpuCoreCount": "2",
        "availableCpus": "1",
        "dataStorageSizeInTBs": "4",
        "availableDataStorageSizeInTBs": "1",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "timeZone": "US/Pacific"
      }
    }
  }
This is a reference event for Autonomous VM Cluster - Update Begin
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.updateautonomousvmcluster.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-06-27T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_database",
      "resourceId": "AutonomousVmCluster-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2019-09-03T12:00:00.000Z",
        "timeUpdated": "2019-09-03T12:30:00.000Z",
        "displayName": "testDisplayName",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExatraInfra-unique_ID",
        "vmClusterNetworkId": "VmClusterNetwork-unique_ID",
        "cpuCoreCount": "2",
        "availableCpus": "1",
        "dataStorageSizeInTBs": "4",
        "availableDataStorageSizeInTBs": "1",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "timeZone": "US/Pacific"
      }
    }
  }

Autonomous Container Database Event Types

Review the list of event types that Autonomous Container Database emit.

Table 7-11 Autonomous Container Database Events

Friendly Name Event Type

Change Compartment

com.oraclecloud.databaseservice.changeautonomouscontainerdatabasecompartment

Create Backup Begin

com.oraclecloud.databaseservice.autonomous.container.database.backup.begin

Create Backup End

com.oraclecloud.databaseservice.autonomous.container.database.backup.end

Create Begin

com.oraclecloud.databaseservice.autonomous.container.database.instance.create.begin

Create End

com.oraclecloud.databaseservice.autonomous.container.database.instance.create.end

Maintenance Begin

com.oraclecloud.databaseservice.autonomous.container.database.maintenance.begin

Maintenance End

com.oraclecloud.databaseservice.autonomous.container.database.maintenance.end

Maintenance Reminder

com.oraclecloud.databaseservice.autonomous.container.database.maintenance.reminder

Maintenance Scheduled

com.oraclecloud.databaseservice.autonomous.container.database.maintenance.scheduled

Restart Begin

com.oraclecloud.databaseservice.restartautonomouscontainerdatabase.begin

Restart End

com.oraclecloud.databaseservice.restartautonomouscontainerdatabase.end

Restore Begin

com.oraclecloud.databaseservice.autonomous.container.database.restore.begin

Restore End

com.oraclecloud.databaseservice.autonomous.container.database.restore.end

Terminate Begin

com.oraclecloud.databaseservice.terminateautonomouscontainerdatabase.begin

Terminate End

com.oraclecloud.databaseservice.terminateautonomouscontainerdatabase.end

Update Begin

com.oraclecloud.databaseservice.autonomous.container.database.instance.update.begin

Update End

com.oraclecloud.databaseservice.autonomous.container.database.instance.update.begin

Example 7-68 Autonomous Container Database Examples

This is a reference event for create Autonomous Container Database:
{lifecycleState=AVAILABLE, 
autonomousVmClusterId=ocid1.autonomousvmcluster.oc1.sea.abzwkljrevsjcfuskw7mgi6ulzfg2epjjxhbnhwj63q7q3kzvuwg3djqnd2a,
displayName=CDB2-NFS, 
dbName=wqxtzzfn, 
dbUniqueName=wqxtzzfn_sea1td, 
freeTags={}, 
autonomousContainerDatabaseId=ocid1.autonomouscontainerdatabase.oc1.sea.abzwkljrxkuruqe3qzgw432adr5ug7ridmwi4ifvjlsahcdqdhbhzbf543xa, 
compartmentId=ocid1.compartment.region1..aaaaaaaass5x4witduxzgrs7qmzqk3m5kmoguve7urwploqef6763w3o42ta, 
timeUpdated=2020-06-15 21:52:24.085,
tenantId=ocid1.tenancy.region1..aaaaaaaagyw5okosjg54csr3u5qgaxvtjufz55537h44mjy2umiqur4z5w3a, 
timeCreated=2020-06-15 19:08:03.797,
id=ocid1.autonomouscontainerdatabase.oc1.sea.abzwkljrxkuruqe3qzgw432adr5ug7ridmwi4ifvjlsahcdqdhbhzbf543xa,
definedTags={}}

Autonomous Database Event Types

Review the list of event types that Autonomous Database emit.

Table 7-12 Autonomous Database Events

Friendly Name Event Type

Change Compartment Begin

com.oraclecloud.databaseservice.changeautonomousdatabasecompartment.begin

Change Compartment End

com.oraclecloud.databaseservice.changeautonomousdatabasecompartment.end

Create Backup Begin

com.oraclecloud.databaseservice.autonomous.database.backup.begin

Create Backup End

com.oraclecloud.databaseservice.autonomous.database.backup.end

Create Begin

com.oraclecloud.databaseservice.autonomous.database.instance.create.begin

Create End

com.oraclecloud.databaseservice.autonomous.database.instance.create.end

Restore Begin

com.oraclecloud.databaseservice.autonomous.database.restore.begin

Restore End

com.oraclecloud.databaseservice.autonomous.database.restore.end

Start Begin

com.oraclecloud.databaseservice.startautonomousdatabase.begin

Start End

com.oraclecloud.databaseservice.startautonomousdatabase.end

Stop Begin

com.oraclecloud.databaseservice.stopautonomousdatabase.begin

Stop End

com.oraclecloud.databaseservice.stopautonomousdatabase.end

Terminate Begin

com.oraclecloud.databaseservice.deleteautonomousdatabase.begin

Terminate End

com.oraclecloud.databaseservice.deleteautonomousdatabase.end

Update Begin

com.oraclecloud.databaseservice.updateautonomousdatabase.begin

Update End

com.oraclecloud.databaseservice.updateautonomousdatabase.end

Data Guard Event Types

Review the list of event types that Data Guard associations emit.

Table 7-13 Data Guard Association Events

Friendly Name Event Type

Data Guard Association - Create Begin

com.oraclecloud.databaseservice.createdataguardassociation.begin

Data Guard Association - Create End

com.oraclecloud.databaseservice.createdataguardassociation.end

Switchover Begin

com.oraclecloud.databaseservice.switchoverdataguardassociation.begin

Switchover End

com.oraclecloud.databaseservice.switchoverdataguardassociation.end

Failover Begin

com.oraclecloud.databaseservice.failoverdataguardassociation.begin

Failover End

com.oraclecloud.databaseservice.failoverdataguardassociation.end

Reinstate Begin

com.oraclecloud.databaseservice.reinstatedataguardassociation.begin

Reinstate End

com.oraclecloud.databaseservice.reinstatedataguardassociation.end

Example 7-69 Data Guard Associations Examples

This is a reference event for Data Guard Association - Create Begin:
{
    "eventId": "022a63a4-ff77-11e9-a0af-f45c89b1cb17",
    "eventTime": "2019-11-05T02:50:21.000Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.createdataguardassociation.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_id",
      "compartmentName": "example_name",
      "resourceName": "my_container_database",
      "resourceId": "ocid1.dataguard.oc1.phx.unique_id",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dataguard.oc1.phx.unique_id",
        "timeCreated": "2019-06-27T21:15:59.000Z",
        "timeUpdated": "2019-06-27T21:16:04.389Z",
        "lifecycleState": "ACTIVE",
        "lifecycleMessage": "",
        "dbSystemId": "ocid1.vmcluster.oc1.phx.unique_id",
        "DatabaseId": "ocid1.database.oc1.phx.unique_id",
        "DbHomeId": "ocid1.dbhome.oc1.phx.unique_id",
        "DGConfigId": "022a67c8-ff77-11e9-af6e-f45c89b1cb17",
        "DGConfigState": "SUCCESS",
        "LastSyncedTime": "2019-06-27T21:16:04.389Z",
        "ApplyLag": "2 hours",
        "SyncState": "SYNCED",
        "dcsDgUpdateTimestamp": "2019-06-27T21:16:04.389Z",
        "lastUpdatedIdentifier": "022a6912-ff77-11e9-9e77-f45c89b1cb17",
        "displayName": "Data Guard Association - Create Begin",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "workloadType": "Transaction Processing"
      }
    }
  }
This is a reference event for Data Guard Association - Create End:
{
    "eventId": "022aa7cc-ff77-11e9-90cd-f45c89b1cb17",
    "eventTime": "2019-11-05T02:50:21.000Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.createdataguardassociation.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_id",
      "compartmentName": "example_name",
      "resourceName": "my_container_database",
      "resourceId": "ocid1.dataguard.oc1.phx.unique_id",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dataguard.oc1.phx.unique_id",
        "timeCreated": "2019-06-27T21:15:59.000Z",
        "timeUpdated": "2019-06-27T21:16:04.389Z",
        "lifecycleState": "ACTIVE",
        "lifecycleMessage": "",
        "dbSystemId": "ocid1.vmcluster.oc1.phx.unique_id",
        "DatabaseId": "ocid1.database.oc1.phx.unique_id",
        "DbHomeId": "ocid1.dbhome.oc1.phx.unique_id",
        "DGConfigId": "022aab34-ff77-11e9-b89c-f45c89b1cb17",
        "DGConfigState": "SUCCESS",
        "LastSyncedTime": "2019-06-27T21:16:04.389Z",
        "ApplyLag": "2 hours",
        "SyncState": "SYNCED",
        "dcsDgUpdateTimestamp": "2019-06-27T21:16:04.389Z",
        "lastUpdatedIdentifier": "022aac10-ff77-11e9-8041-f45c89b1cb17",
        "displayName": "Data Guard Association - Create End",
        "licenseType": "BRING_YOUR_OWN_LICENSE",
        "workloadType": "Transaction Processing"
      }
    }
  }

Autonomous Data Guard Association Event Types

Review the list of event types that Autnomous Data Guard associations emit.

Table 7-14 Autonomous Data Guard Association Events

Friendly Name Event Type

Autonomous Data Guard Association - Create Autonomous Data Guard Begin

com.oraclecloud.DatabaseService.CreateAutonomousDataGuardAssociation.begin

Autonomous Data Guard Association - Create Autonomous Data Guard End

com.oraclecloud.DatabaseService.CreateAutonomousDataGuardAssociation.end

Autonomous Data Guard Association - Switchover Begin

com.oraclecloud.DatabaseService.SwitchoverAutonomousDataguardAssociation.begin

Autonomous Data Guard Association - Switchover End

com.oraclecloud.DatabaseService.SwitchoverAutonomousDataguardAssociation.end

Autonomous Data Guard Association - Failover Begin

com.oraclecloud.DatabaseService.FailoverAutonomousDataguardAssociation.begin

Autonomous Data Guard Association - Failover End

com.oraclecloud.DatabaseService.FailoverAutonomousDataguardAssociation.end

Autonomous Data Guard Association - Reinstate Begin

com.oraclecloud.DatabaseService.ReinstateAutonomousDataGuardAssociation.begin

Autonomous Data Guard Association - Reinstate End

com.oraclecloud.DatabaseService.ReinstateAutonomousDataGuardAssociation.end

Example 7-70 Autonomous Data Guard Associations Examples

This is a reference event for Autonomous Data Guard Association - Create Autonomous Data Guard Begin:
{
  "cloudEventsVersion": "0.1",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.DatabaseService.CreateAutonomousDataGuardAssociation.begin",
  "source": "databaseservice",
  "eventTypeVersion": "2.0",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "<unique_ID>", 
    "eventName"="CreateAutonomousDataGuardAssociation"
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "example_name",
    "resourceVersion":null,
    "resourceName": "my_container_database",
    "resourceId": "<unique_ID>",
    "availabilityDomain": "all",
    "tagSlug": "<slug_ID>",
    "definedTags": {},
    "additionalDetails": {
      "lifecycleState": "PROVISIONING",
      "DGConfigId"="91f298da-b890-42ce-935b-9b841e908756",
	  "ApplyLag"=null, 
	  "LastRoleChangeTime"=null, 
	  "TransportLag"=null,
	  "autonomousContainerDatabaseId"="ocid1.autonomouscontainerdatabase.oc1.sea.<unique_ID>", 
	  "DGConfigState"=null, 
	  "lifeCycleMessage"=null, 
	  "lastUpdatedIdentifier"=null, 
	  "SyncState"=null,
	  "autonomousExadataInfrastructureId"="ocid1.autonomousvmcluster.oc1.sea.<unique_ID>",
	  "timeUpdated"="2020-10-18 23:02:34.864", 
	  "timeCreated"="2020-10-18 23:02:34.864",
	  "dbHomeId"="ocid1.autonomouspodhome.oc1.sea.<unique_ID>", 
	  "LastSyncedTime"=null,
	  "dcsDgUpdateTimestamp"=null,
    }
  }
}
This is a reference event for Autonomous Data Guard Association - Switchover Begin:
{
  "cloudEventsVersion": "0.1",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.DatabaseService.CreateAutonomousDataGuardAssociation.begin",
  "source": "databaseservice",
  "eventTypeVersion": "2.0",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "<unique_ID>", 
    "eventName"="SwitchoverAutonomousDataguardAssociation"
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "example_name",
    "resourceVersion":null,
    "resourceName": "my_container_database",
    "resourceId": "ocid1.autonomousdgassociation.oc1.sea.<unique_ID>",
    "availabilityDomain": "all",
    "tagSlug": "<slug_ID>",
    "definedTags": {},
    "stateChange": {
    	"previous"=null, 
    	"current: {
    		"lifecycleState"="ROLE_CHANGE_IN_PROGRESS
    	}
    }
    "additionalDetails": {
      "lifecycleState": "ROLE_CHANGE_IN_PROGRESS",
      "DGConfigId"="<unique_ID>",
	  "ApplyLag"="0 seconds computed 2 seconds ago", 
	  "LastRoleChangeTime"=null, 
	  "TransportLag"="0 seconds computed 2 seconds ago",
	  "autonomousContainerDatabaseId"="ocid1.autonomouscontainerdatabase.oc1.sea.<unique_ID>", 
	  "DGConfigState"="SUCCESS", 
	  "lifeCycleMessage"=null, 
	  "lastUpdatedIdentifier"=null, 
	  "SyncState"="SYNCED",
	  "autonomousExadataInfrastructureId"="ocid1.autonomousvmcluster.oc1.sea.<unique_ID>",
	  "timeUpdated"="2020-10-18 23:02:34.864", 
	  "timeCreated"="2020-10-18 23:02:34.864",
	  "dbHomeId"="ocid1.autonomouspodhome.oc1.sea.<unique_ID>", 
	  "LastSyncedTime"=null,
	  "dcsDgUpdateTimestamp"=null,
    }
  }
}
This is a reference event for Autonomous Data Guard Association - Failover Begin:
{
  "cloudEventsVersion": "0.1",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.DatabaseService.CreateAutonomousDataGuardAssociation.begin",
  "source": "databaseservice",
  "eventTypeVersion": "2.0",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "<unique_ID>", 
    "eventName"="FailoverAutonomousDataguardAssociation"
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "example_name",
    "resourceVersion":null,
    "resourceName": "my_container_database",
    "resourceId": "ocid1.autonomousdgassociation.oc1.sea.<unique_ID>",
    "availabilityDomain": "all",
    "tagSlug": "<slug_ID>",
    "definedTags": {},
    "stateChange": {
    	"previous"=null, 
    	"current: {
    		"lifecycleState"="ROLE_CHANGE_IN_PROGRESS
    	}
    }
    "additionalDetails": {
      "lifecycleState": "ROLE_CHANGE_IN_PROGRESS",
      "DGConfigId"="<unique_ID>",
	  "ApplyLag"="0 seconds computed 2 seconds ago", 
	  "LastRoleChangeTime"=null, 
	  "TransportLag"="0 seconds computed 2 seconds ago",
	  "autonomousContainerDatabaseId"="ocid1.autonomouscontainerdatabase.oc1.sea.<unique_ID>", 
	  "DGConfigState"="SUCCESS", 
	  "lifeCycleMessage"=null, 
	  "lastUpdatedIdentifier"=null, 
	  "SyncState"="SYNCED",
	  "autonomousExadataInfrastructureId"="ocid1.autonomousvmcluster.oc1.sea.<unique_ID>",
	  "timeUpdated"="2020-10-18 23:02:34.864", 
	  "timeCreated"="2020-10-18 23:02:34.864",
	  "dbHomeId"="ocid1.autonomouspodhome.oc1.sea.<unique_ID>", 
	  "LastSyncedTime"=null,
	  "dcsDgUpdateTimestamp"=null,
    }
  }
}
This is a reference event for Autonomous Data Guard Association - Reinstate Begin:
{
  "cloudEventsVersion": "0.1",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.DatabaseService.CreateAutonomousDataGuardAssociation.begin",
  "source": "databaseservice",
  "eventTypeVersion": "2.0",
  "eventTime": "2019-06-27T21:16:04Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "<unique_ID>", 
    "eventName"="ReinstateAutonomousDataGuardAssociation"
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "example_name",
    "resourceVersion":null,
    "resourceName": "my_container_database",
    "resourceId": "ocid1.autonomousdgassociation.oc1.sea.<unique_ID>",
    "availabilityDomain": "all",
    "tagSlug": "<slug_ID>",
    "definedTags": {},
    "stateChange": {
    	"previous"=null, 
    	"current: {
    		"lifecycleState"="ROLE_CHANGE_IN_PROGRESS
    	}
    }
    "additionalDetails": {
      "lifecycleState": "ROLE_CHANGE_IN_PROGRESS",
      "DGConfigId"="<unique_ID>",
	  "ApplyLag"="0 seconds computed 2 seconds ago", 
	  "LastRoleChangeTime"=null, 
	  "TransportLag"="0 seconds computed 2 seconds ago",
	  "autonomousContainerDatabaseId"="ocid1.autonomouscontainerdatabase.oc1.sea.<unique_ID>", 
	  "DGConfigState"="SUCCESS", 
	  "lifeCycleMessage"=null, 
	  "lastUpdatedIdentifier"=null, 
	  "SyncState"="SYNCED",
	  "autonomousExadataInfrastructureId"="ocid1.autonomousvmcluster.oc1.sea.<unique_ID>",
	  "timeUpdated"="2020-10-18 23:02:34.864", 
	  "timeCreated"="2020-10-18 23:02:34.864",
	  "dbHomeId"="ocid1.autonomouspodhome.oc1.sea.<unique_ID>", 
	  "LastSyncedTime"=null,
	  "dcsDgUpdateTimestamp"=null,
    }
  }
}

Key Store Event Types

Review the list of event types that Key Store emits.

Table 7-15 Key Store Events

Friendly Name Event Type

Key Store - Create

com.oraclecloud.databaseservice.createkeystore

Key Store - Update

com.oraclecloud.databaseservice.updatekeystore

Key Store - Terminate

com.oraclecloud.databaseservice.deletekeystore

Key Store - Change Compartment

com.oraclecloud.databaseservice.changekeystorecompartment

Autonomous Container Database - Rotate Key Begin

com.oraclecloud.databaseservice.rotatekeyautonomouscontainerdatabase.begin

Autonomous Container Database - Rotate Key End

com.oraclecloud.databaseservice.rotatekeyautonomouscontainerdatabase.end

Autonomous Database - Rotate Key Begin

com.oraclecloud.databaseservice.rotatekeyautonomousdatabase.begin

Autonomous Database - Rotate Key End

com.oraclecloud.databaseservice.rotatekeyautonomousdatabase.end

Example 7-71 Key Store Example

This is a reference event for Create Key Store:
{
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createkeystore",
    "source": "databaseservice",
    "eventTypeVersion": "version",
    "eventTime": "2020-10-27T21:16:04Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_keystore",
      "resourceId": "KeyStore-unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "timeUpdated"="2020-10-27 21:16:34.864",
        "timeCreated"="2020-10-27 21:16:34.864",
        "keyStoreType": "all",
        "connectionIps": "ip1,ip2",
        "adminUsername": "username",
      }
    }
  }

Exadata Infrastructure Maintenance Event Types

Review the list of event types that Exadata Infrastructure Maintenance emits.

Table 7-16 Exadata Cloud@Customer Infrastructure Maintenance Events

Friendly Name Event Type Event Message

Exadata Infrastructure - Maintenance Reminder

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancereminder

This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> part of Maintenance Run <mr-display-name>, OCID <mr-ocid> in approximately NO_OF_DAYS_LEFT days on SCHEDULE_TIME. The maintenance includes EA1, Full DB Server update for DB servers 1, 3, rolling, without custom action time. EA2, Full server update for DB server 2,4, non-rolling with 30 minutes custom action time between server selected per the scheduling plan.

You will get a notification on the start of the quarterly maintenance update.

Exadata Infrastructure - Maintenance Begin

com.oraclecloud.databaseservice.exaccinfrastructuremaintenance.begin

This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> part of Maintenance Run <mr-display-name>, OCID <mr-ocid>. Your maintenance update started at <start-time>.

You will get a notification on the completion of the quarterly maintenance update.

Exadata Infrastructure - Maintenance End

com.oraclecloud.databaseservice.exaccinfrastructuremaintenance.end

Success: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> part of Maintenance Run <mr-display-name>, OCID <mr-ocid>. Your maintenance update started at <start-time> and was completed successfully at <end-time>. You have successfully completed maintenance updates for this window.

Failed: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> part of Maintenance Run <mr-display-name>, OCID <mr-ocid>. Your maintenance update started at <start-time> and was failed to complete successfully as planned. Our operations team is evaluating the failure and will notify you of the next steps to complete the maintenance update for this quarter.

Canceled: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> part of Maintenance Run <mr-display-name>, OCID <mr-ocid>. Your maintenance update started at <start-time>. Your maintenance has been canceled as requested. And a new window will be created according to the time given.

Duration Exceeded: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> part of Maintenance Run <mr-display-name>, OCID <mr-ocid>. Your maintenance update started at <start-time>. Your window was configured for a WINDOW_DURATION duration.

Your maintenance is taking longer than the configured window duration. This window has duration enforcement enabled. Oracle automation will reschedule all updates that have not started to a future maintenance window. Please acknowledge the updates rescheduled to run in a future unplanned maintenance window created by Oracle.

Exadata Infrastructure - Maintenance Custom action time Begin (ROLLING)

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancecustomactiontime.begin

This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Server <db-server-name>, OCID <db-server-ocid>. Your custom action time started at <start-time>.

You will get a notification on the completion of the custom action time for the Database Server.

Exadata Infrastructure - Maintenance Custom action time End (ROLLING)

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancecustomactiontime.end

This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Server <db-server-name>, OCID <db-server-ocid>. Your custom action time started at <start-time> ended at <end-time>.

Exadata Infrastructure - Maintenance Custom action time Begin (NONROLLING)

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancecustomactiontime.begin

This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Servers <db-server-name>, OCID <dbserver-ocid> | <db-server-name>, OCID <dbserver-ocid>. Your custom action time started at <start-time>. You will get a notification on the completion of the custom action time for the Database Servers.

Exadata Infrastructure - Maintenance Custom action time End (NONROLLING)

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancecustomactiontime.end

This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Servers <db-server-name>, OCID <dbserver-ocid> | <db-server-name>, OCID <dbserver-ocid>. Your custom action time started at <start-time> ended at <end-time>.

Exadata Infrastructure - IB Switch maintenance Begin

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancenetworkswitches.begin

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Network Switches of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Network switches. Your maintenance update started at <start-time>. You will get a notification on the completion of the quarterly maintenance update for the Network Switches.

Exadata Infrastructure - IB Switch maintenance End

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancenetworkswitches.end

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Network Switches of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Network switches. Your maintenance update started at <start-time> and was completed successfully at <end-time>

Exadata Infrastructure - maintenance Storage servers Start

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancestorageservers.start

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Storage Servers of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Storage Server(s) count <cell-count>. Your maintenance update started at <start-time>.

You will get a notification on the completion of the quarterly maintenance update for the Storage Servers.

Exadata Infrastructure - maintenance Storage servers End

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancestorageservers.end

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Storage Servers of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Storage Server(s) count <cell-count>. Your maintenance update started at <start-time> and was completed successfully at <end-time>.

Exadata Infrastructure - maintenance Database Servers Rolling Start

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancedbservers.start

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Server <db-server-name>, OCID <db-server-ocid>. Your maintenance update started at <start-time>.

You will get a notification on the completion of the quarterly maintenance update for the Database Server.

Exadata Infrastructure - maintenance Database Servers Rolling End

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancedbservers.end

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Server <db-server-name>, OCID <db-server-ocid>. Your maintenance update started at <start-time> and was completed successfully at <end-time>.

Exadata Infrastructure - maintenance Database Servers Non Rolling Start

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancedbservers.start

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Servers <db-server-name>, OCID <dbserver-ocid> | <db-server-name>, OCID <dbserver-ocid>. Your maintenance update started at <start-time>.

You will get a notification on the completion of the quarterly maintenance update for the Database Servers.

Exadata Infrastructure - maintenance Database Servers Non Rolling End

com.oraclecloud.databaseservice.exaccinfrastructuremaintenancedbservers.end

This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure <infra-name>, OCID <infra-ocid> for Database Servers <db-server-name>, OCID <dbserver-ocid> | <db-server-name>, OCID <dbserver-ocid>. Your maintenance update started at <start-time> and was completed successfully at <end-time>.

Storage Expansion Event Types

Review the list of event types that storage expansion emits.

Table 7-17 Storage Expansion Events

Friendly Name Event Type

Exadata Infrastructure - Add Storage Capacity Begin

com.oraclecloud.databaseservice.addstoragecapacityexadatainfrastructure.begin

Exadata Infrastructure - Add Storage Capacity End

com.oraclecloud.databaseservice.addstoragecapacityexadatainfrastructure.end

Example 7-72 Storage Expansion Events Examples

This is a reference event for Exadata Infrastructure - Add Storage Capacity Begin:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.addstoragecapacityexadatainfrastructure.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_exadata_infra",
    "resourceId": "ExadataInfra-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "shape": "ExadataCC.X8",
      "timeZone": "US/Pacific",
      "displayName": "testDisplayName"
    }
  }
}
This is a reference event for Exadata Infrastructure - Add Storage Capacity End:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.addstoragecapacityexadatainfrastructure.end",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_exadata_infra",
    "resourceId": "ExadataInfra-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "shape": "ExadataCC.X8",
      "timeZone": "US/Pacific",
      "displayName": "testDisplayName"
    }
  }
}

Database Software Images Event Types

Review the list of event types that Database Software Image emits.

Table 7-18 Database Software Image Events

Action Event Name Event Type

Create Database Software Image

CreateDatabaseSoftwareImage

CreateDatabaseSoftwareImage

com.oraclecloud.DatabaseService.CreateDatabaseSoftwareImage.begin

com.oraclecloud.DatabaseService.CreateDatabaseSoftwareImage.end

Delete Database Software Image

DeleteDatabaseSoftwareImage

DeleteDatabaseSoftwareImage

com.oraclecloud.DatabaseService.DeleteDatabaseSoftwareImage.begin

com.oraclecloud.DatabaseService.DeleteDatabaseSoftwareImage.end

List Database Software Images

ListDatabaseSoftwareImages

com.oraclecloud.DatabaseService.ListDatabaseSoftwareImages

Get Database Software Image

GetDatabaseSoftwareImage

com.oraclecloud.DatabaseService.GetDatabaseSoftwareImage

Change compartment of Database Software Image

MoveDatabaseSoftwareImage

MoveDatabaseSoftwareImage

com.oraclecloud.DatabaseService.MoveDatabaseSoftwareImage.begin

com.oraclecloud.DatabaseService.MoveDatabaseSoftwareImage.end

Update Database Software Image

UpdateDatabaseSoftwareImage

com.oraclecloud.DatabaseService.UpdateDatabaseSoftwareImage

Example 7-73 Database Software Image Events Examples

This is a reference event for Create Database Software Image - Begin:
{
  "eventType": "com.oraclecloud.DatabaseService.CreateDatabaseSoftwareImage.begin",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "6dcad2c5-de0a-4e46-9a18-25c66f292dcf",
  "eventTime": "2021-06-18T04:04:35.451Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csid68e598ea4474b18860cdd476af4a/b46a0a70da064d57a149c3c49b7cc588/FB22262C016611EFC401A9292187861D",
    "eventName": "CreateDatabaseSoftwareImage",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DBImage_19c",
    "resourceId": "ocid1.databasesoftwareimage.oc1.sea.abzwkljsbpu3kxb54loym5sgkn2z4briz4xbokhouxywkir764ht4txx4nya",
    "availabilityDomain": "AD2",
    "freeformTags": null,
    "definedTags": null,
    "identity": {
      "principalName": "xxxx",
      "principalId": "ocid1.user.region1..aaaaaaaaedlsln4welqy3upwitxqrss3fnu6potqmds4xo3xld5sqyzwbveq",
      "authType": "natv",
      "callerName": null,
      "callerId": null,
      "tenantId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
      "ipAddress": "160.34.124.111",
      "credentials": ""
    },
    "request": {
      "id": "csid68e598ea4474b18860cdd476af4a/b46a0a70da064d57a149c3c49b7cc588/FB22262C016611EFC401A9292187861D",
      "path": "/20160918/databaseSoftwareImages",
      "action": "POST",
      "parameters": {},
      "headers": {}
    },
    "response": {
      "status": "200",
      "responseTime": "2021-06-18T04:04:36.457Z",
      "headers": {},
      "payload": null,
      "message": "CreateDatabaseSoftwareImage succeeded"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "displayName": "DBImage_19c",
        "lifecycleState": "PROVISIONING"
      }
    },
    "additionalDetails": {
      "dbVersion": "19.0.0.0",
      "displayName": "DBImage_19c",
      "lifecycleState": "PROVISIONING",
      "timeCreated": "2021-06-18T04:04:35.739Z"
    }
  }
}
This is a reference event for Create Database Software Image – End
{
  "eventType": "com.oraclecloud.DatabaseService.CreateDatabaseSoftwareImage.end",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "7bf14762-1ec7-4230-99d0-6323c5e8b3cb",
  "eventTime": "2021-06-18T04:26:24.119Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csid68e598ea4474b18860cdd476af4a/b46a0a70da064d57a149c3c49b7cc588/FB22262C016611EFC401A9292187861D",
    "eventName": "CreateDatabaseSoftwareImage",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DBImage_19c",
    "resourceId": "ocid1.databasesoftwareimage.oc1.sea.abzwkljsbpu3kxb54loym5sgkn2z4briz4xbokhouxywkir764ht4txx4nya",
    "availabilityDomain": null,
    "freeformTags": null,
    "definedTags": null,
    "identity": {
      "principalName": null,
      "principalId": null,
      "authType": null,
      "callerName": null,
      "callerId": null,
      "tenantId": null,
      "ipAddress": null,
      "credentials": null,
      "userAgent": null,
      "consoleSessionId": null
    },
    "request": {
      "id": "d2030b31-16aa-4e71-9b06-dabc7545ad65",
      "path": null,
      "action": null,
      "parameters": null,
      "headers": null
    },
    "response": {
      "status": null,
      "responseTime": "2021-06-18T04:26:24.119Z",
      "headers": null,
      "payload": null,
      "message": "CreateDatabaseSoftwareImage"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "displayName": "DBImage_19c",
        "lifecycleState": "AVAILABLE"
      }
    },
    "additionalDetails": {
      "dbVersion": "19.0.0.0",
      "displayName": "DBImage_19c",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2021-06-18T04:04:35.739Z"
    }
  }
}
This is a reference event for Delete Database Software Image – Start
{
  "eventType": "com.oraclecloud.DatabaseService.DeleteDatabaseSoftwareImage.begin",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "b789f327-ad93-45e1-a739-45fdb97c24d2",
  "eventTime": "2021-06-25T05:06:25.316Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csidd793a61a40689138814477fa5c6e/ffe9b65c8dcf425c9b30ae1a30ae5687/B7CA65C1DDBEDB55052051EF1113DB73",
    "eventName": "DeleteDatabaseSoftwareImage",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DBImage_202106152041",
    "resourceId": "ocid1.databasesoftwareimage.oc1.sea.abzwkljrzqt4tr326jtdmyudcziz6h5uhce36jbndxojgeg5kpwjcipxelga",
    "availabilityDomain": "AD2",
    "freeformTags": null,
    "definedTags": null,
    "identity": {
      "principalName": "xxx",
      "principalId": "ocid1.user.region1..aaaaaaaaedlsln4welqy3upwitxqrss3fnu6potqmds4xo3xld5sqyzwbveq",
      "authType": "natv",
      "callerName": null,
      "callerId": null,
      "tenantId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
      "ipAddress": "160.34.124.245",
      "credentials": ""
    },
    "request": {
      "id": "csidd793a61a40689138814477fa5c6e/ffe9b65c8dcf425c9b30ae1a30ae5687/B7CA65C1DDBEDB55052051EF1113DB73",
      "path": "/20160918/databaseSoftwareImages/ocid1.databasesoftwareimage.oc1.sea.abzwkljrzqt4tr326jtdmyudcziz6h5uhce36jbndxojgeg5kpwjcipxelga",
      "action": "DELETE",
      "parameters": {},
      "headers": {}
    },
    "response": {
      "status": "204",
      "responseTime": "2021-06-25T05:06:26.074Z",
      "headers": {},
      "payload": null,
      "message": "DeleteDatabaseSoftwareImage succeeded"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "displayName": "DBImage_202106152041",
        "lifecycleState": "AVAILABLE"
      }
    },
    "additionalDetails": {
     "dbVersion": "19.0.0.0",
      "displayName": "DBImage_202106152041",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2021-06-15T15:11:53.672Z"
    }
  }
}
This is a reference event for Delete Database Software Image – End
{
 "eventType": "com.oraclecloud.DatabaseService.DeleteDatabaseSoftwareImage.end",
 "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "6a1a808f-f5dd-4fb5-9d77-3bad38591998",
  "eventTime": "2021-06-25T05:07:21.454Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csidd793a61a40689138814477fa5c6e/ffe9b65c8dcf425c9b30ae1a30ae5687/B7CA65C1DDBEDB55052051EF1113DB73",
    "eventName": "DeleteDatabaseSoftwareImage",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DBImage_202106152041",
    "resourceId": "ocid1.databasesoftwareimage.oc1.sea.abzwkljrzqt4tr326jtdmyudcziz6h5uhce36jbndxojgeg5kpwjcipxelga",
    "availabilityDomain": null,
    "freeformTags": null,
    "definedTags": null,
    "identity": {
      "principalName": null,
      "principalId": null,
      "authType": null,
      "callerName": null,
      "callerId": null,
      "tenantId": null,
      "ipAddress": null,
      "credentials": null,
      "userAgent": null,
      "consoleSessionId": null
    },
    "request": {
      "id": "676465d5-e066-43e4-bb21-77dc468ce1f9",
      "path": null,
      "action": null,
      "parameters": null,
      "headers": null
    },
    "response": {
      "status": null,
      "responseTime": "2021-06-25T05:07:21.454Z",
      "headers": null,
      "payload": null,
      "message": "DeleteDatabaseSoftwareImage"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "displayName": "DBImage_202106152041",
        "lifecycleState": "TERMINATED"
      }
    },
    "additionalDetails": {
      "dbVersion": "19.0.0.0",
      "displayName": "DBImage_202106152041",
      "lifecycleState": "TERMINATED",
      "timeCreated": "2021-06-15T15:11:53.672Z"
    }
  }
}
This is a reference event for List Database Software Images
{
  "eventType": "com.oraclecloud.DatabaseService.ListDatabaseSoftwareImages",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "762072e3-52a0-437c-9956-334aad767db8",
  "eventTime": "2021-06-24T05:39:41.344Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": null,
    "eventName": "ListDatabaseSoftwareImages",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "",
    "resourceId": null,
    "availabilityDomain": "AD2",
    "freeformTags": null,
    "definedTags": null,
    "identity": {
      "principalName": "xxx",
      "principalId": "ocid1.user.region1..aaaaaaaaedlsln4welqy3upwitxqrss3fnu6potqmds4xo3xld5sqyzwbveq",
      "authType": "natv",
      "callerName": null,
      "callerId": null,
      "tenantId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
      "ipAddress": "160.34.125.213",
      "credentials": "",
      "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36",
      "consoleSessionId": "csidc25d57894f49986ae07157ab5e03"
    },
    "request": {
      "id": "csidc25d57894f49986ae07157ab5e03/dc74ad5a75d7494bb35408a33a99c0ad/084F718D53FBC66D46B573CF8D5D1A5A",
      "path": "/20160918/databaseSoftwareImages",
      "action": "GET",
      "parameters": {},
      "headers": {}
    },
    "response": {
      "status": "200",
      "responseTime": "2021-06-24T05:39:41.998Z",
      "headers": {},
      "payload": null,
      "message": "ListDatabaseSoftwareImages succeeded"
    },
    "stateChange": {
      "previous": null,
      "current": null
    },
    "additionalDetails": null
  }
}
This is a reference event for Get Database Software Image
{
  "eventType": "com.oraclecloud.DatabaseService.GetDatabaseSoftwareImage",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "179471f3-c628-4e55-98d0-959b0913b327",
  "eventTime": "2021-06-24T04:11:10.738Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csid31b4236f4f1ebc4ee66169d17b0a/1f2e5dbf57ca40c886b111616b02c33f/CA5B5AD4C8678E2C428DA9AF0C62A082",
    "eventName": "GetDatabaseSoftwareImage",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DBImage_19c",
    "resourceId": "ocid1.databasesoftwareimage.oc1.sea.abzwkljsbpu3kxb54loym5sgkn2z4briz4xbokhouxywkir764ht4txx4nya",
    "availabilityDomain": "AD2",
    "freeformTags": null,
    "definedTags": null,
    "identity": {
      "principalName": "xxx",
      "principalId": "ocid1.user.region1..aaaaaaaalkib75hbawg6xh6rlys5ztumfx3cxf2ktwbon5ryv6xjev7oectq",
      "authType": "natv",
      "callerName": null,
      "callerId": null,
      "tenantId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
      "ipAddress": "192.188.170.109",
      "credentials": "",
      "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.106 Safari/537.36",
      "consoleSessionId": "csid31b4236f4f1ebc4ee66169d17b0a"
    },
    "request": {
      "id": "csid31b4236f4f1ebc4ee66169d17b0a/1f2e5dbf57ca40c886b111616b02c33f/CA5B5AD4C8678E2C428DA9AF0C62A082",
      "path": "/20160918/databaseSoftwareImages/ ocid1.databasesoftwareimage.oc1.sea.abzwkljsbpu3kxb54loym5sgkn2z4briz4xbokhouxywkir764ht4txx4nya",
      "action": "GET",
      "parameters": {},
      "headers": {}
    },
    "response": {
      "status": "200",
      "responseTime": "2021-06-24T04:11:10.966Z",
      "headers": {},
      "payload": null,
      "message": "GetDatabaseSoftwareImage succeeded"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "displayName": "DBImage_19c",
        "lifecycleState": "AVAILABLE"
      }
    },
    "additionalDetails": {
      "dbVersion": "19.0.0.0",
      "displayName": "DBImage_19c",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2020-09-24T18:06:00.395Z"
    }
  }
}

Database Upgrade Event Types

Review the list of event types that Database Upgrade emit.

Table 7-19 Database Upgrade Events

Friendly Name Event Type

MoveDatabase

com.oraclecloud.DatabaseService.MoveDatabase.begin

com.oraclecloud.DatabaseService.MoveDatabase.end

UpgradeDatabase

com.oraclecloud.DatabaseService.UpgradeDatabase.begin

com.oraclecloud.DatabaseService.UpgradeDatabase.end

Example 7-74 Database Upgrade Examples

This is a reference event for Move Database Begin:
eventType": "com.oraclecloud.DatabaseService.MoveDatabase.begin"
"eventName": "MoveDatabase"
{
  "eventType": "com.oraclecloud.DatabaseService.MoveDatabase.begin",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "c78fb931-adda-4813-ab75-b9cc51b96847",
  "eventTime": "2021-07-15T11:03:52.582Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csidff49902144a1a3c98bd4e5f49c1c/37d3a7113f1e462fbd5a741dc5d52ef7/57472323A2FFABC31623FB7660F519AB",
    "eventName": "MoveDatabase",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DB211507",
    "resourceId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
    "availabilityDomain": "",
    "freeformTags": {},
    "definedTags": {
      "Operators": {
        "Created_By": "testuser@example.com",
        "Created_Time": "2021-07-15T11:01:24.085Z"
      }
    },
    "identity": {
      "principalName": null,
      "principalId": null,
      "authType": null,
      "callerName": null,
      "callerId": null,
      "tenantId": null,
      "ipAddress": null,
      "credentials": null,
      "userAgent": null,
      "consoleSessionId": null
    },
    "request": {
      "id": "8f7b5283-4896-4ce0-aefa-a4156971e07b",
      "path": null,
      "action": null,
      "parameters": null,
      "headers": null
    },
    "response": {
      "status": null,
      "responseTime": null,
      "headers": null,
      "payload": null,
      "message": "MoveDatabase"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "definedTags": {
          "Operators": {
            "Created_By": "testuser@example.com",
            "Created_Time": "2021-07-15T11:01:24.085Z"
          }
        },
        "displayName": "DB211507",
        "freeTags": {},
        "lifecycleState": "UPGRADING"
      }
    },
    "additionalDetails": {
      "databaseEdition": "ENTERPRISE_EDITION_EXTREME",
      "databaseId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
      "dbHomeId": "ocid1.dbhome.oc1.sea.abzwkljskjhqcc4bkzuai6kybx3hp3jznvxcgwlghqjnklpchrktcynwnloq",
      "dbUniqueName": "Audit_check",
      "dbVersion": "18.14.0.0",
      "exadataInfrastructureId": "ocid1.exadatainfrastructure.oc1.sea.abzwkljsqtwpumvorlttjuxcx6qtkxhuasvmyu4qy3bng74sqolpwjunsrqa",
      "lifecycleState": "UPGRADING",
      "timeCreated": "2021-07-15T11:01:24Z",
      "timeUpdated": "2021-07-15T11:02:34Z",
      "vmClusterId": "ocid1.vmcluster.oc1.sea.abzwkljsghfg7e3q3xh3gzqqxijt72fepczowmk35t554wxbpew7txnooprq"
    }
  }
}
This is a reference event for Move Database End:
eventType": "com.oraclecloud.DatabaseService.MoveDatabase.end"
"eventName": "MoveDatabase"

{
  "eventType": "com.oraclecloud.DatabaseService.MoveDatabase.end",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "97429610-9b8f-4da7-8f99-2f7cd5455c24",
  "eventTime": "2021-07-15T11:03:56.359Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csidff49902144a1a3c98bd4e5f49c1c/37d3a7113f1e462fbd5a741dc5d52ef7/57472323A2FFABC31623FB7660F519AB",
    "eventName": "MoveDatabase",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DB211507",
    "resourceId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
    "availabilityDomain": "",
    "freeformTags": {},
    "definedTags": {
      "Operators": {
        "Created_By": "testuser@example.com",
        "Created_Time": "2021-07-15T11:01:24.085Z"
      }
    },
    "identity": {
      "principalName": null,
      "principalId": null,
      "authType": null,
      "callerName": null,
      "callerId": null,
      "tenantId": null,
      "ipAddress": null,
      "credentials": null,
      "userAgent": null,
      "consoleSessionId": null
    },
    "request": {
      "id": "8f7b5283-4896-4ce0-aefa-a4156971e07b",
      "path": null,
      "action": null,
      "parameters": null,
      "headers": null
    },
    "response": {
      "status": null,
      "responseTime": null,
      "headers": null,
      "payload": null,
      "message": "MoveDatabase"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "definedTags": {
          "Operators": {
            "Created_By": "testuser@example.com",
            "Created_Time": "2021-07-15T11:01:24.085Z"
          }
        },
        "displayName": "DB211507",
        "freeTags": {},
        "lifecycleState": "AVAILABLE"
      }
    },
    "additionalDetails": {
      "databaseEdition": "ENTERPRISE_EDITION_EXTREME",
      "databaseId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
      "dbHomeId": "ocid1.dbhome.oc1.sea.abzwkljs7obwmwq2kgkjgeko4voudfcd5chu6iuonnew7uuxculsvdralzda",
      "dbUniqueName": "Audit_check",
      "dbVersion": "19.10.0.0",
      "exadataInfrastructureId": "ocid1.exadatainfrastructure.oc1.sea.abzwkljsqtwpumvorlttjuxcx6qtkxhuasvmyu4qy3bng74sqolpwjunsrqa",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2021-07-15T11:01:24Z",
      "timeUpdated": "2021-07-15T11:03:56Z",
      "vmClusterId": "ocid1.vmcluster.oc1.sea.abzwkljsghfg7e3q3xh3gzqqxijt72fepczowmk35t554wxbpew7txnooprq"
    }
  }
}
This is a reference event for Upgrade Database Begin:
eventType": " com.oraclecloud.DatabaseService.UpgradeDatabase.begin"
"eventName": " UpgradeDatabase"

{
  "eventType": "com.oraclecloud.DatabaseService.UpgradeDatabase.begin",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "96c66a03-fa53-4008-b86c-619b9f44ef31",
  "eventTime": "2021-07-15T11:02:33.948Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csidff49902144a1a3c98bd4e5f49c1c/37d3a7113f1e462fbd5a741dc5d52ef7/57472323A2FFABC31623FB7660F519AB",
    "eventName": "UpgradeDatabase",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DB211507",
    "resourceId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
    "availabilityDomain": "",
    "freeformTags": {},
    "definedTags": {
      "Operators": {
        "Created_By": "testuser@example.com",
        "Created_Time": "2021-07-15T11:01:24.085Z"
      }
    },
    "identity": {
      "principalName": "testuser@example.com",
      "principalId": "ocid1.user.region1..aaaaaaaac5dskxmhmemrbyhaeabru4kgpituqmvgxjcm5y22mlxre26om4zq",
      "authType": "natv",
      "callerName": null,
      "callerId": null,
      "tenantId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
      "ipAddress": "160.34.92.141",
      "credentials": "ST$eyJraWQiOiJhc3dfcmVnaW9uMV8yMDIxLTA1LTE0IiwiYWxnIjoiUlMyNTYifQ.eyJzdWIiOiJvY2lkMS51c2VyLnJlZ2lvbjEuLmFhYWFhYWFhYzVkc2t4bWhtZW1yYnloYWVhYnJ1NGtncGl0dXFtdmd4amNtNXkyMm1seHJlMjZvbTR6cSIsIm1mYV92ZXJpZmllZCI6ImZhbHNlIiwiaXNzIjoiYXV0aFNlcnZpY2Uub3JhY2xlLmNvbSIsInB0eXBlIjoidXNlciIsInNlc3NfZXhwIjoiRnJpLCAxNiBKdWwgMjAyMSAxMDo1OToxNyBVVEMiLCJhdWQiOiJvY2kiLCJwc3R5cGUiOiJuYXR2IiwidHR5cGUiOiJsb2dpbiIsImV4cCI6MTYyNjM1MDM1OSwiaWF0IjoxNjI2MzQ2NzU5LCJqdGkiOiJhNWE2YmRhNC02OGJkLTQ0ZjktODFlNS0yZGRiZGMyZWU4MTQiLCJ0ZW5hbnQiOiJvY2lkMS50ZW5hbmN5LnJlZ2lvbjEuLmFhYWFhYWFhZTM0Z3diZXozZGJvN3VydGNmNDYyd2ozbW5tYW5iYmE1eHFpbmN6Z20yejVkNjRjbmw1cSIsImp3ayI6IntcImtpZFwiOlwicHVia2V5LWU5Y2RmMWY4LTJjNTEtNGEyNi1hZjkyLTNlZjlkNTlhNWEzN1wiLFwiblwiOlwicjE1azFxR0s1MXJaVUZzLVdFNDFrU2ZLRWozanlndlZ2bG9pZVM5Y3RLODJ4QmxZT1F3SkZwX19HUXVGTFktWk45MVZabXdSQkpFeHJYbE1hNHV6aE5VS1BNQ3M5OG9XTENpQmo2UlVMekFLZHVtbHZlbHEwTUcwVmtMMjVXb1hONzU2N19wUUx3NDc0T2w2VzNJUl9Jd2tBVy1QZnF5QzdpY1NOekI2UXh2aGlVMXRpTUFUZ09RUjQ1Ty1md3NnVnl5WW14eVNCbm1sN1BDUEtoaGpBLTlFOFozeV94cnlPWFBuYjl1QlFrczZOblgzX08yRkZ1UGxualN5QXdlSEZLSzd6MUJNVVdONUMtLV9Uemw5T0VaOENMeGdKNkpzeUUtRUVMeEZEUkZ0MlVHZGNubUVBY2hNQ1gxNEtnWEFELVk5a2dkVS1HczNaUU1VTW5pYmFRXCIsXCJlXCI6XCJBUUFCXCIsXCJrdHlcIjpcIlJTQVwiLFwiYWxnXCI6XCJSUzI1NlwiLFwidXNlXCI6bnVsbH0ifQ.GGPB9TMU_CkqOfLNCgO2J6-QwvHEEaY6jky5T92PBoPOBUkXb_ruNOe6C8RwQhs2pmIsIBybTP7Ueene4cJ9nNKzsoTzNAUrSp9714Be2noQgqJL-ZtFIApThz1vXdfFWZtQQInxx-jALpsvkhvD_EVdbfx6FvlwDfm-ReNDSnrUoFkfx8NpIrkqP8KUFhnX-TRy0nUvqlaiB9C1L8FZGOJbBn0uiyloZe4DNP3Z39jViy37UntHeuMPnIqOYEsmPrSMTiJUBAypy4_I5irWuR0PpxfrttP6nlEi80V5YrmO3l2-ZJBRDKz8TdMkxclw3IT0qulTzFPqB3cXg45PGQ",
      "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Firefox/78.0",
      "consoleSessionId": "csidff49902144a1a3c98bd4e5f49c1c"
    },
    "request": {
      "id": "csidff49902144a1a3c98bd4e5f49c1c/37d3a7113f1e462fbd5a741dc5d52ef7/57472323A2FFABC31623FB7660F519AB",
      "path": "/20160918/databases/ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq/actions/upgrade",
      "action": "POST",
      "parameters": {},
      "headers": {}
    },
    "response": {
      "status": "200",
      "responseTime": "2021-07-15T11:02:36.072Z",
      "headers": {},
      "payload": null,
      "message": "UpgradeDatabase succeeded"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "definedTags": {
          "Operators": {
            "Created_By": "testuser@example.com",
            "Created_Time": "2021-07-15T11:01:24.085Z"
          }
        },
        "displayName": "DB211507",
        "freeTags": {},
        "lifecycleState": "UPGRADING"
      }
    },
    "additionalDetails": {
      "action": "UPGRADE",
      "currentDbVersion": "18.14.0.0",
      "lifecycleState": "IN_PROGRESS",
      "source": "DATABASE_HOME",
      "targetDbVersion": "19.10.0.0",
      "timeStarted": "2021-07-15T11:02:34Z",
      "upgradeHistoryEntryId": "ocid1.dbupgradehistory.oc1.sea.abzwkljstw7dymj6mfnaotkxpuie2bdxmlizqr5ie46dewcuzdh35md7fuhq"
    }
  }
}
This is a reference event for Upgrade Database End:
eventType": " com.oraclecloud.DatabaseService.UpgradeDatabase.end"
"eventName": " UpgradeDatabase"

{
  "eventType": "com.oraclecloud.DatabaseService.UpgradeDatabase.end",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "DatabaseService",
  "eventId": "e6c8a9e4-53b0-4bb8-be65-a39d157f04b2",
  "eventTime": "2021-07-15T11:03:56.028Z",
  "contentType": "application/json",
  "data": {
    "eventGroupingId": "csidff49902144a1a3c98bd4e5f49c1c/37d3a7113f1e462fbd5a741dc5d52ef7/57472323A2FFABC31623FB7660F519AB",
    "eventName": "UpgradeDatabase",
    "compartmentId": "ocid1.tenancy.region1..aaaaaaaae34gwbez3dbo7urtcf462wj3mnmanbba5xqinczgm2z5d64cnl5q",
    "compartmentName": "sic-dbaas",
    "resourceName": "DB211507",
    "resourceId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
    "availabilityDomain": "",
    "freeformTags": {},
    "definedTags": {
      "Operators": {
        "Created_By": "testuser@example.com",
        "Created_Time": "2021-07-15T11:01:24.085Z"
      }
    },
    "identity": {
      "principalName": null,
      "principalId": null,
      "authType": null,
      "callerName": null,
      "callerId": null,
      "tenantId": null,
      "ipAddress": null,
      "credentials": null,
      "userAgent": null,
      "consoleSessionId": null
    },
    "request": {
      "id": "8f7b5283-4896-4ce0-aefa-a4156971e07b",
      "path": null,
      "action": null,
      "parameters": null,
      "headers": null
    },
    "response": {
      "status": null,
      "responseTime": null,
      "headers": null,
      "payload": null,
      "message": "UpgradeDatabase"
    },
    "stateChange": {
      "previous": null,
      "current": {
        "definedTags": {
          "Operators": {
            "Created_By": "testuser@example.com",
            "Created_Time": "2021-07-15T11:01:24.085Z"
          }
        },
        "displayName": "DB211507",
        "freeTags": {},
        "lifecycleState": "AVAILABLE"
      }
    },
    "additionalDetails": {
      "databaseEdition": "ENTERPRISE_EDITION_EXTREME",
      "databaseId": "ocid1.database.oc1.sea.abzwkljs5xinda6nughtf5tzapxhcq7at54bpsmdricyq4o4trsr3pyiqhpq",
      "dbHomeId": "ocid1.dbhome.oc1.sea.abzwkljs7obwmwq2kgkjgeko4voudfcd5chu6iuonnew7uuxculsvdralzda",
      "dbUniqueName": "Audit_check",
      "dbVersion": "19.10.0.0",
      "exadataInfrastructureId": "ocid1.exadatainfrastructure.oc1.sea.abzwkljsqtwpumvorlttjuxcx6qtkxhuasvmyu4qy3bng74sqolpwjunsrqa",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2021-07-15T11:01:24Z",
      "timeUpdated": "2021-07-15T11:03:56Z",
      "vmClusterId": "ocid1.vmcluster.oc1.sea.abzwkljsghfg7e3q3xh3gzqqxijt72fepczowmk35t554wxbpew7txnooprq"
    }
  }
}

Pluggable Database Event Types

Review the list of event types that Pluggable Databases emit.

Table 7-20 Pluggable Database Events

Friendly Name Event Type

Pluggable Database - Create Begin

com.oraclecloud.databaseservice.createpluggabledatabase.begin

Pluggable Database - Create End

com.oraclecloud.databaseservice.createpluggabledatabase.end

Pluggable Database - Delete Begin

com.oraclecloud.databaseservice.deletepluggabledatabase.begin

Pluggable Database - Delete End

com.oraclecloud.databaseservice.deletepluggabledatabase.end

Pluggable Database - Local Clone Begin

com.oraclecloud.databaseservice.localclonepluggabledatabase.begin

Pluggable Database - Local Clone End

com.oraclecloud.databaseservice.localclonepluggabledatabase.end

Pluggable Database - Remote Clone Begin

com.oraclecloud.databaseservice.remoteclonepluggabledatabase.begin

Pluggable Database - Remote Clone End

com.oraclecloud.databaseservice.remoteclonepluggabledatabase.end

Start Pluggable Database - Begin

com.oraclecloud.databaseservice.startpluggabledatabase.begin

Start Pluggable Database - End

com.oraclecloud.databaseservice.startpluggabledatabase.end

Stop Pluggable Database - Start

com.oraclecloud.databaseservice.stoppluggabledatabase.begin

Stop Pluggable Database - End

com.oraclecloud.databaseservice.stoppluggabledatabase.end

Pluggable Database - Convert to Regular Begin

com.oraclecloud.databaseservice.pluggabledatabase.converttoregular.begin

Pluggable Database - Convert to Regular End

com.oraclecloud.databaseservice.pluggabledatabase.converttoregular.end

Pluggable Database - Inplace Restore Begin

com.oraclecloud.databaseservice.pluggabledatabase.inplacerestore.begin

Pluggable Database - Inplace Restore End

com.oraclecloud.databaseservice.pluggabledatabase.inplacerestore.end

Pluggable Database - Local Clone Begin

com.oraclecloud.databaseservice.pluggabledatabase.localclone.begin

Pluggable Database - Local Clone End

com.oraclecloud.databaseservice.pluggabledatabase.localclone.end

Pluggable Database - Refresh Begin

com.oraclecloud.databaseservice.pluggabledatabase.refresh.begin

Pluggable Database - Refresh End

com.oraclecloud.databaseservice.pluggabledatabase.refresh.end

Pluggable Database - Relocate Begin

com.oraclecloud.databaseservice.pluggabledatabase.relocate.begin

Pluggable Database - Relocate End

com.oraclecloud.databaseservice.pluggabledatabase.relocate.end

Pluggable Database - Remote Clone Begin

com.oraclecloud.databaseservice.pluggabledatabase.remoteclone.begin

Pluggable Database - Remote Clone End

com.oraclecloud.databaseservice.pluggabledatabase.remoteclone.end

Example 7-75 Pluggable Database Examples

This is a reference event for Pluggable Database - Create Begin:
{
  “eventID”: “af1cdf4e-4001-11eb-9fb6-f45c89b1cb17",
  “eventTime”: “2020-12-17T00:49:14.123Z”,
  “extensions”: {
    “compartmentId”: “ocid1.compartment.oc1..unique_id”
  },
  “eventType”: “com.oraclecloud.databaseservice.createexternalpluggabledatabase”,
  “eventTypeVersion”: “2.0”,
  “cloudEventsVersion”: “0.1”,
  “source”: “databaseservice”,
  “contentType”: “application/json”,
  “definedTags”: {},
  “data”: {
    “compartmentId”: “ocid1.compartment.oc1.......unique_id”,
    “compartmentName”: “MyCompartment”,
    “resourceName”: “11092020_PKS_PDB1”,
    “resourceId”: “ocid1.externalpluggabledatabases.oc1.phx.unique_id”,
    “availabilityDomain”: “XXIT:PHX-AD-1”,
    “freeFormTags”: {},
    “definedTags”: {},
    “additionalDetails”: {
      “id”: “ocid1.externalpluggabledatabases.oc1.phx.unique_id”,
      “timeCreated”: “2020-11-13T21:15:59.000Z”,
      “timeUpdated”: “2020-11-13T21:15:59.000Z”,
      “externalCDBId”: “ocid1.externalcontainerdatabase.oc1.....unique_id”,
      “lifecycleState”: “AVAILABLE”,
      “lifecycleDetails”: “External Pluggable Database is available”,
      “dbUniqueName”: “CDB122_phx16q”,
      “dbId”: “3455094890",
      “dbVersion”: “12.2.0.1.0",
      “dbEdition”: “ENTERPRISE_EDITION_EXTREME_PERFORMANCE”,
      “timeZone”: “US/Pacific”,
      “databaseManagementServiceStatus”: “ENABLED”,
      “databaseManagementServiceConnectorId”: “ocid1.externaldatabaseconnector.oc1.....unique_id”,
      “displayName”: “External Pluggable Database - Create”
    }
  }
}
This is a reference event for Pluggable Database - Convert to Regular Begin:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.converttoregular.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "isRefreshableClone": true,
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "UPDATING",
        "displayName": "Pluggable Database - Convert to Regular Begin"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Convert to Regular End:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.converttoregular.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "isRefreshableClone": false,
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "displayName": "Pluggable Database - Convert to Regular End"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Inplace Restore Begin:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.inplacerestore.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "RESTORE_IN_PROGRESS",
        "isRefreshableClone": false,
        "displayName": "Pluggable Database - Inplace Restore Begin"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Inplace Restore End:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.inplacerestore.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": false,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Inplace Restore End"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Local Clone Begin:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.localclone.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": false,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Local Clone Begin"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Local Clone End:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.localclone.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": false,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Local Clone End"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Refresh Begin:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.refresh.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "isRefreshableClone": true,
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Refresh Begin"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Refresh End:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.refresh.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": true,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Refresh End"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Relocate Begin:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.relocate.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": false,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Relocate Begin"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Relocate End:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.relocate.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Relocate End"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Remote Clone Begin:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.remoteclone.begin",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": false,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Remote Clone Begin"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}
This is a reference event for Pluggable Database - Remote Clone End:
"exampleEvent": {
    "eventID": "unique_id",
    "eventTime": "2021-03-23T00:49:14.123Z",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_id"
    },
    "eventType": "com.oraclecloud.databaseservice.pluggabledatabase.remoteclone.end",
    "eventTypeVersion": "2.0",
    "cloudEventsVersion": "0.1",
    "source": "databaseservice",
    "contentType": "application/json",
    "definedTags": {},
    "data": {
      "compartmentId": "ocid1.compartment.oc1.......unique_id",
      "compartmentName": "MyCompartment",
      "resourceName": "11092020_PKS_PDB1",
      "resourceId": "ocid1.pluggabledatabases.oc1.phx.unique_id",
      "availabilityDomain": "XXIT:PHX-AD-1",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.pluggabledatabases.oc1.phx.unique_id",
        "timeCreated": "2021-03-13T21:15:59.000Z",
        "timeUpdated": "2021-03-13T21:15:59.000Z",
        "databaseId": "ocid1.database.oc1.....unique_id",
        "lifecycleState": "AVAILABLE",
        "isRefreshableClone": false,
        "lifecycleDetails": "Pluggable Database is available",
        "displayName": "Pluggable Database - Remote Clone End"
      }
    }
  },
  "activationTime": "2021-03-23T15:00:00.000Z",
  "eventTypeVersion": "2.0"
}

VM Node Subsetting Event Types

Review the list of event types that VM Node Subsetting emits.

Table 7-21 VM Node Subsetting Events

Friendly Name Event Type

VM Cluster - Add Virtual Machine Begin

com.oraclecloud.databaseservice.vmclusteraddvirtualmachine.begin

VM Cluster - Add Virtual Machine End

com.oraclecloud.databaseservice.vmclusteraddvirtualmachine.end

VM Cluster - Terminate Virtual Machine Begin

com.oraclecloud.databaseservice.vmclusterterminatevirtualmachine.begin

VM Cluster - Terminate Virtual Machine End

com.oraclecloud.databaseservice.vmclusterterminatevirtualmachine.end

Example 7-76 VM Node Subsetting Examples

This is a reference event for VM Cluster - Add Virtual Machine Begin:
"exampleEvent": {
"cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.vmclusteraddvirtualmachine.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
"compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
"compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "Vmcluster-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
"id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-09-03T12:00:00.000Z",
      "timeUpdated": "2019-09-03T12:30:00.000Z",
      "displayName": "testDisplayName",
      "lifecycleDetails": "detail message",
      "exadataInfrastructureId": "ExatraInfra-unique_ID",
      "vmClusterNetworkId": "VmCluster-unique_ID",
      "cpuCoreCount": 2,
      "dataStorageSizeInTBs": 4,
      "memorySizeInGBs": 30,
      "dbNodeStorageSizeInGBs": 60,
      "dbVersion": "19.0.0.0",
      "licenseType": "BRING_YOUR_OWN_LICENSE",
      "giVersion": "19.0.0.0",
      "dbNodeIds": "[ocid1.dbnode.1, ocid1.dbnode.2,...]",
      "dbServerIds": "[ocid1.dbserver.1, ocid1.dbserver.2,...]",
      "timeZone": "US/Pacific"
    }
  }
}
This is a reference event for VM Cluster - Add Virtual Machine End:
"exampleEvent": {
"cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.vmclusteraddvirtualmachine.end",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
"compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
"compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "Vmcluster-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
"id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-09-03T12:00:00.000Z",
      "timeUpdated": "2019-09-03T12:30:00.000Z",
      "displayName": "testDisplayName",
      "lifecycleDetails": "detail message",
      "exadataInfrastructureId": "ExatraInfra-unique_ID",
      "vmClusterNetworkId": "VmCluster-unique_ID",
      "cpuCoreCount": 2,
      "dataStorageSizeInTBs": 4,
      "memorySizeInGBs": 30,
      "dbNodeStorageSizeInGBs": 60,
      "dbVersion": "19.0.0.0",
      "licenseType": "BRING_YOUR_OWN_LICENSE",
      "giVersion": "19.0.0.0",
      "dbNodeIds": "[ocid1.dbnode.1, ocid1.dbnode.2,...]",
      "dbServerIds": "[ocid1.dbserver.1, ocid1.dbserver.2,...]",
      "timeZone": "US/Pacific"
    }
  }
}
This is a reference event for VM Cluster - Terminate Virtual Machine Begin:
"exampleEvent": {
"cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.vmclusterterminatevirtualmachine.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
"compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
"compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "Vmcluster-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
"id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-09-03T12:00:00.000Z",
      "timeUpdated": "2019-09-03T12:30:00.000Z",
      "displayName": "testDisplayName",
      "lifecycleDetails": "detail message",
      "exadataInfrastructureId": "ExatraInfra-unique_ID",
      "vmClusterNetworkId": "VmCluster-unique_ID",
      "cpuCoreCount": 2,
      "dataStorageSizeInTBs": 4,
      "memorySizeInGBs": 30,
      "dbNodeStorageSizeInGBs": 60,
      "dbVersion": "19.0.0.0",
      "licenseType": "BRING_YOUR_OWN_LICENSE",
      "giVersion": "19.0.0.0",
      "dbNodeIds": "[ocid1.dbnode.1, ocid1.dbnode.2,...]",
      "dbServerIds": "[ocid1.dbserver.1, ocid1.dbserver.2,...]",
      "timeZone": "US/Pacific"
    }
  }
}
This is a reference event for VM Cluster - Terminate Virtual Machine End:
"exampleEvent": {
"cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.vmclusterterminatevirtualmachine.end",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
"compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
"compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_database",
    "resourceId": "Vmcluster-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
"id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-09-03T12:00:00.000Z",
      "timeUpdated": "2019-09-03T12:30:00.000Z",
      "displayName": "testDisplayName",
      "lifecycleDetails": "detail message",
      "exadataInfrastructureId": "ExatraInfra-unique_ID",
      "vmClusterNetworkId": "VmCluster-unique_ID",
      "cpuCoreCount": 2,
      "dataStorageSizeInTBs": 4,
      "memorySizeInGBs": 30,
      "dbNodeStorageSizeInGBs": 60,
      "dbVersion": "19.0.0.0",
      "licenseType": "BRING_YOUR_OWN_LICENSE",
      "giVersion": "19.0.0.0",
      "dbNodeIds": "[ocid1.dbnode.1, ocid1.dbnode.2,...]",
      "dbServerIds": "[ocid1.dbserver.1, ocid1.dbserver.2,...]",
      "timeZone": "US/Pacific"
    }
  }
}

Database Service Events

The Database Service emits events, which are structured messages that indicate changes in resources.

Parent topic: Oracle Exadata Database Service on Cloud@Customer Events

Overview of Database Service Events

Database Service Events feature implementation enables you to get notified about health issues with your Oracle Databases or other components on the Guest VM.

It is possible that Oracle Database or Clusterware may not be healthy or various system components may be running out of space in the Guest VM. Customers are not notified of this situation.

Database Service Events feature implementation generates events for Data Plane operations and conditions, as well as Notifications for customers by leveraging the existing OCI Events service and Notification mechanisms in their tenancy. Customers can then create topics and subscribe to these topics through email, functions, or streams.

Note

Events flow on ExaDB-C@C depends on the following components: Oracle Trace File Analyzer (TFA), sysLens, and Oracle Database Cloud Service (DBCS) agent. Ensure that these components are up and running.

Manage Oracle Trace File Analyzer

  • To check the run status of Oracle Trace File Analyzer, run the tfactl status command as root or a non-root user:
    # tfactl status
.-------------------------------------------------------------------------------------------------.
| Host	| Status of TFA | PID    | Port | Version    | Build ID	      | Inventory Status|
+----------------+---------------+--------+------+------------+----------------------+------------+
| node1      | RUNNING	| 41312  | 5000 | 22.1.0.0.0 | 22100020220310214615 | COMPLETE        |
| node2      | RUNNING	| 272300 | 5000 | 22.1.0.0.0 | 22100020220310214615 | COMPLETE        |
'----------------+---------------+--------+------+------------+----------------------+------------'
  • To start the Oracle Trace File Analyzer daemon on the local node, run the tfactl start command as root:
    # tfactl start
Starting TFA..
Waiting up to 100 seconds for TFA to be started..
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
  • To stop the Oracle Trace File Analyzer daemon on the local node, run the tfactl stop command as root:
    # tfactl stop
Stopping TFA from the Command Line
Nothing to do !
Please wait while TFA stops
Please wait while TFA stops
TFA-00002 Oracle Trace File Analyzer (TFA) is not running
TFA Stopped Successfully
Successfully stopped TFA..

Manage sysLens

  • If sysLens is running, then once every 15 minutes data is collected in the local domU to discover the events to be reported.
    To check if sysLens is running, run the systemctl status syslens command as root in the domU:
    # systemctl status syslens
\u25cf syslens.service
Loaded: loaded (/etc/systemd/system/syslens.service; disabled; vendor preset: disabled)
Active: active (running) since Wed 2022-03-16 18:08:59 UTC; 34s ago
Main PID: 358039 (python3)
Memory: 31.6M
CGroup: /system.slice/syslens.service
\u2514\u2500358039 /usr/bin/python3 /var/opt/oracle/syslens/bin/syslens_main.py --archive /var/opt/oracle/log/...
 
Mar 16 18:08:59 node1 systemd[1]: Started syslens.service.
Mar 16 18:09:09 node1 su[360495]: (to oracle) root on none
Mar 16 18:09:09 node1 su[360539]: (to grid) root on none
Mar 16 18:09:10 node1 su[360611]: (to grid) root on none
Mar 16 18:09:11 node1 su[360653]: (to oracle) root on none
  • If sysLens is enabled, when there is a reboot of the domU, then sysLens starts automatically.
    To validate if sysLens is enabled to collect telemetry, run the systemctl is-enabled syslens command as root in the domU:
    # systemctl is-enabled syslens
enabled
  • To validate if sysLens is configured to notify events, run the /usr/bin/syslens --config /var/opt/oracle/syslens/data/exacc.syslens.config --get-key enable_telemetry command as root in the domU:
    # /usr/bin/syslens --config /var/opt/oracle/syslens/data/exacc.syslens.config --get-key enable_telemetry
syslens Collection 2.3.3
on

Manage Database Service Agent

View the /opt/oracle/dcs/log/dcs-agent.log file to identify issues with the agent.

  • To check the status of the Database Service Agent, run the systemctl status command:
    # systemctl status dbcsagent.service
dbcsagent.service
Loaded: loaded (/usr/lib/systemd/system/dbcsagent.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2022-04-01 13:40:19 UTC; 6min ago
Process: 9603 ExecStopPost=/bin/bash -c kill `ps -fu opc |grep "java.*dbcs-agent.*jar" |awk '{print $2}' ` (code=exited, status=0/SUCCESS)
Main PID: 10055 (sudo)
CGroup: /system.slice/dbcsagent.service
‣ 10055 sudo -u opc /bin/bash -c umask 077; /bin/java -Doracle.security.jps.config=/opt/oracle/...
  • To start the agent if it is not running, run the systemctl start command as the root user:
    systemctl start dbcsagent.service

Receive Notifications about Database Service Events

Subscribe to the Database Service Events and get notified.

To receive notifications, subscribe to Database Service Events and get notified using the Oracle Notification service, see Notifications Overview. For more information about Oracle Cloud Infrastructure Events, see Overview of Events.

Events Service - Event Types:
  • Database - Critical
  • DB Node - Critical
  • DB Node - Error
  • DB Node - Warning
  • DB Node - Info
  • DB System - Critical

Database Service Event Types

Review the list of event types that the Database Service emits.

Note

  • Critical events are triggered due to several types of critical conditions and errors that cause disruption to the database and other critical components. For example, database hang errors, and availability errors for databases, database nodes, and database systems to let you know if a resource becomes unavailable.
  • Information events are triggered when the database and other critical components work as expected. For example, a clean shutdown of CRS, CDB, client, or scan listener, or a startup of these components will create an event with the severity of INFO.
  • Threshold limits reduce the number of notifications customers will receive for similar incident events whilst at the same time ensuring they receive the incident events and are reminded in a timely fashion.

Table 7-22 Database Service Events

Friendly Name Event Name Remediation Event Type Threshold

Resource Utilization - Disk Usage

HEALTH.DB_GUEST.FILESYSTEM.FREE_SPACE

This event is reported when VM guest file system free space falls below 10% free, as determined by the operating system df(1) command, for the following file systems:
  • /
  • /u01
  • /u02
  • /var (X8M and later only)
  • /tmp (X8M and later only)

HEALTH.DB_GUEST.FILESYSTEM.FREE_SPACE

com.oraclecloud.databaseservice.dbnode.critical

Critical threshold: 90%

Disk Issues

HEALTH.DB_GUEST.FILESYSTEM.CORRUPTION

A Write-then-Read operation with a dummy file has failed for a file system, typically indicating the operating system had detected an I/O error or inconsistency (i.e. corruption) with the file system and changed the file system mount mode from read-write to read-only. The following file systems are tested:
  • /
  • /u01
  • /u02

HEALTH.DB_GUEST.FILESYSTEM.CORRUPTION

com.oraclecloud.databaseservice.dbnode.critical

N/A

Memory Usage

CONFIGURATION.DB_GUEST.MEMORY.HUGEPAGES_TOO_LARGE

An event of type CRITICAL is created when the amount of memory in the VM configured for HugePages is 90% or more of the total VM memory.

CONFIGURATION.DB_GUEST.MEMORY.HUGEPAGES_TOO_LARGE

com.oraclecloud.databaseservice.dbnode.critical

90%

sshd Configuration

CONFIGURATION.DB_GUEST.SSHD.INVALID

An event of type CRITICAL is created if unexpected values are set in the /etc/ssh/sshd_config file.

CONFIGURATION.DB_GUEST.SSHD.INVALID

com.oraclecloud.databaseservice.dbnode.critical

N/A

Oracle EXAchk Reported Issues

HEALTH.DB_CLUSTER.EXACHK.CRITICAL_ALERT

Oracle EXAchk is Exadata database platform's holistic health check that includes software, infrastructure and database configuration checks. CRITICAL check alerts should be addressed in 24 hours to maintain the maximum stability and availability of your system. This database service event alerts every 24 hours whenever there are any CRITICAL checks that are flagged in the most recent Oracle EXAchk report. The event will point to the latest Oracle EXAchk zip report.

HEALTH.DB_CLUSTER.EXACHK.CRITICAL_ALERT

com.oraclecloud.databaseservice.dbnode.critical

N/A

CRS status Up/Down

AVAILABILITY.DB_GUEST.CRS_INSTANCE.DOWN.

An event of type CRITICAL is created when the Cluster Ready Service (CRS) is detected to be down.

AVAILABILITY.DB_GUEST.CRS_INSTANCE.DOWN

com.oraclecloud.databaseservice.dbnode.critical (if .DOWN and NOT "user_action")

N/A

AVAILABILITY.DB_GUEST.CRS_INSTANCE.DOWN_CLEARED

An event of type INFORMATION is created once it is determined that the event for CRS down has cleared.

N/A

com.oraclecloud.databaseservice.dbnode.information (if .DOWN_CLEARED)

SCAN Listener Up/Down

AVAILABILITY.DB_CLUSTER.SCAN_LISTENER.DOWN

A DOWN event is created when a SCAN listener goes down. The event is of type INFORMATION when a SCAN listener is shutdown due to user action, such as with the Server Control Utility (srvctl) or Listener Control (lsnrctl) commands, or any Oracle Cloud maintenance action that uses those commands, such as performing a grid infrastructure software update. The event is of type CRITICAL when a SCAN listener goes down unexpectedly. A corresponding DOWN_CLEARED event is created when a SCAN listener is started.

There are three SCAN listeners per cluster called LISTENER_SCAN[1,2,3].

AVAILABILITY.DB_CLUSTER.SCAN_LISTENER.DOWN

com.oraclecloud.databaseservice.dbnode.critical (if .DOWN and NOT "user_action")

N/A

AVAILABILITY.DB_CLUSTER.SCAN_LISTENER.DOWN_CLEARED

An event of type INFORMATION is created once it is determined that the event for SCAN Listener down has cleared.

N/A

com.oraclecloud.databaseservice.dbnode.information (if .DOWN_CLEARED)

Net Listener Up/Down

AVAILABILITY.DB_GUEST.CLIENT_LISTENER.DOWN

A DOWN event is created when a client listener goes down. The event is of type INFORMATION when a client listener is shutdown due to user action, such as with the Server Control Utility (srvctl) or Listener Control (lsnrctl) commands, or any Oracle Cloud maintenance action that uses those commands, such as performing a grid infrastructure software update. The event is of type CRITICAL when a client listener goes down unexpectedly. A corresponding DOWN_CLEARED event is created when a client listener is started.

There is one client listener per node, each called LISTENER.

AVAILABILITY.DB_GUEST.CLIENT_LISTENER.DOWN

com.oraclecloud.databaseservice.database.critical (if .DOWN and NOT "user_action")

N/A

AVAILABILITY.DB_GUEST.CLIENT_LISTENER.DOWN_CLEARED

An event of type INFORMATION is created once it is determined that the event for Client Listener down has cleared.

N/A

com.oraclecloud.databaseservice.database.information (if .DOWN_CLEARED)

CDB Up/Down

AVAILABILITY.DB_GUEST.CDB_INSTANCE.DOWN

A DOWN event is created when a database instance goes down. The event is of type INFORMATION when a database instance is shutdown due to user action, such as with the SQL*Plus (sqlplus) or Server Control Utility (srvctl) commands, or any Oracle Cloud maintenance action that uses those commands, such as performing a database home software update. The event is of type CRITICAL when a database instance goes down unexpectedly. A corresponding DOWN_CLEARED event is created when a database instance is started.

AVAILABILITY.DB_GUEST.CDB_INSTANCE.DOWN

com.oraclecloud.databaseservice.database.critical (if .DOWN and NOT "user_action")

N/A

AVAILABILITY.DB_GUEST.CDB_INSTANCE.DOWN_CLEARED

An event of type INFORMATION is created once it is determined that the event for the CDB down has cleared.

N/A

com.oraclecloud.databaseservice.database.information (if .DOWN_CLEARED)

Critical DB Errors

HEALTH.DB_CLUSTER.CDB.CORRUPTION

Database corruption has been detected on your primary or standby database. The database alert.log is parsed for any specific errors that are indicative of physical block corruptions, logical block corruptions, or logical block corruptions caused by lost writes.

HEALTH.DB_CLUSTER.CDB.CORRUPTION

com.oraclecloud.databaseservice.database.critical

N/A

Other DB Errors

HEALTH.DB_CLUSTER.CDB.ARCHIVER_HANG

An event of type CRITICAL is created if a CDB is either unable to archive the active online redo log or unable to archive the active online redo log fast enough to the log archive destinations.

HEALTH.DB_CLUSTER.CDB.ARCHIVER_HANG

com.oraclecloud.databaseservice.database.critical

N/A

HEALTH.DB_CLUSTER.CDB.DATABASE_HANG

An event of type CRITICAL is created when a process/session hang is detected in the CDB.

HEALTH.DB_CLUSTER.CDB.DATABASE_HANG

Backup Failures

HEALTH.DB_CLUSTER.CDB.BACKUP_FAILURE

An event of type CRITICAL is created if there is a CDB backup with a FAILED status reported in the v$rman_status view.

HEALTH.DB_CLUSTER.CDB.BACKUP_FAILURE

com.oraclecloud.databaseservice.database.critical

N/A

Disk Group Usage

HEALTH.DB_CLUSTER.DISK_GROUP.FREE_SPACE

An event of type CRITICAL is created when an ASM disk group reaches space usage of 90% or higher. An event of type INFORMATION is created when the ASM disk group space usage drops below 90%.

HEALTH.DB_CLUSTER.DISK_GROUP.FREE_SPACE

com.oraclecloud.databaseservice.dbsystem.critical

com.oraclecloud.databaseservice.dbsystem.information (if < 90%)

Notifications are sent when the usage hits 70%, 80%, 90%, and 100% with a corresponding severity of 4, 3, 2, and 1.

Example 7-77 Database Service DB Node Critical Events Examples

DB node critical reference events:
{
 "eventType" : "com.oraclecloud.databaseservice.dbnode.critical",
 "cloudEventsVersion" : "0.1",
 "eventTypeVersion" : "2.0",
 "source" : "SYSLENS/host_Name/DomU",
 "eventTime" : "2022-03-07T23:17:47Z",
 "contentType" : "application/json",
 "data" : {
   "compartmentId" : "compartment_ID",
   "compartmentName" : "compartment_Name",
   "resourceName" : "resource_Name",
   "resourceId" : "resource_ID",
   "additionalDetails" : {
     "serviceType" : "EXACC",
     "hostName" : "host_Name",
     "description" : "EXACHK is reporting 6 checks in critical status. Results in: /u02/oracle.ahf/data/host_Name/exachk/user_root/output/exachk_host_Name_v1c2_030722_150746.zip",
     "eventName" : "HEALTH.DB_CLUSTER.EXACHK.CRITICAL_ALERT",
     "status" : "online"
   }
 },
 "eventID" : "cce55ca2-9e6c-11ec-90e6-00163e9b4de8",
 "extensions" : {
   "compartmentId" : "compartment_ID"
 }
}
{
 "eventType" : "com.oraclecloud.databaseservice.dbnode.critical",
 "cloudEventsVersion" : "0.1",
 "eventTypeVersion" : "2.0",
 "source" : "SYSLENS/host_Name/DomU",
 "eventTime" : "2022-03-06T18:14:57Z",
 "contentType" : "application/json",
 "data" : {
   "compartmentId" : "compartment_ID",
   "compartmentName" : "compartment_Name",
   "resourceName" : "resource_Name",
   "resourceId" : "resource_ID",
   "additionalDetails" : {
     "serviceType" : "EXACC",
     "hostName" : "host_Name",
     "description" : "Parameter ClientAliveCountMax has incorrect value.",
     "eventName" : "CONFIGURATION.DB_GUEST.SSHD.INVALID",
     "status" : "online"
   }
 },
 "eventID" : "5453554e-9d79-11ec-8096-00163eb980bb",
 "extensions" : {
   "compartmentId" : "compartment_ID"
 }
}
{
 "eventType" : "com.oraclecloud.databaseservice.dbnode.critical",
 "cloudEventsVersion" : "0.1",
 "eventTypeVersion" : "2.0",
 "source" : "SYSLENS/host_Name/DomU",
 "eventTime" : "2022-03-04T18:19:42Z",
 "contentType" : "application/json",
 "data" : {
   "compartmentId" : "compartment_ID",
   "compartmentName" : "compartment_Name",
   "resourceName" : "resource_Name",
   "resourceId" : "resource_ID",
   "additionalDetails" : {
     "serviceType" : "EXACC",
     "hostName" : "host_Name",
     "description" : "The '/' filesystem is over 90% used.",
     "eventName" : "HEALTH.DB_GUEST.FILESYSTEM.FREE_SPACE",
     "status" : "online"
   }
 },
 "eventID" : "a9752630-9be7-11ec-a203-00163eb980bb",
 "extensions" : {
   "compartmentId" : "compartment_ID"
 }
}
{
 "eventType" : "com.oraclecloud.databaseservice.dbnode.critical",
 "cloudEventsVersion" : "0.1",
 "eventTypeVersion" : "2.0",
 "source" : "SYSLENS/host_Name/DomU",
 "eventTime" : "2022-03-04T18:49:25Z",
 "contentType" : "application/json",
 "data" : {
   "compartmentId" : "compartment_ID",
   "compartmentName" : "compartment_Name",
   "resourceName" : "resource_Name",
   "resourceId" : "resource_ID",
   "additionalDetails" : {
     "serviceType" : "EXACC",
     "hostName" : "host_Name",
     "description" : "Huge Pages is configured more than 90% of total memory amount.",
     "eventName" : "CONFIGURATION.DB_GUEST.MEMORY.HUGEPAGES_TOO_LARGE",
     "status" : "online"
   }
 },
 "eventID" : "d0724fac-9beb-11ec-a203-00163eb980bb",
 "extensions" : {
   "compartmentId" : "compartment_ID"
 }
}

Parent topic: Database Service Events

Temporarily Restrict Automatic Diagnostic Collections for Specific Events

Use the tfactl blackout command to temporarily suppress automatic diagnostic collections.

If you set blackout for a target, then Oracle Trace File Analyzer stops automatic diagnostic collections if it finds events in the alert logs for that target while scanning. By default, blackout will be in effect for 24 hours.

You can also restrict automatic diagnostic collection at a granular level, for example, only for ORA-00600 or even only ORA-00600 with specific arguments.

Syntax

tfactl blackout add|remove|print
-targettype host|crs|asm|asmdg|database|dbbackup|db_dataguard|db_tablespace|pdb_tablespace|pdb|listener|service|os
-target all|name
[-container name]
[-pdb pdb_name]
-event all|"event_str1,event_str2"|availability
[-timeout nm|nh|nd|none]
[-c|-local|-nodes "node1,node2"]
[-reason "reason for blackout"]
[-docollection]

Parameters

Table 7-23 tfactl blackout Command Parameters

Parameter Description

add|remove|print|

Adds, removes, or prints blackout conditions.

targettype type

Target type: host|crs|asm|asmdg|database|dbbackup |db_dataguard|db_tablespace |pdb_tablespace|pdb|listener|service|os

Limits blackout only to the specified target type.

host: The whole node is under blackout. If there is host blackout, then every blackout element that's shown true in the Telemetry JSON will have the reason for the blackout.

crs: Blackout the availability of the Oracle Clusterware resource or events in the Oracle Clusterware logs.

asm: Blackout the availability of Oracle Automatic Storage Management (Oracle ASM) on this machine or events in the Oracle ASM alert logs.

asmdg: Blackout an Oracle ASM disk group.

database: Blackout the availability of an Oracle Database, Oracle Database backup, tablespace, and so on, or events in the Oracle Database alert logs.

dbbackup: Blackout Oracle Database backup events (such as CDB or archive backups).

db_dataguard: Blackout Oracle Data Guard events.

db_tablespace: Blackout Oracle Database tablespace events (container database).

pdb_tablespace: Blackout Oracle Pluggable Database tablespace events (Pluggable database).

pdb: Blackout Oracle Pluggable Database events.

listener: Blackout the availability of a listener.

service: Blackout the availability of a service.

os: Blackout one or more operating system records.

target all|name

Specify the target for blackout. You can specify a comma-delimited list of targets.

By default, the target is set to all.

container name

Specify the database container name (db_unique_name) where the blackout will take effect (for PDB, DB_TABLESPACE, and PDB_TABLESPACE).

pdb pdb_name

Specify the PDB where the blackout will take effect (for PDB_TABLESPACE only).

events all|"str1,str2"

Limits blackout only to the availability events, or event strings, which should not trigger auto collections, or be marked as blacked out in telemetry JSON.

all: Blackout everything for the target specified.

string: Blackout for incidents where any part of the line contains the strings specified.

Specify a comma-delimited list of strings.

timeout nh|nd|none

Specify the duration for blackout in number of hours or days before timing out. By default, the timeout is set to 24 hours (24h).

c|local

Specify if blackout should be set to cluster-wide or local.

By default, blackout is set to local.

reason comment

Specify a descriptive reason for the blackout.

docollection

Use this option to do an automatic diagnostic collection even if a blackout is set for this target.

Example 7-78 tfactl blackout

  • To blackout event: ORA-00600 on target type: database, target: mydb
    tfactl blackout add -targettype database -target mydb -event "ORA-00600"
  • To blackout event: ORA-04031 on target type: database, target: all
    tfactl blackout add -targettype database -target all -event "ORA-04031" -timeout 1h
  • To blackout db backup events on target type: dbbackup, target: mydb
    tfactl blackout add -targettype dbbackup -target mydb
  • To blackout db dataguard events on target type: db_dataguard, target: mydb
    tfactl blackout add -targettype db_dataguard -target mydb -timeout 30m
  • To blackout db tablespace events on target type: db_tablespace, target: system, container: mydb
    tfactl blackout add -targettype db_tablespace -target system -container mydb -timeout 30m
  • To blackout ALL events on target type: host, target: all
    tfactl blackout add -targettype host -event all -target all -timeout 1h -reason "Disabling all events during patching"
  • To print blackout details
    tfactl blackout print
    
.-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
|                                                                                myhostname                                                                                     |
+---------------+---------------------+-----------+------------------------------+------------------------------+--------+---------------+--------------------------------------+
| Target Type   | Target              | Events    | Start Time                   | End Time                     | Status | Do Collection | Reason                               |
+---------------+---------------------+-----------+------------------------------+------------------------------+--------+---------------+--------------------------------------+
| HOST          | ALL                 | ALL       | Thu Mar 24 16:48:39 UTC 2022 | Thu Mar 24 17:48:39 UTC 2022 | ACTIVE | false         | Disabling all events during patching |
| DATABASE      | MYDB                | ORA-00600 | Thu Mar 24 16:39:03 UTC 2022 | Fri Mar 25 16:39:03 UTC 2022 | ACTIVE | false         | NA                                   |
| DATABASE      | ALL                 | ORA-04031 | Thu Mar 24 16:39:54 UTC 2022 | Thu Mar 24 17:39:54 UTC 2022 | ACTIVE | false         | NA                                   |
| DB_DATAGUARD  | MYDB                | ALL       | Thu Mar 24 16:41:38 UTC 2022 | Thu Mar 24 17:11:38 UTC 2022 | ACTIVE | false         | NA                                   |
| DBBACKUP      | MYDB                | ALL       | Thu Mar 24 16:40:47 UTC 2022 | Fri Mar 25 16:40:47 UTC 2022 | ACTIVE | false         | NA                                   |
| DB_TABLESPACE | SYSTEM_CDBNAME_MYDB | ALL       | Thu Mar 24 16:45:56 UTC 2022 | Thu Mar 24 17:15:56 UTC 2022 | ACTIVE | false         | NA                                   |
'---------------+---------------------+-----------+------------------------------+------------------------------+--------+---------------+--------------------------------------'
  • To remove blackout for event: ORA-00600 on target type: database, target: mydb
    tfactl blackout remove -targettype database -event "ORA-00600" -target mydb
  • To remove blackout for db backup events on target type: dbbackup, target: mydb
    tfactl blackout remove -targettype dbbackup -target mydb
  • To remove blackout for db tablespace events on target type: db_tablespace, target: system, container: mydb
    tfactl blackout remove -targettype db_tablespace -target system -container mydb
  • To remove blackout for host events on target type: host, target: all
    tfactl blackout remove -targettype host -event all -target all

Parent topic: Database Service Events

Remediation

These topics cover some common issues you might run into and how to address them.

HEALTH.DB_GUEST.FILESYSTEM.FREE_SPACE

Problem Statement: One or more VM guest file systems has free space below 10% free.

Risk: Insufficient VM guest file system free space can cause disk space allocation failure, which can result in wide-ranging errors and failures in Oracle software (Database, Clusterware, Cloud, Exadata).

Action:

Oracle Cloud and Exadata utilities run automatically to purge old log files and trace files created by Oracle software to reclaim file system space.

If the automatic file system space reclamation utilities cannot sufficiently purge old files to clear this event, then perform the following actions:

  1. Remove unneeded files and/or directories created manually or by customer-installed applications or utilities. Files created by customer-installed software are outside the scope of Oracle's automatic file system space reclamation utilities. The following operating system command, run as the opc user, is useful for identifying directories consuming excessive disk space:
    $ sudo du -hx file-system-mount-point | sort -hr

    Only remove files or directories you are certain can be safely removed.

  2. Reclaim /u02 file system disk space by removing Database Homes that have no databases. For more information about managing Database Homes, see Manage Oracle Database Homes on Exadata Database Service on Cloud@Customer Systems.
  3. (Exadata Cloud@Customer only) Increase /u02 file system size. For more information about scaling up local storage, see Introduction to Scale Up or Scale Down Operations.
  4. Open service request to receive additional guidance about reducing file system space use.
HEALTH.DB_GUEST.FILESYSTEM.CORRUPTION

Problem Statement: A file system that is expected to be read-write can no longer be written to.

Risk: Oracle software (Linux, Database, Clusterware, Cloud, Exadata) requires write access to file systems to operate correctly.

Action:

/u01 and /u02 file systems:

  1. Stop running services, if any, that are using the file system, such as Oracle Clusterware, Trace File Analyzer (TFA), and Enterprise Manager (EM) agent.
  2. Unmount the file system.
  3. Run file system check and repair.
    • ext4: Refer to Checking and Repairing a File System.
    • xfs: Refer to Checking and Repairing an XFS File System.
    • If the file system cannot be repaired then open a service request with Oracle Support for assistance.
  4. Mount the file system.
  5. Start the services.

/ (root) file system:

Open a service request with Oracle Support for assistance.

  • If there is VM access, then collect full dmesg(1) command output and provide it to Oracle Support.
  • Note that / (root) file system repair is possible only with console access.
CONFIGURATION.DB_GUEST.MEMORY.HUGEPAGES_TOO_LARGE

Problem Statement: Too much VM memory is allocated for HugePages use.

Risk: Excessive memory allocated to HugePages may result in poor database performance, or the system running out of memory, experiencing excessive swapping, or having crucial system services fail, causing system crash or node eviction.

Action:

  1. Reduce HugePages memory use. To determine the proper setting for operating system parameter vm.nr_hugepages, see My Oracle Support document 361323.1.
  2. Scale up VM memory. For more information about scaling VM memory, see Introduction to Scale Up or Scale Down Operations.
CONFIGURATION.DB_GUEST.SSHD.INVALID

Problem Statement: SSHD configuration is unexpected.

SSHD Configuration Setting Expected Value

PubkeyAuthentication

yes

AuthorizedKeysFile

.ssh/authorized_keys

This file must exist in root user home directory.

HostbasedAuthentication

no

IgnoreUserKnownHosts

yes

IgnoreRhosts

yes

PermitEmptyPasswords

no

PasswordAuthentication

no

ChallengeResponseAuthentication

no

GSSAPIAuthentication

no

UsePAM

yes

PrintMotd

no

UsePrivilegeSeparation

yes

PermitUserEnvironment

no

Compression

delayed

MaxStartups

100

AcceptEnv
Must contain one of the following:
  • LANG
  • LC_CTYPE
  • LC_NUMERIC
  • LC_TIME
  • LC_COLLATE
  • LC_MONETARY
  • LC_MESSAGES
  • LC_PAPER
  • LC_NAME
  • LC_ADDRESS
  • LC_TELEPHONE
  • LC_MEASUREMENT
  • LC_IDENTIFICATION
  • LC_ALL
  • LANGUAGE
  • XMODIFIERS

Subsystem

sftp /usr/libexec/openssh/sftp-server

Protocol

2

AddressFamily

inet

Risk: SSHD configuration is unexpected which may cause Oracle Cloud automation failure or prevent customer SSH access to the VM.

Action: Change SSHD to match expected configuration.

  1. Verify SSHD service is active.
    $ sudo systemctl is-active sshd.service
active

    If SSHD service is inactive, then start it.

    $ sudo systemctl start sshd.service
  2. Verify SSHD service is enabled.
    $ sudo /opt/oracle.cellos/host_access_control ssh-service --status
[INFO] [IMG-SEC-1201] Service sshd is enabled {1}

    If SSHD service is disabled, then enable it.

    $ sudo /opt/oracle.cellos/host_access_control ssh-service --enable
  3. Change SSHD configuration to match the expected values according to the table shown in the Problem Statement section above.
    SSHD Configuration Setting How to Change Current setting

    Ciphers

    /opt/oracle.cellos/host_access_control sshciphers --help

    MACs

    /opt/oracle.cellos/host_access_control ssh-macs --help

    PermitRootLogin

    /opt/oracle.cellos/host_access_control rootssh --help

    ClientAliveInterval

    /opt/oracle.cellos/host_access_control idle-timeout --help

    ClientAliveCountMax

    /opt/oracle.cellos/host_access_control idle-timeout --help

    ListenAddress

    /opt/oracle.cellos/host_access_control ssh-listen --help

    ALL OTHER PARAMETERS
    • Edit /etc/ssh/sshd_config.
    • Restart sshd.service.$ sudo systemctl restart sshd.service

Parent topic: Remediation

HEALTH.DB_CLUSTER.EXACHK.CRITICAL_ALERT

Problem Statement: A CRITICAL Exachk check failed and should be reviewed and addressed as soon as possible.

Risk: A CRITICAL check is expected to impact a large number of customers AND should be addressed immediately (for example, within 24 hours) AND meets one or more of the following criteria:

  1. On-disk corruption or data loss
  2. Intermittent wrong results with Exadata feature usage (e.g. smart scan)
  3. System wide availability impact
  4. Severe system wide performance impact seriously affecting application service Service Level Agreements (SLAs)
  5. Compromised redundancy and inability to restore redundancy
  6. Inability to update software in a rolling manner
  7. Configuration error that could lead to an unexpected or unknown impact

Action:

Recommend that you bring up the EXAchk HTML report from the latest EXAchk zip file and click "view" on each CRITICAL check and follow the recommendation guidance that contains: Benefit/Impact, Risk, and Action/Repair guidance. Once the CRITICAL check is addressed, the next EXAchk run will pass that check. For more information about Oracle EXAchk, see Oracle Exadata Database Machine Exachk (Doc ID 1070954.1).

As the root user, you can re-run EXAchk command by issuing:
/usr/bin/exachk -profile exatier1 -noupgrade -dball

If the check results are returning false data, then log a Service Request.

If there is a CRITICAL check that needs to be temporarily excluded, then follow the "Skipping Specific Best Practice Checks in Exadata Cloud" section of Oracle Exadata Database Machine Exachk (Doc ID 1070954.1).

AVAILABILITY.DB_GUEST.CRS_INSTANCE.DOWN

Problem Statement: The Cluster Ready Stack is in an offline state or has failed.

Risk: If the Cluster Ready Service is offline on a node, then the node cannot provide database services for the application.

Action:

  1. Check if CRS was stopped by your administrator, as part of a planned maintenance event, or a scale up or down of local storage.
    1. The following patching events will stop CRS:
      1. GRID Patching
      2. Exadata VM patching of Guest
      3. Exadata VM Patching of Host
  2. If CRS has stopped unexpectedly, then the current status can be checked by issuing the crsctl check crs command.
    1. If the node is not responding, then the VM node may be rebooting. Wait for the node reboot to finish, CRS will normally be started through the init process.
  3. If CRS is still down, then investigate the cause of the failure by referring to the alert.log found in /u01/app/grid/diag/crs/<node_name>/crs/trace.

    Review the log entries corresponding to the date/time of the down event. Act on any potential remediation.

  4. Restart the CRS, by issuing the crsctl start crs command.
  5. A successful restart of CRS will generate the clearing event: AVAILABILITY.DB_GUEST.CRS_INSTANCE.DOWN_CLEARED.

Parent topic: Remediation

AVAILABILITY.DB_CLUSTER.SCAN_LISTENER.DOWN

Problem Statement: A SCAN listener is down and unable to accept application connections.

Risk: If all SCAN listeners are down, then application connections to the database through the SCAN listener will fail.

Action:

Start the SCAN listener to receive the DOWN_CLEARED event.

DOWN event of type INFORMATION

  1. If the event was caused by an Oracle Cloud maintenance action, such as performing a Grid Infrastructure software update, then no action is required. The affected SCAN listener will automatically failover to an available instance.
  2. If the event was caused by user action, then start the SCAN listener at the next opportunity.

DOWN event of type CRITICAL

Check SCAN status and restart the SCAN listener.

  1. Login to the VM as opc user and sudo to the grid user:
    [opc@vm ~] sudo su - grid
  2. Check the SCAN listener status on any node:
    [grid@vm ~] srvctl status scan_listener
  3. Start the SCAN listener:
    [grid@vm ~] srvctl start scan_listener
  4. Recheck the SCAN listeners status on any node:

    If the scan_listener is still down, then investigate the cause of the scan listener failure:

    1. Collect both the CRS and operating system logs 30 minutes prior and 10 minutes for the <hostName>indicated in the log. Note the time in the event payload is always provided in UTC. For tfactl collection, adjust the time to the timezone of the VM Cluster.
      [grid@vm ~] tfactl diagcollect -crs -os -node <hostName> –from "<eventTime adjusted for local vm timezone> - 30 minute " -to "<eventTime adjusted for local vm timezone> + 10 minutes"
    2. Review the SCAN listener log located under /u01/app/grid/diag/tnslsnr/<hostName>/<listenerName>/trace

Parent topic: Remediation

AVAILABILITY.DB_GUEST.CLIENT_LISTENER.DOWN

Problem Statement: A client listener is down and unable to accept application connections.

Risk:
  • If the node's client listener is down, then the database instances on the node cannot provide services for the application.
  • If the client listener is down on all nodes, then any application that connects to any database using the SCAN or VIP will fail.

Action:

Start the client listener to receive the DOWN_CLEARED event.

DOWN event of type INFORMATION

  1. If the event was caused by an Oracle Cloud maintenance action, such as performing a Grid Infrastructure software update, then no action is required. The affected client listener will automatically restart when maintenance affecting the grid instance is complete.
  2. If the event was caused by user action, then start the client listener at the next opportunity.

DOWN event of type CRITICAL

Check the client listener status and then restart the client listener.

  1. Login to the VM as opc user and sudo to the grid user:
    [opc@vm ~] sudo su - grid
  2. Check the client listener status on any node:
    [grid@vm ~] srvctl status listener
  3. Start the client listener:
    [grid@vm ~] srvctl start listener
  4. Recheck the client listener status on any node:

    If the client listener is still down, then investigate the cause of the client listener failure:

    1. Use tfactl to collect both the CRS and operating system logs 30 minutes prior and 10 minutes for the <hostName> indicated in the log. Note the time in the event payload is always provided in UTC. For tfactl collection, adjust the time to the timezone of the VM Cluster.
      [grid@vm ~] tfactl diagcollect -crs -os -node <hostName> –from "<eventTime adjusted for local vm timezone> - 30 minute " -to "<eventTime adjusted for local vm timezone> + 10 minutes"
    2. Review the listener log located under /u01/app/grid/diag/tnslsnr/<hostName>/<listenerName>/trace

Parent topic: Remediation

AVAILABILITY.DB_GUEST.CDB_INSTANCE.DOWN

Problem Statement: A database instance has gone down.

Risk: A database instance has gone down, which may result in reduced performance if database instances are available on other nodes in the cluster, or complete downtime if database instances on all nodes are down.

Action:

Start the database instance to receive the DOWN_CLEARED event.

DOWN event of type INFORMATION
  1. If the event was caused by an Oracle Cloud maintenance action, such as performing a Database Home software update, then no action is required. The affected database instance will automatically restart when maintenance affecting the instance is complete.
  2. If the event was caused by user action, then start the affected database instance at the next opportunity.

DOWN event of type CRITICAL

  1. Check database status and restart the down database instance.
    1. Login to the VM as oracle user:
    2. Set the environment:
      [oracle@vm ~] . <dbName>.env
    3. Check the database status:
      [oracle@vm ~] srvctl status database -db <dbName>
    4. Start the database instance:
      [oracle@vm ~] srvctl start instance -db <dbName> -instance <instanceName>
  2. Investigate the cause of the database instance failure.
    1. Review Trace File Analyzer (TFA) events for the database:
      [oracle@vm ~] tfactl events -database <dbName> -instance <instanceName>
    2. Review the database alert log located at $ORACLE_BASE/diag/rdbms/<dbName>/<instanceName>/trace/alert_<instanceName>.log

Parent topic: Remediation

HEALTH.DB_CLUSTER.CDB.CORRUPTION

Problem Statement: Corruptions can lead to application or database errors and in worse case result in significant data loss if not addressed promptly.

A corrupt block is a block that was changed so that it differs from what Oracle Database expects to find. Block corruptions can be categorized as physical or logical:
  • In a physical block corruption, which is also called a media corruption, the database does not recognize the block at all; the checksum is invalid or the block contains all zeros. An example of a more sophisticated block corruption is when the block header and footer do not match.
  • In a logical block corruption, the contents of the block are physically sound and pass the physical block checks; however, the block can be logically inconsistent. Examples of logical block corruption include incorrect block type, incorrect data or redo block sequence number, corruption of a row piece or index entry, or data dictionary corruptions.

For more information, see Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1).

Block corruptions can also be divided into interblock corruption and intrablock corruption:
  • In an intrablock corruption, the corruption occurs in the block itself and can be either a physical or a logical block corruption.
  • In an interblock corruption, the corruption occurs between blocks and can only be a logical block corruption.
Oracle checks for the following errors in the alert.log:
  • ORA-01578
  • ORA-00752
  • ORA-00753
  • ORA-00600 [3020]
  • ORA-00600 [kdsgrp1]
  • ORA-00600 [kclchkblk_3]
  • ORA-00600 [13013]
  • ORA-00600 [5463]

Risk: A data corruption outage occurs when a hardware, software, or network component causes corrupt data to be read or written. The service-level impact of a data corruption outage may vary, from a small portion of the application or database (down to a single database block) to a large portion of the application or database (making it essentially unusable). If remediation action is not taken promptly, then potential downtime and data loss can increase.

Action:

The current event notification currently triggers on physical block corruptions (ORA-01578), lost writes (ORA-00752, ORA-00753 and ORA-00600 with first argument 3020), and logical corruptions (typical detected from ORA-00600 with first argument of kdsgrp1, kdsgrp1, kclchkblk_3, 13013 OR 5463).

Oracle recommends the following steps:
  1. Confirm that these corruptions were reported in the alert.log trace file. Log a Service Request (SR) with latest EXAchk report, excerpt of the alert.log and trace file containing the corruption errors, any history of recent application, database or software changes and any system, clusterware and database logs for the same time period. For all these cases, a TFA collection should be available and should be attached to the SR.
  2. For repair recommendations, refer to Handling Oracle Database Corruption Issues (Doc ID 1088018.1).
For physical corruptions or ORA-1578 errors, the following notes will be helpful:
  • Doc ID 1578.1 : OERR: ORA-1578 "ORACLE data block corrupted (file # %s, block # %s)" Primary Note
  • Doc ID 472231.1 : How to identify all the Corrupted Objects in the Database reported by RMAN
  • Doc ID 819533.1 : How to identify the corrupt Object reported by ORA-1578 / RMAN / DBVERIFY
  • Depending on the object that has the corruption, follow the guidance in Doc ID 1088018.1. Note RMAN can be used to recover one or many data block that are physically corrupted. Also using Active Data Guard with real time apply, auto block repair of physical data corruptions would have occurred automatically.
For logical corruptions caused by lost writes (ORA-00752, ORA-00753 and ORA-00600 with first argument 3020) on the primary or standby databases, they will be detected on the primary or with standby's redo apply process. The following notes will be helpful:
  • Follow the guidance, follow Doc ID 1088018.1.
  • If you have a standby and lost write corruption on the primary or standby, refer to Resolving ORA-00752 or ORA-00600 [3020] During Standby Recovery (Doc ID 1265884.1)
For logical corruptions (typical detected from ORA-00600 with arguments of kdsgrp1, kclchkblk_3, 13013 OR 5463):
  • Follow the guidance, follow Doc ID 1088018.1 for specific guidance on the error that was detected.
  • If you have a standby and logical corruption on the primary, refer to Resolving Logical Block Corruption Errors in a Physical Standby Database (Doc ID 2821699.1)
HEALTH.DB_CLUSTER.CDB.ARCHIVER_HANG

Problem Statement: CDB RAC Instance may temporarily or permanently stall due to the log writer's (LGWR) inability to write the log buffers to an online redo log. This occurs because all online logs need archiving. Once the archiver (ARC) can archive at least one online redo log, LGWR will be able to resume writing the log buffers to online redo logs and the application impact will be alleviated.

Risk: If the archiver hang is temporary, then this can result in a small application brown out or stall for application processes attempting to commit their database changes. If the archiver is not unblocked, applications can experience extended delay in processing.

Action:
  • See, Script To Find Redo log Switch History And Find Archivelog Size For Each instance In RAC (Doc ID 2373477.1) to determine the hourly frequency for each thread/instance.
  • If any hourly bucket is greater than 12, then consider resizing the online redo logs. See item 2 below for resizing steps.
  • If the database hangs are temporary, then the archiver may be unable to keep up with the redo log generated. Check the alert.log, $ORACLE_BASE/diag/rdbms/<dbName>/<instanceName>/trace/alert_<instanceName>.log, for "All online logs need archiving", multiple events in a short period can indicate 2 possible solutions.
    • If the number of redo logs groups per thread is less than 4, then consider adding additional logs groups to reach 4, see item 1 below for add redo log steps.
    • The other possible solution is to resize the redo logs, see item 2 below for resizing steps.
  • For Data Guard and Non Data Guard review the Configure Online Redo Logs Appropriately of section Oracle Database High Availability Overview and Best Practices for sizing guidelines.
  1. Add a redo log group for each thread. The additional redo log should equal the current log size.
    1. Use the following query:
      select max(group#) Ending_group_number, thread#, count(*) number_of_groups_per_thread, bytes redo_size_in_bytes from v$log group by thread#,bytes
    2. Add one new group per thread using the same size as the current redo logs.
      alter database add logfile thread <thread_number> Group <max group + 1> ('<DATA_DISKGROUP>') size <redo_size_in_bytes>
  2. Resize the online redo logs by adding larger redo logs and dropping the current smaller redo logs.
    1. Use the following query:
      select max(group#) Ending_group_number, thread#, count(*) number_of_groups_per_thread, bytes redo_size_in_bytes from v$log group by thread#,bytes
    2. Add the same number of redo logs for each thread <number_of_groups_per_thread> that currently exist. The <new_redo_size_in_bytes> should be based on Configure Online Redo Logs Appropriately of section Oracle Database High Availability Overview and Best Practices. 
      1. alter database add logfile thread <thread_number> Group <max group + 1> ('<DATA_DISKGROUP>') size <new_redo_size_in_bytes>
      2. The original smaller redo logs should be deleted. A redo log can only be deleted if its status is inactive.

        To determine the status of a redo logs issue:

        select group#, thread#, status, bytes from v$log order by bytes, group#, thread#;
        To delete the original smaller redo logs:
        alter database drop logfile <group#>
  • If the database is hung, the primary log archive destination and alternate may be full. Review the HEALTH.DB_CLUSTER.DISK_GROUP.FREE_SPACE for details on freeing space in RECO and DATA disk groups.
HEALTH.DB_CLUSTER.CDB.DATABASE_HANG

Problem Statement: Hang management detected a process hang and generated a ORA-32701 error message. Additionally, this event may be raised if Diagnostic Process (DIA0) process detects a hang in a critical database process.

Risk: A hang can indicate resource, operating system, or application coding related issues.

Action:

Investigate the cause of the session hang.
  1. Review TFA events for the database for the following message patterns corresponding to the date/time of the event: ORA-32701, "DIA0 Critical Database Process Blocked" or "DIA0 Critical Database Process As Root".
    [oracle@vm ~] tfactl events -database <dbName> -instance <instanceName>
  2. Review the alert.log file. 
    $ORACLE_BASE/diag/rdbms/<dbName>/<instanceName>/trace/alert_<instanceName>.log
  3. For ora-32701: An overloaded system can cause slow progress, which can be interpreted as a hang.

    The hang manager may attempt to resolve the hang by terminating the final blocker process.

  4. For DIA0 Critical Database Process messages: Review the related diagnostic lines indicating the process and the reason for the hang.

Parent topic: Remediation

HEALTH.DB_CLUSTER.CDB.BACKUP_FAILURE

Problem Statement: A daily incremental BACKUP of the CDB failed.

Risk: A failure of the backup can compromise the ability to use the backups for restore/recoverability of the database. Recoverability Point Object (RPO) and the Recoverability Time Object (RTO) can be impacted.

Action:

Review the RMAN logs corresponding to the date/time of the event. Note the event time stamp <eventTime> is in UTC, adjust as necessary for the VM's timezone.

  • For Exadata Database Service on Cloud@Customer Oracle Managed Backups or User Configured Backups under dbaascli:
    • RMAN output can be found at /var/opt/oracle/log/<DB_NAME>/obkup.

      Daily incremental logs have the following format obkup_yyyy-mm-dd_24hh:mm:ss.zzzzzzzzzzzz.log within the obkup directory. The logs are located on the lowest active node/instance of the database when the backup was initiated.

    • Review the log for any failures:
      • If the failure is due to an external event outside of RMAN, for example the backup location was full or a networking issue, resolve the external issue.

      • For other RMAN script errors, collect the diagnostic logs and open a Service Request. See DBAAS Tooling: Using dbaascli to Collect Cloud Tooling Logs and Perform a Cloud Tooling Health Check.

    • If the issue is transient or is resolved, take a new incremental backup: See dbaascli database backup.

  • For Customer owned and managed backup taken through RMAN:
    • Review the RMAN logs for the backup.
HEALTH.DB_CLUSTER.DISK_GROUP.FREE_SPACE

Problem Statement: ASM disk group space usage is at or exceeds 90%.

Risk: Insufficient ASM disk group space can cause database creation failure, tablespace and data file creation failure, automatic data file extension failure, or ASM rebalance failure.

Action:

ASM disk group used space is determined by the running the following query while connected to the ASM instance.
[opc@node ~] sudo su - grid
[grid@node ~] sqlplus / as sysasm
 
SQL> select 'ora.'||name||'.dg', total_mb, free_mb, round ((1-(free_mb/total_mb))*100,2) pct_used from v$asm_diskgroup;
 
NAME                             TOTAL_MB    FREE_MB   PCT_USED
------------------------------ ---------- ---------- ----------
ora.DATAC1.dg                    75497472    7408292      90.19
ora.RECOC1.dg                    18874368   17720208       6.11

ASM disk group capacity can be increased in the following ways:

  1. Scale Exadata VM Cluster storage to add more ASM disk group capacity. See Introduction to Scale Up or Scale Down Operations.
  2. Scale Exadata Infrastructure storage to add more ASM disk group capacity. See Overview of Elastic Storage Expansion.

DATA disk group space use can be reduced in the following ways:

  1. Drop unused data files and temp files from databases. See Dropping Data Files.
  2. Terminate unused databases (e.g. test databases). See Using the Console to Terminate a Database.

RECO disk group space use can be reduced in the following ways:

  1. Drop unnecessary Guaranteed Restore Points. See Using Normal and Guaranteed Restore Points.
  2. Delete archived redo logs or database backups already backed up outside the Flash Recovery Area (FRA). See Maintaining the Fast Recovery Area.

SPARSE disk group space use can be reduced in the following ways:

  1. Move full copy test master databases to another disk group (e.g. DATA).
  2. Drop unused snapshot databases or test master databases. See Managing Exadata Snapshots.

For more information about managing the log and diagnostic files, see Managing the Log and Diagnostic Files on Oracle Exadata Database Service on Cloud@Customer.

Managing the Log and Diagnostic Files on Oracle Exadata Database Service on Cloud@Customer

The software components in Oracle Exadata Database Service on Cloud@Customer generate a variety of log and diagnostic files, and not all these files are automatically archived and purged. Thus, managing the identification and removal of these files to avoid running out of file storage space is an important administrative task.

Database deployments on ExaDB-C@C include the cleandblogs script to simplify this administrative task. The script runs daily as a cron job on each compute node to archive key files and remove old log and diagnostic files.

The cleandblogs script operates by using the adrci (Automatic Diagnostic Repository [ADR] Command Interpreter) tool to identify and purge target diagnostic folders and files for each Oracle Home listed in /etc/oratab. It also targets Oracle Net Listener logs, audit files, and core dumps.

On ExaDB-C@C, the script is run separately as the oracle user to clean log and diagnostic files that are associated with Oracle Database, and as the grid user to clean log and diagnostic files that are associated with Oracle Grid Infrastructure.

The cleandblogs script uses a configuration file to determine how long to retain each type of log or diagnostic file. You can edit the file to change the default retention periods. The file is located at /var/opt/oracle/cleandb/cleandblogs.cfg on each compute node.

Note

Configure an optimal retention period for each type of log or diagnostic file. An insufficient retention period will hinder root cause analysis and problem investigation.
Parameter Description and Default Value

AlertRetention

Alert log (alert_instance.log) retention value in days.

Default value: 14

ListenerRetention

Listener log (listener.log) retention value in days.

Default value: 14

AuditRetentionDB

Database audit (*.aud) retention value in days.

Default value: 1

CoreRetention

Core dump/files (*.cmdp*) retention value in days.

Default value: 7

TraceRetention

Trace file (*.tr* and *.prf) retention value in days.

Default value: 7

longpRetention

Data designated in the Automatic Diagnostic Repository (ADR) as having a long life (the LONGP_POLICY attribute). For information about ADR, see Automatic Diagnostic Repository (ADR) in the Oracle Database Administrator's Guide.

Default value: 14

shortpRetention

Data designated in the Automatic Diagnostic Repository (ADR) as having a short life (the SHORTP_POLICY attribute). For information about ADR, see Automatic Diagnostic Repository (ADR) in the Oracle Database Administrator's Guide.

Default value: 7

LogRetention

Log file retention in days for files under /var/opt/oracle/log and log files in ACFS under /var/opt/oracle/dbaas_acfs/log.

Default value: 14

LogDirRetention

cleandblogs logfile retention in days.

Default value: 14

ScratchRetention

Temporary file retention in days for files under /scratch.

Default value: 7

Archiving Alert Logs and Listener Logs

When cleaning up alert and listener logs, cleandblogs first archives and compresses the logs, operating as follows:
  1. The current log file is copied to an archive file that ends with a date stamp.
  2. The current log file is emptied.
  3. The archive file is compressed using gzip.
  4. Any existing compressed archive files older than the retention period are deleted.

Running the cleandblogs Script Manually

The cleandblogs script automatically runs daily on each compute node, but you can also run the script manually if the need arises.

  1. Connect to the compute node as the oracle user to clean log and diagnostic files that are associated with Oracle Database, or connect as the grid user to clean log and diagnostic files that are associated with Oracle Grid Infrastructure.

    For detailed instructions, see Connecting to a Virtual Machine with SSH.

    Change to the directory containing the cleandblogs script:
    $ cd /var/opt/oracle/cleandb
  2. Run the cleandblogs script:
    $ ./cleandblogs.pl
    When running the script manually, you can specify an alternate configuration file to use instead of cleandblogs.cfg by using the --pfile option:
    $ ./cleandblogs.pl --pfile config-file-name
  3. Close your connection to the compute node:
    $ exit

Compute Expansion Event Types

Review the list of event types that compute expansion emits.

Table 7-24 Compute Expansion Events

Friendly Name Event Type

VM Cluster Network - Add DB Server Network Begin

com.oraclecloud.databaseservice.adddbservervmclusternetwork.begin

VM Cluster Network - Add DB Server Network Begin

com.oraclecloud.databaseservice.adddbservervmclusternetwork.end

VM Cluster Network - Remove DB Server Network Begin

com.oraclecloud.databaseservice.removedbservervmclusternetwork.begin

VM Cluster Network - Remove DB Server Network End

com.oraclecloud.databaseservice.removedbservervmclusternetwork.end

Example 7-79 Compute Expansion Event Types Examples

This is a reference event for VM Cluster Network - Add DB Server Network Begin:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrdsa7ybmw6mjndfutmibmw6a4ztvu7sgm562ojbudo3le6qwsspdq",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.adddbservervmclusternetwork.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_vmcluster_network",
      "resourceId": "VmClusterNetwork-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "UPDATING",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExadataInfra-unique_ID",
        "displayName": "testDisplayName"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "VM Cluster Network - Add DB Server Network Begin",
  "eventType": "com.oraclecloud.databaseservice.adddbservervmclusternetwork.begin",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "timeUpdated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "lifecycleDetails", "type": ["null", "string"] },
    { "name": "exadataInfrastructureId", "type": ["null", "string"] }
  ],
  "timeCreated": "2019-06-26T13:31:31.979Z"
}
This is a reference event for VM Cluster Network - Add DB Server Network Begin:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrupbmw5ksic23bmwnqc4rssbmwc23eslydoumcnr6rcum6mtmgg3a",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.adddbservervmclusternetwork.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_vmcluster_network",
      "resourceId": "VmClusterNetwork-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "NEEDS_ATTENTION",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "displayName": "testDisplayName",
        "exadataInfrastructureId": "ExadataInfra-unique_ID"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "VM Cluster Network - Add DB Server Network End",
  "eventType": "com.oraclecloud.databaseservice.adddbservervmclusternetwork.end",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "timeUpdated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "lifecycleDetails", "type": ["null", "string"] },
    { "name": "exadataInfrastructureId", "type": ["null", "string"] }
  ],
  "timeCreated": "2019-06-26T13:31:31.979Z"
}
This is a reference event for VM Cluster Network - Remove DB Server Network Begin:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrdsa7ybmw6mjndfutmifv46a4ztvu7sgm562ojbudo3le6qwsspdq",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.removedbservervmclusternetwork.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_vmcluster_network",
      "resourceId": "VmClusterNetwork-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "UPDATING",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "exadataInfrastructureId": "ExadataInfra-unique_ID",
        "displayName": "testDisplayName"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "VM Cluster Network - Remove DB Server Network Begin",
  "eventType": "com.oraclecloud.databaseservice.removedbservervmclusternetwork.begin",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "timeUpdated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "lifecycleDetails", "type": ["null", "string"] },
    { "name": "exadataInfrastructureId", "type": ["null", "string"] }
  ],
  "timeCreated": "2019-06-26T13:31:31.979Z"
}
This is a reference event for VM Cluster Network - Remove DB Server Network End:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrupbmw5ksic23bmwnqc4rsskxwc23eslydoumcnr6rcum6mtmgg3a",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.removedbservervmclusternetwork.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_vmcluster_network",
      "resourceId": "VmClusterNetwork-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "ALLOCATED",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "displayName": "testDisplayName",
        "exadataInfrastructureId": "ExadataInfra-unique_ID"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "VM Cluster Network - Remove DB Server Network End",
  "eventType": "com.oraclecloud.databaseservice.removedbservervmclusternetwork.end",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "timeUpdated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "lifecycleDetails", "type": ["null", "string"] },
    { "name": "exadataInfrastructureId", "type": ["null", "string"] }
  ],
  "timeCreated": "2019-06-26T13:31:31.979Z"
}

Serial Console Connection Event Types

Review the list of event types that serial console connection emits.

Table 7-25 Serial Console Connection Events

Friendly Name Event Type

DB Node Console Connection - Create Begin

com.oraclecloud.databaseservice.createdbnodeconsoleconnection.begin

DB Node Console Connection - Create End

com.oraclecloud.databaseservice.createdbnodeconsoleconnection.end

DB Node Console Connection - Delete Begin

com.oraclecloud.databaseservice.deletedbnodeconsoleconnection.begin

DB Node Console Connection - Delete End

com.oraclecloud.databaseservice.deletedbnodeconsoleconnection.end

DB Node Console Connection - Update

com.oraclecloud.databaseservice.updatedbnodeconsoleconnection

DB Node - Update

com.oraclecloud.databaseservice.updatedbnode

Example 7-80 Serial Console Connection Event Types Examples

This is a reference event for DB Node Console Connection - Create Begin:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.createdbnodeconsoleconnection.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceId": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
      "lifecycleState": "CREATING",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
      "tenantId": "ocid1.tenant.oc1..unique_ID",
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    }
  }
}
This is a reference event for DB Node Console Connection - Create End:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.createdbnodeconsoleconnection.end",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceId": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
      "lifecycleState": "ACTIVE",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
      "tenantId": "ocid1.tenant.oc1..unique_ID",
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    }
  }
}
This is a reference event for DB Node Console Connection - Delete Begin:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.deletedbnodeconsoleconnection.begin",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceId": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
      "lifecycleState": "DELETING",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
      "tenantId": "ocid1.tenant.oc1..unique_ID",
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    }
  }
}
This is a reference event for DB Node Console Connection - Delete End:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.deletedbnodeconsoleconnection.end",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceId": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
      "lifecycleState": "DELETED",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
      "tenantId": "ocid1.tenant.oc1..unique_ID",
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    }
  }
}
This is a reference event for DB Node Console Connection - Update:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.updatedbnodeconsoleconnection",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-08-29T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "resourceId": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.dbnodeconsoleconnection.oc1..unique_ID",
      "lifecycleState": "ACTIVE",
      "timeCreated": "2019-08-29T12:00:00.000Z",
      "timeUpdated": "2019-08-29T12:30:00.000Z",
      "lifecycleDetails": "detail message",
      "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
      "tenantId": "ocid1.tenant.oc1..unique_ID",
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    }
  }
}
This is a reference event for DB Node - Update:
"exampleEvent": {
  "cloudEventsVersion": "0.1",
  "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.updatedbnode",
  "source": "databaseservice",
  "eventTypeVersion": "1.0",
  "eventTime": "2019-06-27T21:16:04.000Z",
  "contentType": "application/json",
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID"
  },
  "data": {
    "compartmentId": "ocid1.compartment.oc1..unique_ID",
    "compartmentName": "example_name",
    "resourceName": "my_dbnode",
    "resourceId": "DbNode-unique_ID",
    "availabilityDomain": "all",
    "freeFormTags": {},
    "definedTags": {},
    "additionalDetails": {
      "id": "ocid1.id..oc1...unique_ID",
      "lifecycleState": "AVAILABLE",
      "timeCreated": "2019-08-26T12:00:00.000Z",
      "timeUpdated": "2019-08-26T12:30:00.000Z",
      "dbSystemId": "ocid1.dbsystem.oc1.phx.unique_ID",
      "lifecycleDetails": "detail message",
      "vmClusterId": "VmCluster-unique_ID",
      "dbHostId": "dbHost-unique_ID",
      "nodeNumber": 2,
      "powerAction": "HardReset",
      "hostName": "testHostName"
    }
  }
}
  • Viewing Audit Log Events
    Oracle Cloud Infrastructure Audit service provides records of API operations performed against supported services as a list of log events.

Parent topic: Oracle Exadata Database Service on Cloud@Customer Events

Viewing Audit Log Events

Oracle Cloud Infrastructure Audit service provides records of API operations performed against supported services as a list of log events.

An audit event is generated when you connect to the serial console using a Secure Shell (SSH) connection. Navigate to Audit in the Console and search for VmConsoleConnected. When you navigate to Audit in the Console, a list of results is generated for the current compartment. Audit logs are organized by compartment, so if you are looking for a particular event, you must know which compartment the event occurred in. You can filter the list in the following ways:

  • Date and time
  • Request Action Types (operations)
  • Keywords

For more information, see Viewing Audit Log Events.

Example 7-81 Serial Console Connection Audit Event Example

This is a reference event for Serial Console Connection:
{
 
  "eventType": "VmConsoleConnected",
  "cloudEventsVersion": "0.1",
  "eventTypeVersion": "2.0",
  "source": "VmConsoleConnectionAPI",
  "eventId": "2367d627-cff8-11ed-bfd3-02001714f979",
  "eventTime": "2023-03-31T19:13:37.120Z",
  "contentType": "application/json",
 
  "data": {
    "eventGroupingId": "2367d62d-cff8-11ed-bfd3-02001714f979",
    "eventName": "VmConsoleConnected",
    "compartmentId": "ocid1.compartment.oc1..<TRUNCATED>aaaaxxxxx",
    "compartmentName": "exacc-dev",
    "resourceName": "",
    "resourceId": "ocid1.dbnodeconsoleconnection.oc1.iad.<TRUNCATED>aaaaaaxxxxx",
    "availabilityDomain": null,
    "freeformTags": null,
    "definedTags": null,
 
    "identity": {
      "principalName": "dsaes",
      "principalId": "ocid1.user.oc1..<TRUNCATED>aaaaaaaaaxxxxxxxxxx",
      "authType": "Native",
      "callerName": null,
      "callerId": null,
      "tenantId": "ocid1.tenancy.oc1..<TRUNCATED>aaaaaaxxxxx",
      "ipAddress": null,
      "credentials": null,
      "userAgent": null,
      "consoleSessionId": null
    },
 
    "request": {
      "id": "",
      "path": "",
      "action": "",
      "parameters": null,
      "headers": null
   },
 
    "response": {
      "status": "",
      "responseTime": "0001-01-01T00:00:00.000Z",
      "headers": null,
      "payload": null,
      "message": ""
    },
 
    "stateChange": null,
 
    "additionalDetails": {
      "DBNodeId": "ocid1.dbnode.oc1.iad.<TRUNCATED>aaaaaxxxxxxx"
    }
  }
}

Serial Console History Event Types

Review the list of new event types that serial console history emits.

Table 7-26 Serial Console History Events

User Action Event Type Friendly Name Event Type

Create Console History

Async

DB Node Console History - Create Begin

com.oraclecloud.databaseservice.createdbnodeconsolehistory.begin

DB Node Console History - Create End

com.oraclecloud.databaseservice.createdbnodeconsolehistory.end

Terminate Console History

Async

DB Node Console History - Delete Begin

com.oraclecloud.databaseservice.deletedbnodeconsolehistory.begin

DB Node Console History - Delete End

com.oraclecloud.databaseservice.deletedbnodeconsolehistory.end

Update Console History

Sync

DB Node Console History - Update

com.oraclecloud.databaseservice.updatedbnodeconsolehistory

Get Console History Content

Sync

DB Node Console History - Get Content

com.oraclecloud.databaseservice.getdbnodeconsolehistorycontent

Example 7-82 Serial Console History Event Types Examples

This is a reference event for DB Node Console History - Create Begin:
"exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
  "eventType": "com.oraclecloud.databaseservice.createdbnodeconsolehistory.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "resourceId": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
        "displayName": "console-history-20230808-0012",
        "lifecycleState": "REQUESTED",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
        "tenantId": "ocid1.tenant.oc1..unique_ID",
        "compartmentId": "ocid1.compartment.oc1..unique_ID"
      }
    }
This is a reference event for DB Node Console History - Create End:
"exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createdbnodeconsolehistory.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "resourceId": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
        "displayName": "console-history-20230808-0012",
        "lifecycleState": "SUCCEEDED",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
        "tenantId": "ocid1.tenant.oc1..unique_ID",
        "compartmentId": "ocid1.compartment.oc1..unique_ID"
      }
    }
This is a reference event for DB Node Console History - Delete Begin:
"exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.deletedbnodeconsolehistory.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "resourceId": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
        "displayName": "console-history-20230808-0012",
        "lifecycleState": "DELETING",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
        "tenantId": "ocid1.tenant.oc1..unique_ID",
        "compartmentId": "ocid1.compartment.oc1..unique_ID"
      }
    }
This is a reference event for DB Node Console History - Delete End:
"exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.deletedbnodeconsolehistory.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "resourceId": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
        "displayName": "console-history-20230808-0012",
        "lifecycleState": "DELETED",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
        "tenantId": "ocid1.tenant.oc1..unique_ID",
        "compartmentId": "ocid1.compartment.oc1..unique_ID"
      }
    }
This is a reference event for DB Node Console History - Update:
"exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.updatedbnodeconsolehistory",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "resourceId": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
        "displayName": "console-history-20230808-0012",
        "lifecycleState": "SUCCEEDED",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
        "tenantId": "ocid1.tenant.oc1..unique_ID",
        "compartmentId": "ocid1.compartment.oc1..unique_ID"
      }
    }
This is a reference event for DB Node Console History - Get Content:
"exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b56a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.getdbnodeconsolehistorycontent",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2019-08-29T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "resourceId": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.dbnodeconsolehistory.oc1..unique_ID",
        "displayName": "console-history-20230808-0012",
        "lifecycleState": "SUCCEEDED",
        "timeCreated": "2019-08-29T12:00:00.000Z",
        "timeUpdated": "2019-08-29T12:30:00.000Z",
        "lifecycleDetails": "detail message",
        "dbnodeId": "ocid1.dbnode.oc1..unique_ID",
        "tenantId": "ocid1.tenant.oc1..unique_ID",
        "compartmentId": "ocid1.compartment.oc1..unique_ID"
      }
    }

Interim Software Updates Event Types

Table 7-27 Interim Software Updates Events

Friendly Name Event Type

Oneoff Patch - Create Begin

com.oraclecloud.databaseservice.createoneoffpatch.begin

Oneoff Patch - Create End

com.oraclecloud.databaseservice.createoneoffpatch.end

Oneoff Patch - Delete Begin

com.oraclecloud.databaseservice.deleteoneoffpatch.begin

Oneoff Patch - Delete End

com.oraclecloud.databaseservice.deleteoneoffpatch.end

Oneoff Patch - Download Begin

com.oraclecloud.databaseservice.downloadoneoffpatch.begin

Oneoff Patch - Download End

com.oraclecloud.databaseservice.downloadoneoffpatch.end

Example 7-83 One-Off Patches Event Types Examples

This is a reference event for Oneoff Patch - Create Begin:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrsllp7rfneajgq2knxbqopwux24za7qzoe3mfj2bzfxtnwqcxpbcq",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b59a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createoneoffpatch.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2020-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_oneoffpatch",
      "resourceId": "OneOffPatch-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2020-08-26T12:00:00.000Z",
        "displayName": "testDisplayName",
        "databaseVersion": "19.6.0.0",
        "patchSet": "test_patch_set"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "Oneoff Patch - Create Begin",
  "eventType": "com.oraclecloud.databaseservice.createoneoffpatch.begin",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "dbVersion", "type": "string" },
    { "name": "patchType", "type": "string" },
    { "name": "patchShapeFamily", "type": "string" },
    { "name": "releaseUpdate", "type": "string" }
  ],
  "timeCreated": "2020-06-26T13:31:31.979Z"
}
This is a reference event for Oneoff Patch - Create End:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrj4vvuph4qvj5eateeel6axblhkq3caqndgmjvwl3sldpgb255j2q",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b59a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.createoneoffpatch.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2020-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_oneoffpatch",
      "resourceId": "OneOffPatch-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2020-08-26T12:00:00.000Z",
        "displayName": "testDisplayName",
        "databaseVersion": "19.6.0.0",
        "patchSet": "test_patch_set"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "Oneoff Patch - Create End",
  "eventType": "com.oraclecloud.databaseservice.createoneoffpatch.end",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "dbVersion", "type": "string" },
    { "name": "patchType", "type": "string" },
    { "name": "patchShapeFamily", "type": "string" },
    { "name": "releaseUpdate", "type": "string" }
  ],
  "timeCreated": "2020-06-26T13:31:31.979Z"
}
This is a reference event for Oneoff Patch - Delete Begin:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrdripga5rryplwmv4ws6hqzr3pjyl7wfvoaqutvg2ey2vtycn5onq",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b59a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.deleteoneoffpatch.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2020-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_oneoffpatch",
      "resourceId": "OneOffPatch-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2020-08-26T12:00:00.000Z",
        "displayName": "testDisplayName",
        "databaseVersion": "19.6.0.0",
        "patchSet": "test_patch_set"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "Oneoff Patch - Delete Begin",
  "eventType": "com.oraclecloud.databaseservice.deleteoneoffpatch.begin",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "dbVersion", "type": "string" },
    { "name": "patchType", "type": "string" },
    { "name": "patchShapeFamily", "type": "string" },
    { "name": "releaseUpdate", "type": "string" }
  ],
  "timeCreated": "2020-06-26T13:31:31.979Z"
}
This is a reference event for Oneoff Patch - Delete End:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrgwk2gvx5lmx6fiwotgdy32mdmrnkyzznz37dpb4mmehgzt37vl7a",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b59a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.deleteoneoffpatch.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2020-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_oneoffpatch",
      "resourceId": "OneOffPatch-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2020-08-26T12:00:00.000Z",
        "displayName": "testDisplayName",
        "databaseVersion": "19.6.0.0",
        "patchSet": "test_patch_set"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "Oneoff Patch - Delete End",
  "eventType": "com.oraclecloud.databaseservice.deleteoneoffpatch.end",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "dbVersion", "type": "string" },
    { "name": "patchType", "type": "string" },
    { "name": "patchShapeFamily", "type": "string" },
    { "name": "releaseUpdate", "type": "string" }
  ],
  "timeCreated": "2020-06-26T13:31:31.979Z"
}
This is a reference event for Oneoff Patch - Download Begin:
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljr3vkb7klt5hkbsnqzjaxmszsqomanlbqmr2tsrcq7xafcv2c74l2q",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b59a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.downloadoneoffpatch.begin",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2020-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_oneoffpatch",
      "resourceId": "OneOffPatch-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2020-08-26T12:00:00.000Z",
        "displayName": "testDisplayName",
        "databaseVersion": "19.6.0.0",
        "patchSet": "test_patch_set"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "Oneoff Patch - Download Begin",
  "eventType": "com.oraclecloud.databaseservice.downloadoneoffpatch.begin",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "dbVersion", "type": "string" },
    { "name": "patchType", "type": "string" },
    { "name": "patchShapeFamily", "type": "string" },
    { "name": "releaseUpdate", "type": "string" }
  ],
  "timeCreated": "2020-06-26T13:31:31.979Z"
}
This is a reference event for Oneoff Patch - Download End: 
{
  "id": "ocid1.eventschema.oc1.phx.abyhqljrn2lruez55ah56kqksi5qfg6m7igvven7o2qkahlk5tkwrj5ll3oa",
  "exampleEvent": {
    "cloudEventsVersion": "0.1",
    "eventID": "60600c06-d6a7-4e85-b59a-1de3e6042f57",
    "eventType": "com.oraclecloud.databaseservice.downloadoneoffpatch.end",
    "source": "databaseservice",
    "eventTypeVersion": "1.0",
    "eventTime": "2020-06-27T21:16:04.000Z",
    "contentType": "application/json",
    "extensions": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID"
    },
    "data": {
      "compartmentId": "ocid1.compartment.oc1..unique_ID",
      "compartmentName": "example_name",
      "resourceName": "my_oneoffpatch",
      "resourceId": "OneOffPatch-unique_ID",
      "availabilityDomain": "all",
      "freeFormTags": {},
      "definedTags": {},
      "additionalDetails": {
        "id": "ocid1.id..oc1...unique_ID",
        "lifecycleState": "AVAILABLE",
        "timeCreated": "2020-08-26T12:00:00.000Z",
        "displayName": "testDisplayName",
        "databaseVersion": "19.6.0.0",
        "patchSet": "test_patch_set"
      }
    }
  },
  "serviceName": "Database",
  "displayName": "Oneoff Patch - Download End",
  "eventType": "com.oraclecloud.databaseservice.downloadoneoffpatch.end",
  "additionalDetails": [
    { "name": "id", "type": "string" },
    { "name": "lifecycleState", "type": "string" },
    { "name": "timeCreated", "type": "string" },
    { "name": "displayName", "type": "string" },
    { "name": "dbVersion", "type": "string" },
    { "name": "patchType", "type": "string" },
    { "name": "patchShapeFamily", "type": "string" },
    { "name": "releaseUpdate", "type": "string" }
  ],
  "timeCreated": "2020-06-26T13:31:31.979Z"
}