cloud_vm_clusters

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

Overview

Name	cloud_vm_clusters
Type	Resource
Id	google.oracledatabase.cloud_vm_clusters

Fields

Name	Datatype	Description
name	string	Identifier. The name of the VM Cluster resource with the format: projects/{project}/locations/{region}/cloudVmClusters/{cloud_vm_cluster}
backupSubnetCidr	string	Required. CIDR range of the backup subnet.
cidr	string	Required. Network settings. CIDR to use for cluster IP allocation.
createTime	string	Output only. The date and time that the VM cluster was created.
displayName	string	Optional. User friendly name for this resource.
exadataInfrastructure	string	Required. The name of the Exadata Infrastructure resource on which VM cluster resource is created, in the following format: projects/{project}/locations/{region}/cloudExadataInfrastuctures/{cloud_extradata_infrastructure}
gcpOracleZone	string	Output only. GCP location where Oracle Exadata is hosted. It is same as GCP Oracle zone of Exadata infrastructure.
labels	object	Optional. Labels or tags associated with the VM Cluster.
network	string	Required. The name of the VPC network. Format: projects/{project}/global/networks/{network}
properties	object	Various properties and settings associated with Exadata VM cluster.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudVmClustersId, locationsId, projectsId	Gets details of a single VM Cluster.
list	SELECT	locationsId, projectsId	Lists the VM Clusters in a given project and location.
create	INSERT	locationsId, projectsId	Creates a new VM Cluster in a given project and location.
delete	DELETE	cloudVmClustersId, locationsId, projectsId	Deletes a single VM Cluster.

SELECT examples

Lists the VM Clusters in a given project and location.

SELECT
name,
backupSubnetCidr,
cidr,
createTime,
displayName,
exadataInfrastructure,
gcpOracleZone,
labels,
network,
properties
FROM google.oracledatabase.cloud_vm_clusters
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO google.oracledatabase.cloud_vm_clusters (
locationsId,
projectsId,
name,
exadataInfrastructure,
displayName,
properties,
labels,
cidr,
backupSubnetCidr,
network
)
SELECT 
'{{ locationsId }}',
'{{ projectsId }}',
'{{ name }}',
'{{ exadataInfrastructure }}',
'{{ displayName }}',
'{{ properties }}',
'{{ labels }}',
'{{ cidr }}',
'{{ backupSubnetCidr }}',
'{{ network }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: exadataInfrastructure
      value: string
    - name: displayName
      value: string
    - name: gcpOracleZone
      value: string
    - name: properties
      value:
        - name: ocid
          value: string
        - name: licenseType
          value: string
        - name: giVersion
          value: string
        - name: timeZone
          value:
            - name: id
              value: string
            - name: version
              value: string
        - name: sshPublicKeys
          value:
            - string
        - name: nodeCount
          value: integer
        - name: shape
          value: string
        - name: ocpuCount
          value: number
        - name: memorySizeGb
          value: integer
        - name: dbNodeStorageSizeGb
          value: integer
        - name: storageSizeGb
          value: integer
        - name: dataStorageSizeTb
          value: number
        - name: diskRedundancy
          value: string
        - name: sparseDiskgroupEnabled
          value: boolean
        - name: localBackupEnabled
          value: boolean
        - name: hostnamePrefix
          value: string
        - name: diagnosticsDataCollectionOptions
          value:
            - name: diagnosticsEventsEnabled
              value: boolean
            - name: healthMonitoringEnabled
              value: boolean
            - name: incidentLogsEnabled
              value: boolean
        - name: state
          value: string
        - name: scanListenerPortTcp
          value: integer
        - name: scanListenerPortTcpSsl
          value: integer
        - name: domain
          value: string
        - name: scanDns
          value: string
        - name: hostname
          value: string
        - name: cpuCoreCount
          value: integer
        - name: systemVersion
          value: string
        - name: scanIpIds
          value:
            - string
        - name: scanDnsRecordId
          value: string
        - name: ociUrl
          value: string
        - name: dbServerOcids
          value:
            - string
        - name: compartmentId
          value: string
        - name: dnsListenerIp
          value: string
        - name: clusterName
          value: string
    - name: labels
      value: object
    - name: createTime
      value: string
    - name: cidr
      value: string
    - name: backupSubnetCidr
      value: string
    - name: network
      value: string

DELETE example

Deletes the specified cloud_vm_clusters resource.

/*+ delete */
DELETE FROM google.oracledatabase.cloud_vm_clusters
WHERE cloudVmClustersId = '{{ cloudVmClustersId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';