Data Source: oci_database_management_cloud_db_systems

This data source provides the list of Cloud Db Systems in Oracle Cloud Infrastructure Database Management service.

Lists the cloud DB systems in the specified compartment.

Example Usage

data "oci_database_management_cloud_db_systems" "test_cloud_db_systems" {
	#Required
	compartment_id = var.compartment_id

	#Optional
	dbaas_parent_infrastructure_id = oci_database_management_dbaas_parent_infrastructure.test_dbaas_parent_infrastructure.id
	deployment_type = var.cloud_db_system_deployment_type
	display_name = var.cloud_db_system_display_name
	state = var.cloud_db_system_state
}

Argument Reference

The following arguments are supported:

• compartment_id - (Required) The OCID of the compartment.
• dbaas_parent_infrastructure_id - (Optional) The OCID of the dbaas parent infrastructure of the cloud DB system.
• deployment_type - (Optional) A filter to return cloud DB systems of the specified deployment type.
• display_name - (Optional) A filter to only return the resources that match the entire display name.
• state - (Optional) The lifecycle state of a resource.

Attributes Reference

The following attributes are exported:

• cloud_db_system_collection - The list of cloud_db_system_collection.

CloudDbSystem Reference

The following attributes are exported:

• compartment_id - The OCID of the compartment.
• database_management_config - The configuration details of Database Management for a cloud DB system.
  • is_enabled - The status of the associated service.
  • metadata - The associated service-specific inputs in JSON string format, which Database Management can identify.
• db_system_discovery_id - The OCID of the DB system discovery.
• dbaas_parent_infrastructure_id - The OCID of the parent cloud DB Infrastructure. For VM Dbsystems , it will be the DBSystem Id. For ExaCS and ExaCC, it will be the cloudVmClusterId and vmClusterId respectively.
• defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"Operations.CostCenter": "42"}
• deployment_type - The deployment type of cloud dbsystem.
• discovery_agent_id - The OCID of the management agent used during the discovery of the DB system.
• display_name - The user-friendly name for the DB system. The name does not have to be unique.
• freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
• home_directory - The Oracle Grid home directory in case of cluster-based DB system and Oracle home directory in case of single instance-based DB system.
• id - The OCID of the cloud DB system.
• is_cluster - Indicates whether the DB system is a cluster DB system or not.
• lifecycle_details - Additional information about the current lifecycle state.
• stack_monitoring_config - The configuration details of Stack Monitoring for a cloud DB system.
  • is_enabled - The status of the associated service.
  • metadata - The associated service-specific inputs in JSON string format, which Database Management can identify.
• state - The current lifecycle state of the cloud DB system resource.
• system_tags - System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. System tags can be viewed by users, but can only be created by the system. Example: {"orcl-cloud.free-tier-retained": "true"}
• time_created - The date and time the cloud DB system was created.
• time_updated - The date and time the cloud DB system was last updated.