cloud_vm_clusters

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

Overview

Name	`cloud_vm_clusters`
Type	Resource
Id	`azure_isv.oracledatabase.cloud_vm_clusters`

Fields

The following fields are returned by SELECT queries:

get
list_by_resource_group
list_by_subscription

Name	Datatype	Description
`id`	`string`	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
`name`	`string`	The name of the resource.
`backupSubnetCidr`	`string`	Client OCI backup subnet CIDR, default is 192.168.252.0/22.
`cloudExadataInfrastructureId`	`string`	Cloud Exadata Infrastructure ID. Required.
`clusterName`	`string`	The cluster name for cloud VM cluster. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.
`compartmentId`	`string`	Cluster compartmentId.
`computeModel`	`string`	The compute model of the VM Cluster. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
`computeNodes`	`array`	The list of compute servers to be added to the cloud VM cluster.
`cpuCoreCount`	`integer`	The number of CPU cores enabled on the cloud VM cluster. Required.
`dataCollectionOptions`	`object`	Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.
`dataStoragePercentage`	`integer`	The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Accepted values are 35, 40, 60 and 80. The default is 80 percent assigned to DATA storage. See `Storage Configuration` _ in the Exadata documentation for details on the impact of the configuration settings on storage.
`dataStorageSizeInTbs`	`number`	The data disk group size to be allocated in TBs.
`dbNodeStorageSizeInGbs`	`integer`	The local node storage to be allocated in GBs.
`dbServers`	`array`	The list of DB servers.
`diskRedundancy`	`string`	The type of redundancy configured for the cloud Vm cluster. NORMAL is 2-way redundancy. HIGH is 3-way redundancy. Known values are: "High" and "Normal". (High, Normal)
`displayName`	`string`	Display Name. Required.
`domain`	`string`	The domain name for the cloud VM cluster.
`exascaleDbStorageVaultId`	`string`	Exadata Database Storage Vault ID.
`fileSystemConfigurationDetails`	`array`	Array of mount path and size.
`giVersion`	`string`	Oracle Grid Infrastructure (GI) software version. Required.
`hostname`	`string`	The hostname for the cloud VM cluster. Required.
`iormConfigCache`	`object`	iormConfigCache details for cloud VM cluster.
`isLocalBackupEnabled`	`boolean`	If true, database backup on local Exadata storage is configured for the cloud VM cluster. If false, database backup on local Exadata storage is not available in the cloud VM cluster.
`isSparseDiskgroupEnabled`	`boolean`	If true, sparse disk group is configured for the cloud VM cluster. If false, sparse disk group is not created.
`lastUpdateHistoryEntryId`	`string`	The OCID of the last maintenance update history entry.
`licenseModel`	`string`	The Oracle license model that applies to the cloud VM cluster. The default is LICENSE_INCLUDED. Known values are: "LicenseIncluded" and "BringYourOwnLicense". (LicenseIncluded, BringYourOwnLicense)
`lifecycleDetails`	`string`	Additional information about the current lifecycle state.
`lifecycleState`	`string`	CloudVmCluster lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", "MaintenanceInProgress", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, MaintenanceInProgress, Failed)
`listenerPort`	`integer`	The port number configured for the listener on the cloud VM cluster.
`location`	`string`	The geo-location where the resource lives. Required.
`memorySizeInGbs`	`integer`	The memory to be allocated in GBs.
`nodeCount`	`integer`	The number of nodes in the cloud VM cluster.
`nsgCidrs`	`array`	CIDR blocks for additional NSG ingress rules. The VNET CIDRs used to provision the VM Cluster will be added by default.
`nsgUrl`	`string`	HTTPS link to OCI Network Security Group exposed to Azure Customer via the Azure Interface.
`ociUrl`	`string`	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
`ocid`	`string`	Cloud VM Cluster ocid.
`ocpuCount`	`number`	The number of OCPU cores to enable on the cloud VM cluster. Only 1 decimal place is allowed for the fractional part.
`provisioningState`	`string`	CloudVmCluster provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
`scanDnsName`	`string`	The FQDN of the DNS record for the SCAN IP addresses that are associated with the cloud VM cluster.
`scanDnsRecordId`	`string`	The OCID of the DNS record for the SCAN IP addresses that are associated with the cloud VM cluster.
`scanIpIds`	`array`	The Single Client Access Name (SCAN) IP addresses associated with the cloud VM cluster. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster. Note: For a single-node DB system, this list is empty.
`scanListenerPortTcp`	`integer`	The TCP Single Client Access Name (SCAN) port. The default port is 1521.
`scanListenerPortTcpSsl`	`integer`	The TCPS Single Client Access Name (SCAN) port. The default port is 2484.
`shape`	`string`	The model name of the Exadata hardware running the cloud VM cluster.
`sshPublicKeys`	`array`	The public key portion of one or more key pairs used for SSH access to the cloud VM cluster. Required.
`storageManagementType`	`string`	Specifies whether the type of storage management for the VM cluster is ASM or Exascale. Known values are: "ASM" and "Exascale". (ASM, Exascale)
`storageSizeInGbs`	`integer`	The data disk group size to be allocated in GBs per VM.
`subnetId`	`string`	Client subnet. Required.
`subnetOcid`	`string`	Cluster subnet ocid.
`systemData`	`object`	Azure Resource Manager metadata containing createdBy and modifiedBy information.
`systemVersion`	`string`	Operating system version of the image.
`tags`	`object`	Resource tags.
`timeCreated`	`string (date-time)`	The date and time that the cloud VM cluster was created.
`timeZone`	`string`	The time zone of the cloud VM cluster. For details, see `Exadata Infrastructure Time Zones` _.
`type`	`string`	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
`vipIds`	`array`	The virtual IP (VIP) addresses associated with the cloud VM cluster. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the Exadata Cloud Service instance to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster. Note: For a single-node DB system, this list is empty.
`vnetId`	`string`	VNET for network connectivity. Required.
`zoneId`	`string`	The OCID of the zone the cloud VM cluster is associated with.

Name	Datatype	Description
`id`	`string`	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
`name`	`string`	The name of the resource.
`backupSubnetCidr`	`string`	Client OCI backup subnet CIDR, default is 192.168.252.0/22.
`cloudExadataInfrastructureId`	`string`	Cloud Exadata Infrastructure ID. Required.
`clusterName`	`string`	The cluster name for cloud VM cluster. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.
`compartmentId`	`string`	Cluster compartmentId.
`computeModel`	`string`	The compute model of the VM Cluster. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
`computeNodes`	`array`	The list of compute servers to be added to the cloud VM cluster.
`cpuCoreCount`	`integer`	The number of CPU cores enabled on the cloud VM cluster. Required.
`dataCollectionOptions`	`object`	Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.
`dataStoragePercentage`	`integer`	The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Accepted values are 35, 40, 60 and 80. The default is 80 percent assigned to DATA storage. See `Storage Configuration` _ in the Exadata documentation for details on the impact of the configuration settings on storage.
`dataStorageSizeInTbs`	`number`	The data disk group size to be allocated in TBs.
`dbNodeStorageSizeInGbs`	`integer`	The local node storage to be allocated in GBs.
`dbServers`	`array`	The list of DB servers.
`diskRedundancy`	`string`	The type of redundancy configured for the cloud Vm cluster. NORMAL is 2-way redundancy. HIGH is 3-way redundancy. Known values are: "High" and "Normal". (High, Normal)
`displayName`	`string`	Display Name. Required.
`domain`	`string`	The domain name for the cloud VM cluster.
`exascaleDbStorageVaultId`	`string`	Exadata Database Storage Vault ID.
`fileSystemConfigurationDetails`	`array`	Array of mount path and size.
`giVersion`	`string`	Oracle Grid Infrastructure (GI) software version. Required.
`hostname`	`string`	The hostname for the cloud VM cluster. Required.
`iormConfigCache`	`object`	iormConfigCache details for cloud VM cluster.
`isLocalBackupEnabled`	`boolean`	If true, database backup on local Exadata storage is configured for the cloud VM cluster. If false, database backup on local Exadata storage is not available in the cloud VM cluster.
`isSparseDiskgroupEnabled`	`boolean`	If true, sparse disk group is configured for the cloud VM cluster. If false, sparse disk group is not created.
`lastUpdateHistoryEntryId`	`string`	The OCID of the last maintenance update history entry.
`licenseModel`	`string`	The Oracle license model that applies to the cloud VM cluster. The default is LICENSE_INCLUDED. Known values are: "LicenseIncluded" and "BringYourOwnLicense". (LicenseIncluded, BringYourOwnLicense)
`lifecycleDetails`	`string`	Additional information about the current lifecycle state.
`lifecycleState`	`string`	CloudVmCluster lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", "MaintenanceInProgress", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, MaintenanceInProgress, Failed)
`listenerPort`	`integer`	The port number configured for the listener on the cloud VM cluster.
`location`	`string`	The geo-location where the resource lives. Required.
`memorySizeInGbs`	`integer`	The memory to be allocated in GBs.
`nodeCount`	`integer`	The number of nodes in the cloud VM cluster.
`nsgCidrs`	`array`	CIDR blocks for additional NSG ingress rules. The VNET CIDRs used to provision the VM Cluster will be added by default.
`nsgUrl`	`string`	HTTPS link to OCI Network Security Group exposed to Azure Customer via the Azure Interface.
`ociUrl`	`string`	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
`ocid`	`string`	Cloud VM Cluster ocid.
`ocpuCount`	`number`	The number of OCPU cores to enable on the cloud VM cluster. Only 1 decimal place is allowed for the fractional part.
`provisioningState`	`string`	CloudVmCluster provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
`scanDnsName`	`string`	The FQDN of the DNS record for the SCAN IP addresses that are associated with the cloud VM cluster.
`scanDnsRecordId`	`string`	The OCID of the DNS record for the SCAN IP addresses that are associated with the cloud VM cluster.
`scanIpIds`	`array`	The Single Client Access Name (SCAN) IP addresses associated with the cloud VM cluster. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster. Note: For a single-node DB system, this list is empty.
`scanListenerPortTcp`	`integer`	The TCP Single Client Access Name (SCAN) port. The default port is 1521.
`scanListenerPortTcpSsl`	`integer`	The TCPS Single Client Access Name (SCAN) port. The default port is 2484.
`shape`	`string`	The model name of the Exadata hardware running the cloud VM cluster.
`sshPublicKeys`	`array`	The public key portion of one or more key pairs used for SSH access to the cloud VM cluster. Required.
`storageManagementType`	`string`	Specifies whether the type of storage management for the VM cluster is ASM or Exascale. Known values are: "ASM" and "Exascale". (ASM, Exascale)
`storageSizeInGbs`	`integer`	The data disk group size to be allocated in GBs per VM.
`subnetId`	`string`	Client subnet. Required.
`subnetOcid`	`string`	Cluster subnet ocid.
`systemData`	`object`	Azure Resource Manager metadata containing createdBy and modifiedBy information.
`systemVersion`	`string`	Operating system version of the image.
`tags`	`object`	Resource tags.
`timeCreated`	`string (date-time)`	The date and time that the cloud VM cluster was created.
`timeZone`	`string`	The time zone of the cloud VM cluster. For details, see `Exadata Infrastructure Time Zones` _.
`type`	`string`	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
`vipIds`	`array`	The virtual IP (VIP) addresses associated with the cloud VM cluster. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the Exadata Cloud Service instance to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster. Note: For a single-node DB system, this list is empty.
`vnetId`	`string`	VNET for network connectivity. Required.
`zoneId`	`string`	The OCID of the zone the cloud VM cluster is associated with.

Name	Datatype	Description
`id`	`string`	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
`name`	`string`	The name of the resource.
`backupSubnetCidr`	`string`	Client OCI backup subnet CIDR, default is 192.168.252.0/22.
`cloudExadataInfrastructureId`	`string`	Cloud Exadata Infrastructure ID. Required.
`clusterName`	`string`	The cluster name for cloud VM cluster. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.
`compartmentId`	`string`	Cluster compartmentId.
`computeModel`	`string`	The compute model of the VM Cluster. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
`computeNodes`	`array`	The list of compute servers to be added to the cloud VM cluster.
`cpuCoreCount`	`integer`	The number of CPU cores enabled on the cloud VM cluster. Required.
`dataCollectionOptions`	`object`	Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.
`dataStoragePercentage`	`integer`	The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Accepted values are 35, 40, 60 and 80. The default is 80 percent assigned to DATA storage. See `Storage Configuration` _ in the Exadata documentation for details on the impact of the configuration settings on storage.
`dataStorageSizeInTbs`	`number`	The data disk group size to be allocated in TBs.
`dbNodeStorageSizeInGbs`	`integer`	The local node storage to be allocated in GBs.
`dbServers`	`array`	The list of DB servers.
`diskRedundancy`	`string`	The type of redundancy configured for the cloud Vm cluster. NORMAL is 2-way redundancy. HIGH is 3-way redundancy. Known values are: "High" and "Normal". (High, Normal)
`displayName`	`string`	Display Name. Required.
`domain`	`string`	The domain name for the cloud VM cluster.
`exascaleDbStorageVaultId`	`string`	Exadata Database Storage Vault ID.
`fileSystemConfigurationDetails`	`array`	Array of mount path and size.
`giVersion`	`string`	Oracle Grid Infrastructure (GI) software version. Required.
`hostname`	`string`	The hostname for the cloud VM cluster. Required.
`iormConfigCache`	`object`	iormConfigCache details for cloud VM cluster.
`isLocalBackupEnabled`	`boolean`	If true, database backup on local Exadata storage is configured for the cloud VM cluster. If false, database backup on local Exadata storage is not available in the cloud VM cluster.
`isSparseDiskgroupEnabled`	`boolean`	If true, sparse disk group is configured for the cloud VM cluster. If false, sparse disk group is not created.
`lastUpdateHistoryEntryId`	`string`	The OCID of the last maintenance update history entry.
`licenseModel`	`string`	The Oracle license model that applies to the cloud VM cluster. The default is LICENSE_INCLUDED. Known values are: "LicenseIncluded" and "BringYourOwnLicense". (LicenseIncluded, BringYourOwnLicense)
`lifecycleDetails`	`string`	Additional information about the current lifecycle state.
`lifecycleState`	`string`	CloudVmCluster lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", "MaintenanceInProgress", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, MaintenanceInProgress, Failed)
`listenerPort`	`integer`	The port number configured for the listener on the cloud VM cluster.
`location`	`string`	The geo-location where the resource lives. Required.
`memorySizeInGbs`	`integer`	The memory to be allocated in GBs.
`nodeCount`	`integer`	The number of nodes in the cloud VM cluster.
`nsgCidrs`	`array`	CIDR blocks for additional NSG ingress rules. The VNET CIDRs used to provision the VM Cluster will be added by default.
`nsgUrl`	`string`	HTTPS link to OCI Network Security Group exposed to Azure Customer via the Azure Interface.
`ociUrl`	`string`	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
`ocid`	`string`	Cloud VM Cluster ocid.
`ocpuCount`	`number`	The number of OCPU cores to enable on the cloud VM cluster. Only 1 decimal place is allowed for the fractional part.
`provisioningState`	`string`	CloudVmCluster provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
`scanDnsName`	`string`	The FQDN of the DNS record for the SCAN IP addresses that are associated with the cloud VM cluster.
`scanDnsRecordId`	`string`	The OCID of the DNS record for the SCAN IP addresses that are associated with the cloud VM cluster.
`scanIpIds`	`array`	The Single Client Access Name (SCAN) IP addresses associated with the cloud VM cluster. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster. Note: For a single-node DB system, this list is empty.
`scanListenerPortTcp`	`integer`	The TCP Single Client Access Name (SCAN) port. The default port is 1521.
`scanListenerPortTcpSsl`	`integer`	The TCPS Single Client Access Name (SCAN) port. The default port is 2484.
`shape`	`string`	The model name of the Exadata hardware running the cloud VM cluster.
`sshPublicKeys`	`array`	The public key portion of one or more key pairs used for SSH access to the cloud VM cluster. Required.
`storageManagementType`	`string`	Specifies whether the type of storage management for the VM cluster is ASM or Exascale. Known values are: "ASM" and "Exascale". (ASM, Exascale)
`storageSizeInGbs`	`integer`	The data disk group size to be allocated in GBs per VM.
`subnetId`	`string`	Client subnet. Required.
`subnetOcid`	`string`	Cluster subnet ocid.
`systemData`	`object`	Azure Resource Manager metadata containing createdBy and modifiedBy information.
`systemVersion`	`string`	Operating system version of the image.
`tags`	`object`	Resource tags.
`timeCreated`	`string (date-time)`	The date and time that the cloud VM cluster was created.
`timeZone`	`string`	The time zone of the cloud VM cluster. For details, see `Exadata Infrastructure Time Zones` _.
`type`	`string`	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
`vipIds`	`array`	The virtual IP (VIP) addresses associated with the cloud VM cluster. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the Exadata Cloud Service instance to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster. Note: For a single-node DB system, this list is empty.
`vnetId`	`string`	VNET for network connectivity. Required.
`zoneId`	`string`	The OCID of the zone the cloud VM cluster is associated with.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Description
`get`	`select`	`resource_group_name`, `cloudvmclustername`, `subscription_id`	Get a CloudVmCluster.
`list_by_resource_group`	`select`	`resource_group_name`, `subscription_id`	List CloudVmCluster resources by resource group.
`list_by_subscription`	`select`	`subscription_id`	List CloudVmCluster resources by subscription ID.
`create_or_update`	`insert`	`resource_group_name`, `cloudvmclustername`, `subscription_id`, `location`	Create a CloudVmCluster.
`update`	`update`	`resource_group_name`, `cloudvmclustername`, `subscription_id`	Update a CloudVmCluster.
`create_or_update`	`replace`	`resource_group_name`, `cloudvmclustername`, `subscription_id`, `location`	Create a CloudVmCluster.
`delete`	`delete`	`resource_group_name`, `cloudvmclustername`, `subscription_id`	Delete a CloudVmCluster.
`list_private_ip_addresses`	`exec`	`resource_group_name`, `cloudvmclustername`, `subscription_id`, `subnetId`, `vnicId`	List Private IP Addresses by the provided filter.
`add_vms`	`exec`	`resource_group_name`, `cloudvmclustername`, `subscription_id`, `dbServers`	Add VMs to the VM Cluster.
`remove_vms`	`exec`	`resource_group_name`, `cloudvmclustername`, `subscription_id`, `dbServers`	Remove VMs from the VM Cluster.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
`cloudvmclustername`	`string`	CloudVmCluster name. Required.
`resource_group_name`	`string`	The name of the resource group. The name is case insensitive. Required.
`subscription_id`	`string`

`SELECT` examples

get
list_by_resource_group
list_by_subscription

Get a CloudVmCluster.

SELECT
id,
name,
backupSubnetCidr,
cloudExadataInfrastructureId,
clusterName,
compartmentId,
computeModel,
computeNodes,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dataStorageSizeInTbs,
dbNodeStorageSizeInGbs,
dbServers,
diskRedundancy,
displayName,
domain,
exascaleDbStorageVaultId,
fileSystemConfigurationDetails,
giVersion,
hostname,
iormConfigCache,
isLocalBackupEnabled,
isSparseDiskgroupEnabled,
lastUpdateHistoryEntryId,
licenseModel,
lifecycleDetails,
lifecycleState,
listenerPort,
location,
memorySizeInGbs,
nodeCount,
nsgCidrs,
nsgUrl,
ociUrl,
ocid,
ocpuCount,
provisioningState,
scanDnsName,
scanDnsRecordId,
scanIpIds,
scanListenerPortTcp,
scanListenerPortTcpSsl,
shape,
sshPublicKeys,
storageManagementType,
storageSizeInGbs,
subnetId,
subnetOcid,
systemData,
systemVersion,
tags,
timeCreated,
timeZone,
type,
vipIds,
vnetId,
zoneId
FROM azure_isv.oracledatabase.cloud_vm_clusters
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND cloudvmclustername = '{{ cloudvmclustername }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

List CloudVmCluster resources by resource group.

SELECT
id,
name,
backupSubnetCidr,
cloudExadataInfrastructureId,
clusterName,
compartmentId,
computeModel,
computeNodes,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dataStorageSizeInTbs,
dbNodeStorageSizeInGbs,
dbServers,
diskRedundancy,
displayName,
domain,
exascaleDbStorageVaultId,
fileSystemConfigurationDetails,
giVersion,
hostname,
iormConfigCache,
isLocalBackupEnabled,
isSparseDiskgroupEnabled,
lastUpdateHistoryEntryId,
licenseModel,
lifecycleDetails,
lifecycleState,
listenerPort,
location,
memorySizeInGbs,
nodeCount,
nsgCidrs,
nsgUrl,
ociUrl,
ocid,
ocpuCount,
provisioningState,
scanDnsName,
scanDnsRecordId,
scanIpIds,
scanListenerPortTcp,
scanListenerPortTcpSsl,
shape,
sshPublicKeys,
storageManagementType,
storageSizeInGbs,
subnetId,
subnetOcid,
systemData,
systemVersion,
tags,
timeCreated,
timeZone,
type,
vipIds,
vnetId,
zoneId
FROM azure_isv.oracledatabase.cloud_vm_clusters
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

List CloudVmCluster resources by subscription ID.

SELECT
id,
name,
backupSubnetCidr,
cloudExadataInfrastructureId,
clusterName,
compartmentId,
computeModel,
computeNodes,
cpuCoreCount,
dataCollectionOptions,
dataStoragePercentage,
dataStorageSizeInTbs,
dbNodeStorageSizeInGbs,
dbServers,
diskRedundancy,
displayName,
domain,
exascaleDbStorageVaultId,
fileSystemConfigurationDetails,
giVersion,
hostname,
iormConfigCache,
isLocalBackupEnabled,
isSparseDiskgroupEnabled,
lastUpdateHistoryEntryId,
licenseModel,
lifecycleDetails,
lifecycleState,
listenerPort,
location,
memorySizeInGbs,
nodeCount,
nsgCidrs,
nsgUrl,
ociUrl,
ocid,
ocpuCount,
provisioningState,
scanDnsName,
scanDnsRecordId,
scanIpIds,
scanListenerPortTcp,
scanListenerPortTcpSsl,
shape,
sshPublicKeys,
storageManagementType,
storageSizeInGbs,
subnetId,
subnetOcid,
systemData,
systemVersion,
tags,
timeCreated,
timeZone,
type,
vipIds,
vnetId,
zoneId
FROM azure_isv.oracledatabase.cloud_vm_clusters
WHERE subscription_id = '{{ subscription_id }}' -- required
;

`INSERT` examples

create_or_update
Manifest

Create a CloudVmCluster.

INSERT INTO azure_isv.oracledatabase.cloud_vm_clusters (
tags,
location,
properties,
resource_group_name,
cloudvmclustername,
subscription_id
)
SELECT 
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ cloudvmclustername }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

# Description fields are for documentation purposes
- name: cloud_vm_clusters
props:
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the cloud_vm_clusters resource.
  - name: cloudvmclustername
    value: "{{ cloudvmclustername }}"
    description: Required parameter for the cloud_vm_clusters resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the cloud_vm_clusters resource.
  - name: tags
    value: "{{ tags }}"
    description: |
      Resource tags.
  - name: location
    value: "{{ location }}"
    description: |
      The geo-location where the resource lives. Required.
  - name: properties
    description: |
      The resource-specific properties for this resource.
    value:
      ocid: "{{ ocid }}"
      listenerPort: {{ listenerPort }}
      nodeCount: {{ nodeCount }}
      storageSizeInGbs: {{ storageSizeInGbs }}
      fileSystemConfigurationDetails:
        - mountPoint: "{{ mountPoint }}"
          fileSystemSizeGb: {{ fileSystemSizeGb }}
      dataStorageSizeInTbs: {{ dataStorageSizeInTbs }}
      dbNodeStorageSizeInGbs: {{ dbNodeStorageSizeInGbs }}
      memorySizeInGbs: {{ memorySizeInGbs }}
      timeCreated: "{{ timeCreated }}"
      lifecycleDetails: "{{ lifecycleDetails }}"
      timeZone: "{{ timeZone }}"
      zoneId: "{{ zoneId }}"
      hostname: "{{ hostname }}"
      domain: "{{ domain }}"
      cpuCoreCount: {{ cpuCoreCount }}
      ocpuCount: {{ ocpuCount }}
      clusterName: "{{ clusterName }}"
      dataStoragePercentage: {{ dataStoragePercentage }}
      isLocalBackupEnabled: {{ isLocalBackupEnabled }}
      cloudExadataInfrastructureId: "{{ cloudExadataInfrastructureId }}"
      isSparseDiskgroupEnabled: {{ isSparseDiskgroupEnabled }}
      systemVersion: "{{ systemVersion }}"
      sshPublicKeys:
        - "{{ sshPublicKeys }}"
      licenseModel: "{{ licenseModel }}"
      diskRedundancy: "{{ diskRedundancy }}"
      scanIpIds:
        - "{{ scanIpIds }}"
      vipIds:
        - "{{ vipIds }}"
      scanDnsName: "{{ scanDnsName }}"
      scanListenerPortTcp: {{ scanListenerPortTcp }}
      scanListenerPortTcpSsl: {{ scanListenerPortTcpSsl }}
      scanDnsRecordId: "{{ scanDnsRecordId }}"
      shape: "{{ shape }}"
      provisioningState: "{{ provisioningState }}"
      lifecycleState: "{{ lifecycleState }}"
      vnetId: "{{ vnetId }}"
      giVersion: "{{ giVersion }}"
      ociUrl: "{{ ociUrl }}"
      nsgUrl: "{{ nsgUrl }}"
      subnetId: "{{ subnetId }}"
      backupSubnetCidr: "{{ backupSubnetCidr }}"
      nsgCidrs:
        - source: "{{ source }}"
          destinationPortRange:
            min: {{ min }}
            max: {{ max }}
      dataCollectionOptions:
        isDiagnosticsEventsEnabled: {{ isDiagnosticsEventsEnabled }}
        isHealthMonitoringEnabled: {{ isHealthMonitoringEnabled }}
        isIncidentLogsEnabled: {{ isIncidentLogsEnabled }}
      displayName: "{{ displayName }}"
      computeNodes:
        - "{{ computeNodes }}"
      iormConfigCache:
        dbPlans:
          - dbName: "{{ dbName }}"
            flashCacheLimit: "{{ flashCacheLimit }}"
            share: {{ share }}
        lifecycleDetails: "{{ lifecycleDetails }}"
        lifecycleState: "{{ lifecycleState }}"
        objective: "{{ objective }}"
      lastUpdateHistoryEntryId: "{{ lastUpdateHistoryEntryId }}"
      dbServers:
        - "{{ dbServers }}"
      compartmentId: "{{ compartmentId }}"
      subnetOcid: "{{ subnetOcid }}"
      computeModel: "{{ computeModel }}"
      exascaleDbStorageVaultId: "{{ exascaleDbStorageVaultId }}"
      storageManagementType: "{{ storageManagementType }}"

`UPDATE` examples

update

Update a CloudVmCluster.

UPDATE azure_isv.oracledatabase.cloud_vm_clusters
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND cloudvmclustername = '{{ cloudvmclustername }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

`REPLACE` examples

create_or_update

Create a CloudVmCluster.

REPLACE azure_isv.oracledatabase.cloud_vm_clusters
SET 
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND cloudvmclustername = '{{ cloudvmclustername }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

`DELETE` examples

delete

Delete a CloudVmCluster.

DELETE FROM azure_isv.oracledatabase.cloud_vm_clusters
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND cloudvmclustername = '{{ cloudvmclustername }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

list_private_ip_addresses
add_vms
remove_vms

List Private IP Addresses by the provided filter.

EXEC azure_isv.oracledatabase.cloud_vm_clusters.list_private_ip_addresses 
@resource_group_name='{{ resource_group_name }}' --required, 
@cloudvmclustername='{{ cloudvmclustername }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"subnetId": "{{ subnetId }}", 
"vnicId": "{{ vnicId }}"
}'
;

Add VMs to the VM Cluster.

EXEC azure_isv.oracledatabase.cloud_vm_clusters.add_vms 
@resource_group_name='{{ resource_group_name }}' --required, 
@cloudvmclustername='{{ cloudvmclustername }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"dbServers": "{{ dbServers }}"
}'
;

Remove VMs from the VM Cluster.

EXEC azure_isv.oracledatabase.cloud_vm_clusters.remove_vms 
@resource_group_name='{{ resource_group_name }}' --required, 
@cloudvmclustername='{{ cloudvmclustername }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"dbServers": "{{ dbServers }}"
}'
;

Overview​

Fields​

Methods​

Parameters​

SELECT examples​

INSERT examples​

UPDATE examples​

REPLACE examples​

DELETE examples​

Lifecycle Methods​