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.
- 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. - Exadata Infrastructure Event Types
Review the list of event types that Exadata Infrastructure instances emit. - VM Cluster Network Event Types
Review the list of event types that VM cluster networks emit. - VM Cluster Event Types
Review the list of event types that VM clusters emit. - Backup Destination Event Types
Review the list of event types that backup destinations emit. - Database Node Event Types (Oracle Exadata Database Service on Cloud@Customer)
Review the list of event types that database nodes emit. - Database Home Event Types (Oracle Exadata Database Service on Cloud@Customer)
Review the list of event types that Database Homes emit. - Database Event Types (Oracle Exadata Database Service on Cloud@Customer)
Review the list of event types that databases emit. - Database and Grid Infrastructure Patching Event Types
Review the list of event types that Database and Grid Infrastructure Patching emit. - Autonomous VM Cluster Event Types
Review the list of event types that Autonomous VM clusters emit. - Autonomous Container Database Event Types
Review the list of event types that Autonomous Container Database emit. - Autonomous Database Event Types
Review the list of event types that Autonomous Database emit. - Data Guard Event Types
Review the list of event types that Data Guard associations emit. - Autonomous Data Guard Association Event Types
Review the list of event types that Autnomous Data Guard associations emit. - Key Store Event Types
Review the list of event types that Key Store emits. - Exadata Infrastructure Maintenance Event Types
Review the list of event types that Exadata Infrastructure Maintenance emits. - Storage Expansion Event Types
Review the list of event types that storage expansion emits. - Database Software Images Event Types
Review the list of event types that Database Software Image emits. - Database Upgrade Event Types
Review the list of event types that Database Upgrade emit. - Pluggable Database Event Types
Review the list of event types that Pluggable Databases emit. - VM Node Subsetting Event Types
Review the list of event types that VM Node Subsetting emits. - Database Service Events
The Database Service emits events, which are structured messages that indicate changes in resources. - Compute Expansion Event Types
Review the list of event types that compute expansion emits. - Serial Console Connection Event Types
Review the list of event types that serial console connection emits. - Serial Console History Event Types
Review the list of new event types that serial console history emits. - Interim Software Updates Event Types
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.
Related Topics
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-59 Exadata Infrastructure Example
{
"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"
}
}
}
{
"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"
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-60 VM Cluster Network Example
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-61 VM Cluster Example
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
Example 7-62 Backup Destination Example
{
"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": {}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
Example 7-63 Database Node Example
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-64 Database Home Example
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-65 Database Example
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-66 Database Example
{
"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"
}
}
}
{
"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"
}
}
}
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-67 Autonomous VM Cluster Examples
{
"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"
}
}
}
{
"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"
}
}
}
{
"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"
}
}
}
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-68 Autonomous Container Database Examples
{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={}}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Autonomous Database Event Types
Review the list of event types that Autonomous Database emit.
Table 7-12 Autonomous Database Events
Friendly Name | Event Type |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-69 Data Guard Associations Examples
{
"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"
}
}
}
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-70 Autonomous Data Guard Associations Examples
{
"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,
}
}
}
{
"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,
}
}
}
{
"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,
}
}
}
{
"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,
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Key Store Event Types
Review the list of event types that Key Store emits.
Table 7-15 Key Store Events
Friendly Name | Event Type |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-71 Key Store Example
{
"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",
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|---|
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure You will get a notification on the start of the quarterly maintenance update. |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure You will get a notification on the completion of the quarterly maintenance update. |
|
|
Success: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure Failed: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure Canceled: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure Duration Exceeded: This is an Oracle Cloud Operations notification for quarterly maintenance update of your ExaDB-C@C Exadata Infrastructure 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. |
|
|
This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure You will get a notification on the completion of the custom action time for the Database Server. |
|
|
This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for custom action time configured for your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Network Switches of your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Network Switches of your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Storage Servers of your ExaDB-C@C Exadata Infrastructure You will get a notification on the completion of the quarterly maintenance update for the Storage Servers. |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Storage Servers of your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure You will get a notification on the completion of the quarterly maintenance update for the Database Server. |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure You will get a notification on the completion of the quarterly maintenance update for the Database Servers. |
|
|
This is an Oracle Cloud Operations notification for quarterly maintenance update of the Database Server component of your ExaDB-C@C Exadata Infrastructure |
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Storage Expansion Event Types
Review the list of event types that storage expansion emits.
Table 7-17 Storage Expansion Events
Friendly Name | Event Type |
---|---|
|
|
|
|
Example 7-72 Storage Expansion Events Examples
"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"
}
}
}
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
|
|
Delete Database Software Image |
|
|
List Database Software Images |
|
|
Get Database Software Image |
|
|
Change compartment of Database Software Image |
|
|
Update Database Software Image |
|
|
Example 7-73 Database Software Image Events Examples
{
"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"
}
}
}
{
"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"
}
}
}
{
"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"
}
}
}
{
"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"
}
}
}
{
"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
}
}
{
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Database Upgrade Event Types
Review the list of event types that Database Upgrade emit.
Table 7-19 Database Upgrade Events
Friendly Name | Event Type |
---|---|
|
|
|
|
Example 7-74 Database Upgrade Examples
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"
}
}
}
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"
}
}
}
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"
}
}
}
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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Pluggable Database Event Types
Review the list of event types that Pluggable Databases emit.
Table 7-20 Pluggable Database Events
Friendly Name | Event Type |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-75 Pluggable Database Examples
{
“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”
}
}
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
"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"
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
Example 7-76 VM Node Subsetting Examples
"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"
}
}
}
"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"
}
}
}
"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"
}
}
}
"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"
}
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Database Service Events
The Database Service emits events, which are structured messages that indicate changes in resources.
- Overview of Database Service Events
- Receive Notifications about Database Service Events
Subscribe to the Database Service Events and get notified. - Database Service Event Types
Review the list of event types that the Database Service emits. - Temporarily Restrict Automatic Diagnostic Collections for Specific Events
Use thetfactl blackout
command to temporarily suppress automatic diagnostic collections. - Remediation
These topics cover some common issues you might run into and how to address them.
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.
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 asroot
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 asroot
:# 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 asroot
:# 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 asroot
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 asroot
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 asroot
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 theroot
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.
- Database - Critical
- DB Node - Critical
- DB Node - Error
- DB Node - Warning
- DB Node - Info
- DB System - Critical
Related Topics
Parent topic: Database Service Events
Database Service Event Types
Review the list of event types that the Database Service emits.
- 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 |
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:
|
|
Critical threshold: 90% |
|
Disk Issues |
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:
|
|
N/A |
|
Memory Usage |
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. |
|
90% |
|
sshd Configuration |
An event of type CRITICAL is created if unexpected values are set in
the |
|
N/A |
|
Oracle EXAchk Reported Issues |
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. |
|
N/A |
|
CRS status Up/Down |
An event of type CRITICAL is created when the Cluster Ready Service (CRS) is detected to be down. |
|
N/A |
|
An event of type INFORMATION is created once it is determined that the event for CRS down has cleared. |
N/A |
|
||
SCAN Listener Up/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 ( There are three SCAN listeners per cluster called LISTENER_SCAN[1,2,3]. |
|
N/A |
|
An event of type INFORMATION is created once it is determined that the event for SCAN Listener down has cleared. |
N/A |
|
||
Net Listener Up/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 ( There is one client listener per node, each called LISTENER. |
|
N/A |
|
An event of type INFORMATION is created once it is determined that the event for Client Listener down has cleared. |
N/A |
|
||
CDB Up/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 ( |
|
N/A |
|
An event of type INFORMATION is created once it is determined that the event for the CDB down has cleared. |
N/A |
|
||
Critical DB Errors |
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. |
|
N/A |
|
Other DB Errors |
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. |
|
N/A |
|
An event of type CRITICAL is created when a process/session hang is detected in the CDB. |
||||
Backup Failures |
An event of type CRITICAL is created if there is a CDB backup with a
FAILED status reported in the |
|
N/A |
|
Disk Group Usage |
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%. |
|
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
{
"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 |
---|---|
|
Adds, removes, or prints blackout conditions. |
Target type:
|
Limits blackout only to the specified target type.
|
|
Specify the target for blackout. You can specify a comma-delimited list of targets. By default, the target is set to |
|
Specify the database container
name ( |
|
Specify the PDB where the blackout
will take effect (for
|
|
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.
string: Blackout for incidents where any part of the line contains the strings specified. Specify a comma-delimited list of strings. |
|
Specify the duration for blackout in number of hours or days before timing out. By default, the timeout is set to 24 hours (24h). |
|
Specify if blackout should be set to cluster-wide or local. By default, blackout is set to |
|
Specify a descriptive reason for the blackout. |
|
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
- HEALTH.DB_GUEST.FILESYSTEM.CORRUPTION
- CONFIGURATION.DB_GUEST.MEMORY.HUGEPAGES_TOO_LARGE
- CONFIGURATION.DB_GUEST.SSHD.INVALID
- HEALTH.DB_CLUSTER.EXACHK.CRITICAL_ALERT
- AVAILABILITY.DB_GUEST.CRS_INSTANCE.DOWN
- AVAILABILITY.DB_CLUSTER.SCAN_LISTENER.DOWN
- AVAILABILITY.DB_GUEST.CLIENT_LISTENER.DOWN
- AVAILABILITY.DB_GUEST.CDB_INSTANCE.DOWN
- HEALTH.DB_CLUSTER.CDB.CORRUPTION
- HEALTH.DB_CLUSTER.CDB.ARCHIVER_HANG
- HEALTH.DB_CLUSTER.CDB.DATABASE_HANG
- HEALTH.DB_CLUSTER.CDB.BACKUP_FAILURE
- HEALTH.DB_CLUSTER.DISK_GROUP.FREE_SPACE
- Managing the Log and Diagnostic Files on Oracle Exadata Database Service on Cloud@Customer
Parent topic: Database Service Events
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:
- 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.
- 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. - (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. - 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:
- Stop running services, if any, that are using the file system, such as Oracle Clusterware, Trace File Analyzer (TFA), and Enterprise Manager (EM) agent.
- Unmount the file system.
- 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.
- Mount the file system.
- 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.
Parent topic: Remediation
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:
- Reduce HugePages memory use. To determine the proper setting for operating system parameter vm.nr_hugepages, see My Oracle Support document 361323.1.
- Scale up VM memory. For more information about scaling VM memory, see Introduction to Scale Up or Scale Down Operations.
Related Topics
Parent topic: Remediation
CONFIGURATION.DB_GUEST.SSHD.INVALID
Problem Statement: SSHD configuration is unexpected.
SSHD Configuration Setting | Expected Value |
---|---|
|
yes |
|
This file must exist in |
|
no |
|
yes |
|
yes |
|
no |
|
no |
|
no |
|
no |
|
yes |
|
no |
|
yes |
|
no |
|
delayed |
|
100 |
|
Must contain one of the following:
|
|
sftp
|
|
2 |
|
|
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.
- 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
- 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
- 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
- Edit
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:
- On-disk corruption or data loss
- Intermittent wrong results with Exadata feature usage (e.g. smart scan)
- System wide availability impact
- Severe system wide performance impact seriously affecting application service Service Level Agreements (SLAs)
- Compromised redundancy and inability to restore redundancy
- Inability to update software in a rolling manner
- 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).
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).
Related Topics
Parent topic: Remediation
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:
- Check if CRS was stopped by your administrator, as part of a planned maintenance
event, or a scale up or down of local storage.
- The following patching events will stop CRS:
- GRID Patching
- Exadata VM patching of Guest
- Exadata VM Patching of Host
- The following patching events will stop CRS:
- If CRS has stopped unexpectedly, then the current status can be checked by issuing
the
crsctl check crs
command.- 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.
- 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
- 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.
- Restart the CRS, by issuing the
crsctl start crs
command. - 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
- 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.
- 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.
- Login to the VM as
opc
user andsudo
to thegrid
user:[opc@vm ~] sudo su - grid
- Check the SCAN listener status on any
node:
[grid@vm ~] srvctl status scan_listener
- Start the SCAN
listener:
[grid@vm ~] srvctl start scan_listener
- Recheck the SCAN listeners status on any node:
If the
scan_listener
is still down, then investigate the cause of the scan listener failure:- 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. Fortfactl
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"
- Review the SCAN listener log located under
/u01/app/grid/diag/tnslsnr/<hostName>/<listenerName>/trace
- Collect both the CRS and operating system logs 30 minutes prior and 10
minutes for the <
Parent topic: Remediation
AVAILABILITY.DB_GUEST.CLIENT_LISTENER.DOWN
Problem Statement: A client listener is down and unable to accept application connections.
- 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
- 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.
- 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.
- Login to the VM as
opc
user andsudo
to thegrid
user:[opc@vm ~] sudo su - grid
- Check the client listener status on any
node:
[grid@vm ~] srvctl status listener
- Start the client
listener:
[grid@vm ~] srvctl start listener
- Recheck the client listener status on any node:
If the client listener is still down, then investigate the cause of the client listener failure:
- 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"
- Review the listener log located under
/u01/app/grid/diag/tnslsnr/<hostName>/<listenerName>/trace
- Use tfactl to collect both the CRS and operating system logs 30
minutes prior and 10 minutes for the
<
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.
- 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.
- If the event was caused by user action, then start the affected database instance at the next opportunity.
DOWN event of type CRITICAL
- Check database status and restart the down database instance.
- Login to the VM as
oracle
user: - Set the
environment:
[oracle@vm ~] . <dbName>.env
- Check the database
status:
[oracle@vm ~] srvctl status database -db <dbName>
- Start the database
instance:
[oracle@vm ~] srvctl start instance -db <dbName> -instance <instanceName>
- Login to the VM as
- Investigate the cause of the database instance failure.
- Review Trace File Analyzer (TFA) events for the
database:
[oracle@vm ~] tfactl events -database <dbName> -instance <instanceName>
- Review the database alert log located at
$ORACLE_BASE/diag/rdbms/<dbName>/<instanceName>/trace/alert_<instanceName>.log
- Review Trace File Analyzer (TFA) events for the
database:
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.
- 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).
- 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.
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).
- 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.
- For repair recommendations, refer to Handling Oracle Database Corruption Issues (Doc ID 1088018.1).
- 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.
- 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)
- 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)
Related Topics
- Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1)
- OERR: ORA-1578 "ORACLE data block corrupted (file # %s, block # %s)" Primary Note (Doc ID 1578.1)
- How to identify all the Corrupted Objects in the Database with RMAN (Doc ID 472231.1)
- How to identify the corrupt Object reported by ORA-1578 / RMAN / DBVERIFY (Doc ID 819533.1)
- Resolving ORA-00752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)
- Resolving Logical Block Corruption Errors in a Physical Standby Database (Doc ID 2821699.1)
Parent topic: Remediation
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.
- 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.
- Add a redo log group for each thread. The additional redo log should equal the
current log size.
- 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
- 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>
- Use the following
query:
- Resize the online redo logs by adding larger redo logs and dropping the
current smaller redo logs.
- 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
- 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.
-
alter database add logfile thread <thread_number> Group <max group + 1> ('<DATA_DISKGROUP>') size <new_redo_size_in_bytes>
- 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#>
-
- Use the following
query:
- 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:
- 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>
- Review the
alert.log
file.$ORACLE_BASE/diag/rdbms/<dbName>/<instanceName>/trace/alert_<instanceName>.log
- 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.
- 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 theobkup
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.
- RMAN output can be found at
- 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:
[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:
- Scale Exadata VM Cluster storage to add more ASM disk group capacity. See Introduction to Scale Up or Scale Down Operations.
- 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:
- Drop unused data files and temp files from databases. See Dropping Data Files.
- 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:
- Drop unnecessary Guaranteed Restore Points. See Using Normal and Guaranteed Restore Points.
- 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:
- Move full copy test master databases to another disk group (e.g. DATA).
- 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.
Related Topics
- Introduction to Scale Up or Scale Down Operations
- Overview of Elastic Storage Expansion
- Dropping Data Files
- Using the Console to Terminate a Database
- Using Normal and Guaranteed Restore Points
- Maintaining the Fast Recovery Area
- Managing Exadata Snapshots
- Managing the Log and Diagnostic Files on Oracle Exadata Database Service on Cloud@Customer
Parent topic: Remediation
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.
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 |
---|---|
|
Alert log ( Default value: 14 |
|
Listener log ( Default value: 14 |
|
Database audit ( Default value: 1 |
|
Core dump/files ( Default value: 7 |
|
Trace file ( Default value: 7 |
|
Data designated in the Automatic Diagnostic Repository (ADR) as
having a long life (the Default value: 14 |
|
Data designated in the Automatic Diagnostic Repository (ADR) as
having a short life (the Default value: 7 |
|
Log file retention in days for files under
Default value: 14 |
|
Default value: 14 |
|
Temporary file retention in days for files under
Default value: 7 |
Archiving Alert Logs and Listener Logs
cleandblogs
first archives
and compresses the logs, operating as follows:
- The current log file is copied to an archive file that ends with a date stamp.
- The current log file is emptied.
- The archive file is compressed using
gzip
. - 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.
- Connect to the compute node as the
oracle
user to clean log and diagnostic files that are associated with Oracle Database, or connect as thegrid
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
- Run the
cleandblogs
script:$ ./cleandblogs.pl
When running the script manually, you can specify an alternate configuration file to use instead ofcleandblogs.cfg
by using the--pfile
option:$ ./cleandblogs.pl --pfile config-file-name
- Close your connection to the compute node:
$ exit
Parent topic: Remediation
Compute Expansion Event Types
Review the list of event types that compute expansion emits.
Table 7-24 Compute Expansion Events
Friendly Name | Event Type |
---|---|
|
|
|
|
|
|
|
|
Example 7-79 Compute Expansion Event Types Examples
{
"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"
}
{
"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"
}
{
"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"
}
{
"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"
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Example 7-80 Serial Console Connection Event Types Examples
"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"
}
}
}
"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"
}
}
}
"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"
}
}
}
"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"
}
}
}
"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"
}
}
}
"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
{
"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"
}
}
}
Parent topic: Serial Console Connection Event Types
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 |
|
DB Node Console History - Create End |
|
||
Terminate Console History |
Async |
DB Node Console History - Delete Begin |
|
DB Node Console History - Delete End |
|
||
Update Console History |
Sync |
DB Node Console History - Update |
|
Get Console History Content |
Sync |
DB Node Console History - Get Content |
|
Example 7-82 Serial Console History Event Types Examples
"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"
}
}
"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"
}
}
"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"
}
}
"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"
}
}
"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"
}
}
"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"
}
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events
Interim Software Updates Event Types
Table 7-27 Interim Software Updates Events
Friendly Name | Event Type |
---|---|
Oneoff Patch - Create Begin |
|
Oneoff Patch - Create End |
|
Oneoff Patch - Delete Begin |
|
Oneoff Patch - Delete End |
|
Oneoff Patch - Download Begin |
|
Oneoff Patch - Download End |
|
Example 7-83 One-Off Patches Event Types Examples
{
"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"
}
{
"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"
}
{
"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"
}
{
"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"
}
{
"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"
}
{
"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"
}
Parent topic: Oracle Exadata Database Service on Cloud@Customer Events