Skip to main content

cloud_vm_clusters

Creates, updates, deletes, gets or lists a cloud_vm_clusters resource.

Overview

Namecloud_vm_clusters
TypeResource
Idazure_isv.oracle.cloud_vm_clusters

Fields

NameDatatypeDescription
backup_subnet_cidrtextfield from the properties object
cloud_exadata_infrastructure_idtextfield from the properties object
cloudvmclusternametextfield from the properties object
cluster_nametextfield from the properties object
compartment_idtextfield from the properties object
compute_nodestextfield from the properties object
cpu_core_counttextfield from the properties object
data_collection_optionstextfield from the properties object
data_storage_percentagetextfield from the properties object
data_storage_size_in_tbstextfield from the properties object
db_node_storage_size_in_gbstextfield from the properties object
db_serverstextfield from the properties object
disk_redundancytextfield from the properties object
display_nametextfield from the properties object
domaintextfield from the properties object
gi_versiontextfield from the properties object
hostnametextfield from the properties object
iorm_config_cachetextfield from the properties object
is_local_backup_enabledtextfield from the properties object
is_sparse_diskgroup_enabledtextfield from the properties object
last_update_history_entry_idtextfield from the properties object
license_modeltextfield from the properties object
lifecycle_detailstextfield from the properties object
lifecycle_statetextfield from the properties object
listener_porttextfield from the properties object
locationtextThe geo-location where the resource lives
memory_size_in_gbstextfield from the properties object
node_counttextfield from the properties object
nsg_cidrstextfield from the properties object
nsg_urltextfield from the properties object
oci_urltextfield from the properties object
ocidtextfield from the properties object
ocpu_counttextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
scan_dns_nametextfield from the properties object
scan_dns_record_idtextfield from the properties object
scan_ip_idstextfield from the properties object
scan_listener_port_tcptextfield from the properties object
scan_listener_port_tcp_ssltextfield from the properties object
shapetextfield from the properties object
ssh_public_keystextfield from the properties object
storage_size_in_gbstextfield from the properties object
subnet_idtextfield from the properties object
subnet_ocidtextfield from the properties object
subscriptionIdtextfield from the properties object
system_versiontextfield from the properties object
tagstextResource tags.
time_createdtextfield from the properties object
time_zonetextfield from the properties object
vip_idstextfield from the properties object
vnet_idtextfield from the properties object
zone_idtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTcloudvmclustername, resourceGroupName, subscriptionIdGet a CloudVmCluster
list_by_resource_groupSELECTresourceGroupName, subscriptionIdList CloudVmCluster resources by resource group
list_by_subscriptionSELECTsubscriptionIdList CloudVmCluster resources by subscription ID
create_or_updateINSERTcloudvmclustername, resourceGroupName, subscriptionIdCreate a CloudVmCluster
deleteDELETEcloudvmclustername, resourceGroupName, subscriptionIdDelete a CloudVmCluster
updateUPDATEcloudvmclustername, resourceGroupName, subscriptionIdUpdate a CloudVmCluster
add_vmsEXECcloudvmclustername, resourceGroupName, subscriptionId, data__dbServersAdd VMs to the VM Cluster
remove_vmsEXECcloudvmclustername, resourceGroupName, subscriptionId, data__dbServersRemove VMs from the VM Cluster

SELECT examples

List CloudVmCluster resources by subscription ID

SELECT
backup_subnet_cidr,
cloud_exadata_infrastructure_id,
cloudvmclustername,
cluster_name,
compartment_id,
compute_nodes,
cpu_core_count,
data_collection_options,
data_storage_percentage,
data_storage_size_in_tbs,
db_node_storage_size_in_gbs,
db_servers,
disk_redundancy,
display_name,
domain,
gi_version,
hostname,
iorm_config_cache,
is_local_backup_enabled,
is_sparse_diskgroup_enabled,
last_update_history_entry_id,
license_model,
lifecycle_details,
lifecycle_state,
listener_port,
location,
memory_size_in_gbs,
node_count,
nsg_cidrs,
nsg_url,
oci_url,
ocid,
ocpu_count,
provisioning_state,
resourceGroupName,
scan_dns_name,
scan_dns_record_id,
scan_ip_ids,
scan_listener_port_tcp,
scan_listener_port_tcp_ssl,
shape,
ssh_public_keys,
storage_size_in_gbs,
subnet_id,
subnet_ocid,
subscriptionId,
system_version,
tags,
time_created,
time_zone,
vip_ids,
vnet_id,
zone_id
FROM azure_isv.oracle.vw_cloud_vm_clusters
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new cloud_vm_clusters resource.

/*+ create */
INSERT INTO azure_isv.oracle.cloud_vm_clusters (
cloudvmclustername,
resourceGroupName,
subscriptionId,
properties,
tags,
location
)
SELECT
'{{ cloudvmclustername }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

UPDATE example

Updates a cloud_vm_clusters resource.

/*+ update */
UPDATE azure_isv.oracle.cloud_vm_clusters
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified cloud_vm_clusters resource.

/*+ delete */
DELETE FROM azure_isv.oracle.cloud_vm_clusters
WHERE cloudvmclustername = '{{ cloudvmclustername }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';