Event Types for External Database
External database resources emit events, which are structured messages that indicate changes in resources.
You may subscribe to events and be notified when they occur using the Oracle Notification service. For more information, see Overview of Notifications.
External Database Connector Event Types
The following are the event types that external database connector resources emit.
Table 4-9 External Database Connector Event Types
| Friendly Name | Event Type |
|---|---|
| External Database Connector - Check Status Begin | com.oraclecloud.databaseservice.checkexternaldatabaseconnectorconnectionstatus.begin |
| External Database Connector - Check Status End | com.oraclecloud.databaseservice.checkexternaldatabaseconnectorconnectionstatus.end |
| External Database Connector - Create Begin | com.oraclecloud.databaseservice.createexternaldatabaseconnector.begin |
| External Database Connector - Create End | com.oraclecloud.databaseservice.createexternaldatabaseconnector.end |
| External Database Connector - Delete | com.oraclecloud.databaseservice.deleteexternaldatabaseconnector |
| External Database Connector - Update Begin | com.oraclecloud.databaseservice.updateexternaldatabaseconnector.begin |
| External Database Connector - Update End | com.oraclecloud.databaseservice.updateexternaldatabaseconnector.end |
Example 4-1 External Database Connector Example Event
This is a reference event for external database connectors.
{
"compartmentId": "ocid1.compartment.oc1.......unique_id",
"compartmentName": "example_name",
"resourceName": "Example connector display name",
"resourceId": "ocid1.externaldatabaseconnector.oc1.....unique_id",
"availabilityDomain": "XXIT:PHX-AD-1",
"freeFormTags": {},
"definedTags": {},
"additionalDetails": {
"id": "ocid1.externaldatabaseconnector.oc1.....unique_id",
"timeCreated": "2020-11-13T21:15:59.000Z",
"timeUpdated": "2020-11-13T21:15:59.000Z",
"connectorType": "MACS",
"connectorAgentId": "ocid1.macsagent.oc1......uniqiue_id",
"lifecycleState": "AVAILABLE",
"lifecycleDetails": "External External Database Connector is available",
"externalDatabaseId": "ExampleDBId",
"connectionStatus": "AVAILABLE",
"connectionStatusLastUpdated": "2020-11-13T22:15:59.000Z",
"timeZone": "US/Pacific"
}
}External Non-Container Database Event Types
The following are the event types that external non-container database resources emit.
Table 4-10 External Non-Container Database Event Types
| Friendly Name | Event Type |
|---|---|
| External Non-Container Database - Change Compartment Begin | com.oraclecloud.databaseservice.changeexternalnoncontainerdatabasecompartment.begin |
| External Non-Container Database - Change Compartment End | com.oraclecloud.databaseservice.changeexternalnoncontainerdatabasecompartment.end |
| External Non-Container Database - Create | com.oraclecloud.databaseservice.createexternalnoncontainerdatabase |
| External Non-Container Database - Delete Begin | com.oraclecloud.databaseservice.deleteexternalnoncontainerdatabase.begin |
| External Non-Container Database - Delete End | com.oraclecloud.databaseservice.deleteexternalnoncontainerdatabase.end |
| External Non-Container Database - Disable Database Management Service Begin | com.oraclecloud.databaseservice.disabledatabasemanagementserviceforexternalnoncontainerdatabase.begin |
| External Non-Container Database - Disable Database Management Service End | com.oraclecloud.databaseservice.disabledatabasemanagementserviceforexternalnoncontainerdatabase.end |
| External Non-Container Database - Enable Database Management Service Begin | com.oraclecloud.databaseservice.enabledatabasemanagementserviceforexternalnoncontainerdatabase.begin |
| External Non-Container Database - Enable Database Management Service End | com.oraclecloud.databaseservice.enabledatabasemanagementserviceforexternalnoncontainerdatabase.end |
| External Non-Container Database - Update Begin | com.oraclecloud.databaseservice.updateexternalnoncontainerdatabase.begin |
| External Non-Container Database - Update End | com.oraclecloud.databaseservice.updateexternalnoncontainerdatabase.end |
External Container Database Event Types
The following are the event types that external container database resources emit.
Table 4-11 External Container Database Event Types
| Friendly Name | Event Type |
|---|---|
| External Container Database - Change Compartment Begin | com.oraclecloud.databaseservice.changeexternalcontainerdatabasecompartment.begin |
| External Container Database - Change Compartment End | com.oraclecloud.databaseservice.changeexternalcontainerdatabasecompartment.end |
| External Container Database - Create | com.oraclecloud.databaseservice.createexternalcontainerdatabase |
| External Container Database - Delete Begin | com.oraclecloud.databaseservice.deleteexternalcontainerdatabase.begin |
| External Container Database - Delete End | com.oraclecloud.databaseservice.deleteexternalcontainerdatabase.end |
| External Container Database - Disable Database Management Service Begin | com.oraclecloud.databaseservice.disabledatabasemanagementserviceforexternalcontainerdatabase.begin |
| External Container Database - Disable Database Management Service End | com.oraclecloud.databaseservice.disabledatabasemanagementserviceforexternalcontainerdatabase.end |
| External Container Database - Enable Database Management Service Begin | com.oraclecloud.databaseservice.enabledatabasemanagementserviceforexternalcontainerdatabase.begin |
| External Container Database - Enable Database Management Service End | com.oraclecloud.databaseservice.enabledatabasemanagementserviceforexternalcontainerdatabase.end |
| External Container Database - Scan Pluggable Databases Begin | com.oraclecloud.databaseservice.scanexternalcontainerdatabasepluggabledatabases.begin |
| External Container Database - Scan Pluggable Databases End | com.oraclecloud.databaseservice.scanexternalcontainerdatabasepluggabledatabases.end |
| External Container Database - Update Begin | com.oraclecloud.databaseservice.updateexternalcontainerdatabase.begin |
| External Container Database - Update End | com.oraclecloud.databaseservice.updateexternalcontainerdatabase.end |
Example 4-2 External Container Database Example Event
This is a reference event for external container databases.
{
"compartmentId": "ocid1.compartment.oc1.......unique_id",
"compartmentName": "example_name",
"resourceName": "11092020_PKS_NCDB1",
"resourceId": "ocid1.externalnoncontainerdatabase.oc1.....unique_id",
"availabilityDomain": "XXIT:PHX-AD-1",
"freeFormTags": {},
"definedTags": {},
"additionalDetails": {
"id": "ocid1.externalnoncontainerdatabase.oc1.....unique_id",
"timeCreated": "2020-11-13T21:15:59.000Z",
"timeUpdated": "2020-11-13T21:15:59.000Z",
"lifecycleState": "AVAILABLE",
"lifecycleDetails": "External Non Container Database is available",
"dbUniqueName": "NCDB122_phx16q",
"dbId": "3455094890",
"dbVersion": "12.2.0.1.0",
"dbEdition": "Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production",
"timeZone": "US/Pacific",
"externalCDBId": "ocid1.externalnoncontainerdatabase.oc1.....unique_id",
"databaseManagementServiceStatus": "ENABLED",
"databaseManagementServiceConnectorId": "ocid1.externaldatabaseconnector.oc1.....unique_id"
}
} External Pluggable Database Event Types
The following are the event types that external pluggable database resources emit.
Table 4-12 External Pluggable Database Event Types
| Friendly Name | Event Type |
|---|---|
| External Pluggable Database - Change Compartment Begin | com.oraclecloud.databaseservice.changeexternalpluggabledatabasecompartment.begin |
| External Pluggable Database - Change Compartment End | com.oraclecloud.databaseservice.changeexternalpluggabledatabasecompartment.end |
| External Pluggable Database - Create | com.oraclecloud.databaseservice.createexternalpluggabledatabase |
| External Pluggable Database - Delete Begin | com.oraclecloud.databaseservice.deleteexternalpluggabledatabase.begin |
| External Pluggable Database - Delete End | com.oraclecloud.databaseservice.deleteexternalpluggabledatabase.end |
| External Pluggable Database - Disable Database Management Service Begin | com.oraclecloud.databaseservice.disabledatabasemanagementserviceforexternalpluggabledatabase.begin |
| External Pluggable Database - Disable Database Management Service End | com.oraclecloud.databaseservice.disabledatabasemanagementserviceforexternalpluggabledatabase.end |
| External Pluggable Database - Enable Database Management Service Begin | com.oraclecloud.databaseservice.enabledatabasemanagementserviceforexternalpluggabledatabase.begin |
| External Pluggable Database - Enable Database Management Service End | com.oraclecloud.databaseservice.enabledatabasemanagementserviceforexternalpluggabledatabase.end |
| External Pluggable Database - Update Begin | com.oraclecloud.databaseservice.updateexternalpluggabledatabase.begin |
| External Pluggable Database - Update End | com.oraclecloud.databaseservice.updateexternalpluggabledatabase.end |