cloud_vm_clusters

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

Overview

Name	cloud_vm_clusters
Type	Resource
Id	azure_isv.oracle.cloud_vm_clusters

Fields

vw_cloud_vm_clusters

Name	Datatype	Description
backup_subnet_cidr	text	field from the properties object
cloud_exadata_infrastructure_id	text	field from the properties object
cloudvmclustername	text	field from the properties object
cluster_name	text	field from the properties object
compartment_id	text	field from the properties object
compute_nodes	text	field from the properties object
cpu_core_count	text	field from the properties object
data_collection_options	text	field from the properties object
data_storage_percentage	text	field from the properties object
data_storage_size_in_tbs	text	field from the properties object
db_node_storage_size_in_gbs	text	field from the properties object
db_servers	text	field from the properties object
disk_redundancy	text	field from the properties object
display_name	text	field from the properties object
domain	text	field from the properties object
gi_version	text	field from the properties object
hostname	text	field from the properties object
iorm_config_cache	text	field from the properties object
is_local_backup_enabled	text	field from the properties object
is_sparse_diskgroup_enabled	text	field from the properties object
last_update_history_entry_id	text	field from the properties object
license_model	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
listener_port	text	field from the properties object
location	text	The geo-location where the resource lives
memory_size_in_gbs	text	field from the properties object
node_count	text	field from the properties object
nsg_cidrs	text	field from the properties object
nsg_url	text	field from the properties object
oci_url	text	field from the properties object
ocid	text	field from the properties object
ocpu_count	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
scan_dns_name	text	field from the properties object
scan_dns_record_id	text	field from the properties object
scan_ip_ids	text	field from the properties object
scan_listener_port_tcp	text	field from the properties object
scan_listener_port_tcp_ssl	text	field from the properties object
shape	text	field from the properties object
ssh_public_keys	text	field from the properties object
storage_size_in_gbs	text	field from the properties object
subnet_id	text	field from the properties object
subnet_ocid	text	field from the properties object
subscriptionId	text	field from the properties object
system_version	text	field from the properties object
tags	text	Resource tags.
time_created	text	field from the properties object
time_zone	text	field from the properties object
vip_ids	text	field from the properties object
vnet_id	text	field from the properties object
zone_id	text	field from the properties object

cloud_vm_clusters

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	CloudVmCluster resource model
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudvmclustername, resourceGroupName, subscriptionId	Get a CloudVmCluster
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List CloudVmCluster resources by resource group
list_by_subscription	SELECT	subscriptionId	List CloudVmCluster resources by subscription ID
create_or_update	INSERT	cloudvmclustername, resourceGroupName, subscriptionId	Create a CloudVmCluster
delete	DELETE	cloudvmclustername, resourceGroupName, subscriptionId	Delete a CloudVmCluster
update	UPDATE	cloudvmclustername, resourceGroupName, subscriptionId	Update a CloudVmCluster
add_vms	EXEC	cloudvmclustername, resourceGroupName, subscriptionId, data__dbServers	Add VMs to the VM Cluster
remove_vms	EXEC	cloudvmclustername, resourceGroupName, subscriptionId, data__dbServers	Remove VMs from the VM Cluster

SELECT examples

List CloudVmCluster resources by subscription ID

vw_cloud_vm_clusters

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 }}';

cloud_vm_clusters

SELECT
location,
properties,
tags
FROM azure_isv.oracle.cloud_vm_clusters
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: ocid
          value: []
        - name: listenerPort
          value: integer
        - name: nodeCount
          value: integer
        - name: storageSizeInGbs
          value: integer
        - name: dataStorageSizeInTbs
          value: number
        - name: dbNodeStorageSizeInGbs
          value: integer
        - name: memorySizeInGbs
          value: integer
        - name: timeCreated
          value: string
        - name: lifecycleDetails
          value: string
        - name: timeZone
          value: string
        - name: hostname
          value: string
        - name: domain
          value: string
        - name: cpuCoreCount
          value: integer
        - name: ocpuCount
          value: number
        - name: clusterName
          value: string
        - name: dataStoragePercentage
          value: integer
        - name: isLocalBackupEnabled
          value: boolean
        - name: cloudExadataInfrastructureId
          value: []
        - name: isSparseDiskgroupEnabled
          value: boolean
        - name: systemVersion
          value: string
        - name: sshPublicKeys
          value:
            - string
        - name: licenseModel
          value: []
        - name: diskRedundancy
          value: []
        - name: scanIpIds
          value:
            - string
        - name: vipIds
          value:
            - string
        - name: scanDnsName
          value: string
        - name: scanListenerPortTcp
          value: integer
        - name: scanListenerPortTcpSsl
          value: integer
        - name: shape
          value: string
        - name: provisioningState
          value: []
        - name: lifecycleState
          value: []
        - name: vnetId
          value: []
        - name: giVersion
          value: string
        - name: ociUrl
          value: string
        - name: nsgUrl
          value: string
        - name: subnetId
          value: []
        - name: backupSubnetCidr
          value: string
        - name: nsgCidrs
          value:
            - - name: source
                value: string
              - name: destinationPortRange
                value:
                  - name: min
                    value: integer
                  - name: max
                    value: integer
        - name: dataCollectionOptions
          value:
            - name: isDiagnosticsEventsEnabled
              value: boolean
            - name: isHealthMonitoringEnabled
              value: boolean
            - name: isIncidentLogsEnabled
              value: boolean
        - name: displayName
          value: string
        - name: computeNodes
          value:
            - []
        - name: iormConfigCache
          value:
            - name: dbPlans
              value:
                - - name: dbName
                    value: string
                  - name: flashCacheLimit
                    value: string
                  - name: share
                    value: integer
            - name: lifecycleDetails
              value: string
            - name: lifecycleState
              value: []
            - name: objective
              value: []
        - name: dbServers
          value:
            - []
    - name: tags
      value: object
    - name: location
      value: string

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 }}';