oci_opsi_exadata_insight

This resource provides the Exadata Insight resource in Oracle Cloud Infrastructure Opsi service.

Create an Exadata insight resource for an Exadata system in Operations Insights. The Exadata system will be enabled in Operations Insights. Exadata-related metric collection and analysis will be started.

Example Usage

resource "oci_opsi_exadata_insight" "test_exadata_insight" {
	#Required
	compartment_id = var.compartment_id
	enterprise_manager_bridge_id = oci_opsi_enterprise_manager_bridge.test_enterprise_manager_bridge.id
	enterprise_manager_entity_identifier = var.exadata_insight_enterprise_manager_entity_identifier
	enterprise_manager_identifier = var.exadata_insight_enterprise_manager_identifier
	entity_source = var.exadata_insight_entity_source

	#Optional
	defined_tags = {"foo-namespace.bar-key"= "value"}
	freeform_tags = {"bar-key"= "value"}
	is_auto_sync_enabled = var.exadata_insight_is_auto_sync_enabled
	member_vm_cluster_details {

		#Optional
		compartment_id = var.compartment_id
		dbm_private_endpoint_id = oci_dataflow_private_endpoint.test_private_endpoint.id
		member_database_details {

			#Optional
			compartment_id = var.compartment_id
			connection_details {

				#Optional
				hosts {

					#Optional
					host_ip = var.exadata_insight_member_vm_cluster_details_member_database_details_connection_details_hosts_host_ip
					port = var.exadata_insight_member_vm_cluster_details_member_database_details_connection_details_hosts_port
				}
				protocol = var.exadata_insight_member_vm_cluster_details_member_database_details_connection_details_protocol
				service_name = oci_core_service.test_service.name
			}
			credential_details {
				#Required
				credential_type = var.exadata_insight_member_vm_cluster_details_member_database_details_credential_details_credential_type

				#Optional
				credential_source_name = var.exadata_insight_member_vm_cluster_details_member_database_details_credential_details_credential_source_name
				password_secret_id = oci_vault_secret.test_secret.id
				role = var.exadata_insight_member_vm_cluster_details_member_database_details_credential_details_role
				user_name = oci_identity_user.test_user.name
				wallet_secret_id = oci_vault_secret.test_secret.id
			}
			database_id = oci_database_database.test_database.id
			database_resource_type = var.exadata_insight_member_vm_cluster_details_member_database_details_database_resource_type
			dbm_private_endpoint_id = oci_dataflow_private_endpoint.test_private_endpoint.id
			defined_tags = var.exadata_insight_member_vm_cluster_details_member_database_details_defined_tags
			deployment_type = var.exadata_insight_member_vm_cluster_details_member_database_details_deployment_type
			entity_source = var.exadata_insight_member_vm_cluster_details_member_database_details_entity_source
			freeform_tags = var.exadata_insight_member_vm_cluster_details_member_database_details_freeform_tags
			opsi_private_endpoint_id = oci_dataflow_private_endpoint.test_private_endpoint.id
			service_name = oci_core_service.test_service.name
			system_tags = var.exadata_insight_member_vm_cluster_details_member_database_details_system_tags
		}
		opsi_private_endpoint_id = oci_dataflow_private_endpoint.test_private_endpoint.id
		vmcluster_id = oci_opsi_vmcluster.test_vmcluster.id
	}
}

Argument Reference

The following arguments are supported:

• compartment_id - (Required) (Updatable) Compartment Identifier of Exadata insight
• defined_tags - (Optional) (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
• enterprise_manager_bridge_id - (Required) OPSI Enterprise Manager Bridge OCID
• enterprise_manager_entity_identifier - (Required) Enterprise Manager Entity Unique Identifier
• enterprise_manager_identifier - (Required) Enterprise Manager Unique Identifier
• entity_source - (Required) (Updatable) Source of the Exadata system.
• freeform_tags - (Optional) (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
• is_auto_sync_enabled - (Applicable when entity_source=EM_MANAGED_EXTERNAL_EXADATA) (Updatable) Set to true to enable automatic enablement and disablement of related targets from Enterprise Manager. New resources (e.g. Database Insights) will be placed in the same compartment as the related Exadata Insight.
• member_vm_cluster_details - (Applicable when entity_source=PE_COMANAGED_EXADATA)
  • compartment_id - (Required when entity_source=PE_COMANAGED_EXADATA) (Updatable) The OCID of the compartment.
  • dbm_private_endpoint_id - (Applicable when entity_source=PE_COMANAGED_EXADATA) The OCID of the Database Management private endpoint
  • member_database_details - (Applicable when entity_source=PE_COMANAGED_EXADATA) The databases that belong to the VM Cluster
    • compartment_id - (Required when entity_source=PE_COMANAGED_EXADATA) (Updatable) Compartment Identifier of database
    • connection_details - (Applicable when entity_source=PE_COMANAGED_EXADATA) Connection details of the private endpoints.
      • hosts - (Required when entity_source=PE_COMANAGED_EXADATA) List of hosts and port for private endpoint accessed database resource.
        • host_ip - (Applicable when entity_source=PE_COMANAGED_EXADATA) Host IP used for connection requests for Cloud DB resource.
        • port - (Applicable when entity_source=PE_COMANAGED_EXADATA) Listener port number used for connection requests for rivate endpoint accessed db resource.
      • protocol - (Applicable when entity_source=PE_COMANAGED_EXADATA) Protocol used for connection requests for private endpoint accssed database resource.
      • service_name - (Applicable when entity_source=PE_COMANAGED_EXADATA) Database service name used for connection requests.
    • credential_details - (Required when entity_source=PE_COMANAGED_EXADATA) User credential details to connect to the database. This is supplied via the External Database Service.
      • credential_source_name - (Required when entity_source=PE_COMANAGED_EXADATA) Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.
      • credential_type - (Required) Credential type.
      • password_secret_id - (Applicable when credential_type=CREDENTIALS_BY_VAULT) The secret OCID mapping to the database credentials.
      • role - (Applicable when credential_type=CREDENTIALS_BY_VAULT) database user role.
      • user_name - (Applicable when credential_type=CREDENTIALS_BY_VAULT) database user name.
      • wallet_secret_id - (Applicable when credential_type=CREDENTIALS_BY_VAULT) The OCID of the Secret where the database keystore contents are stored.
    • database_id - (Required when entity_source=PE_COMANAGED_EXADATA) The OCID of the database.
    • database_resource_type - (Required when entity_source=PE_COMANAGED_EXADATA) Oracle Cloud Infrastructure database resource type
    • dbm_private_endpoint_id - (Applicable when entity_source=PE_COMANAGED_EXADATA) The OCID of the Database Management private endpoint
    • defined_tags - (Applicable when entity_source=PE_COMANAGED_EXADATA) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    • deployment_type - (Required when entity_source=PE_COMANAGED_EXADATA) Database Deployment Type
    • entity_source - (Required when entity_source=PE_COMANAGED_EXADATA) Source of the database entity.
    • freeform_tags - (Applicable when entity_source=PE_COMANAGED_EXADATA) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    • opsi_private_endpoint_id - (Applicable when entity_source=PE_COMANAGED_EXADATA) The OCID of the OPSI private endpoint
    • service_name - (Required when entity_source=PE_COMANAGED_EXADATA) Database service name used for connection requests.
    • system_tags - (Applicable when entity_source=PE_COMANAGED_EXADATA) System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
  • opsi_private_endpoint_id - (Applicable when entity_source=PE_COMANAGED_EXADATA) The OCID of the OPSI private endpoint
  • vmcluster_id - (Required when entity_source=PE_COMANAGED_EXADATA) The OCID of the VM Cluster.
• is_auto_sync_enabled - (Optional) (Updatable) Set to true to enable automatic enablement and disablement of related targets from Enterprise Manager. New resources (e.g. Database Insights) will be placed in the same compartment as the related Exadata Insight.
• status - (Optional) (Updatable) Status of the resource. Example: “ENABLED”, “DISABLED”. Resource can be either enabled or disabled by updating the value of status field to either “ENABLED” or “DISABLED”

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Attributes Reference

The following attributes are exported:

• compartment_id - Compartment identifier of the Exadata insight resource
• defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
• enterprise_manager_bridge_id - OPSI Enterprise Manager Bridge OCID
• enterprise_manager_entity_display_name - Enterprise Manager Entity Display Name
• enterprise_manager_entity_identifier - Enterprise Manager Entity Unique Identifier
• enterprise_manager_entity_name - Enterprise Manager Entity Name
• enterprise_manager_entity_type - Enterprise Manager Entity Type
• enterprise_manager_identifier - Enterprise Manager Unique Identifier
• entity_source - Source of the Exadata system.
• exadata_display_name - The user-friendly name for the Exadata system. The name does not have to be unique.
• exadata_name - The Exadata system name. If the Exadata systems managed by Enterprise Manager, the name is unique amongst the Exadata systems managed by the same Enterprise Manager.
• exadata_rack_type - Exadata rack type.
• exadata_type - Operations Insights internal representation of the the Exadata system type.
• freeform_tags - Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
• id - Exadata insight identifier
• is_auto_sync_enabled - Set to true to enable automatic enablement and disablement of related targets from Enterprise Manager. New resources (e.g. Database Insights) will be placed in the same compartment as the related Exadata Insight.
• is_virtualized_exadata - true if virtualization is used in the Exadata system
• lifecycle_details - A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
• state - The current state of the Exadata insight.
• status - Indicates the status of an Exadata insight in Operations Insights
• system_tags - System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
• time_created - The time the the Exadata insight was first enabled. An RFC3339 formatted datetime string
• time_updated - The time the Exadata insight was updated. An RFC3339 formatted datetime string

Timeouts

The timeouts block allows you to specify timeouts for certain operations: * create - (Defaults to 20 minutes), when creating the Exadata Insight * update - (Defaults to 20 minutes), when updating the Exadata Insight * delete - (Defaults to 20 minutes), when destroying the Exadata Insight

Import

ExadataInsights can be imported using the id, e.g.

$ terraform import oci_opsi_exadata_insight.test_exadata_insight "id"