Skip to main content

cloud_autonomous_vm_clusters

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

Overview

Namecloud_autonomous_vm_clusters
TypeResource
Idaws.odb.cloud_autonomous_vm_clusters

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
autonomous_data_storage_percentagenumber (float)The percentage of data storage currently in use for Autonomous Databases in the Autonomous VM cluster.
autonomous_data_storage_size_in_tbsnumber (double)The data storage size allocated for Autonomous Databases in the Autonomous VM cluster, in TB.
available_autonomous_data_storage_size_in_tbsnumber (double)The available data storage space for Autonomous Databases in the Autonomous VM cluster, in TB.
available_container_databasesintegerThe number of Autonomous CDBs that you can create with the currently available storage.
available_cpusnumber (float)The number of CPU cores available for allocation to Autonomous Databases.
cloud_autonomous_vm_cluster_arnstringThe Amazon Resource Name (ARN) for the Autonomous VM cluster.
cloud_autonomous_vm_cluster_idstringThe unique identifier of the Autonomous VM cluster. (pattern: <code>[a-zA-Z0-9_~.-]+</code>)
cloud_exadata_infrastructure_arnstringThe Amazon Resource Name (ARN) of the Cloud Exadata Infrastructure containing this Autonomous VM cluster. (pattern: <code>arn:(?:aws|aws-cn|aws-us-gov|aws-iso-{0,1}[a-z]{0,1}):[a-z0-9-]+:[a-z0-9-]*:[0-9]+:[a-z0-9-]+/[a-z0-9-_]{6,64}</code>)
cloud_exadata_infrastructure_idstringThe unique identifier of the Cloud Exadata Infrastructure containing this Autonomous VM cluster. (pattern: <code>(arn:(?:aws|aws-cn|aws-us-gov|aws-iso-{0,1}[a-z]{0,1}):[a-z0-9-]+:[a-z0-9-]*:[0-9]+:[a-z0-9-]+/[a-zA-Z0-9_.-]{6,64}|[a-zA-Z0-9_.-]{6,64})</code>)
compute_modelstringThe compute model of the Autonomous VM cluster: ECPU or OCPU. (ECPU, OCPU)
cpu_core_countintegerThe total number of CPU cores in the Autonomous VM cluster.
cpu_core_count_per_nodeintegerThe number of CPU cores enabled per node in the Autonomous VM cluster.
cpu_percentagenumber (float)The percentage of total CPU cores currently in use in the Autonomous VM cluster.
created_atstring (date-time)The date and time when the Autonomous VM cluster was created.
data_storage_size_in_gbsnumber (double)The total data storage allocated to the Autonomous VM cluster, in GB.
data_storage_size_in_tbsnumber (double)The total data storage allocated to the Autonomous VM cluster, in TB.
db_node_storage_size_in_gbsintegerThe local node storage allocated to the Autonomous VM cluster, in gigabytes (GB).
db_serversarrayThe list of database servers associated with the Autonomous VM cluster.
descriptionstringThe user-provided description of the Autonomous VM cluster.
display_namestringThe display name of the Autonomous VM cluster. (pattern: <code>[a-zA-Z_](?!.--)[a-zA-Z0-9_-]</code>)
domainstringThe domain name for the Autonomous VM cluster.
exadata_storage_in_t_bs_lowest_scaled_valuenumber (double)The minimum value to which you can scale down the Exadata storage, in TB.
hostnamestringThe hostname for the Autonomous VM cluster.
iam_rolesarrayThe Amazon Web Services Identity and Access Management (IAM) service roles associated with the Autonomous VM cluster.
is_mtls_enabled_vm_clusterbooleanIndicates whether mutual TLS (mTLS) authentication is enabled for the Autonomous VM cluster.
license_modelstringThe Oracle license model that applies to the Autonomous VM cluster. (BRING_YOUR_OWN_LICENSE, LICENSE_INCLUDED)
maintenance_windowobjectThe scheduling details for the maintenance window. Patching and system updates take place during the maintenance window.
max_acds_lowest_scaled_valueintegerThe minimum value to which you can scale down the maximum number of Autonomous CDBs.
memory_per_oracle_compute_unit_in_gbsintegerThe amount of memory allocated per Oracle Compute Unit, in GB.
memory_size_in_gbsintegerThe total amount of memory allocated to the Autonomous VM cluster, in gigabytes (GB).
node_countintegerThe number of database server nodes in the Autonomous VM cluster.
non_provisionable_autonomous_container_databasesintegerThe number of Autonomous CDBs that can't be provisioned because of resource constraints.
oci_resource_anchor_namestringThe name of the OCI resource anchor associated with this Autonomous VM cluster.
oci_urlstringThe URL for accessing the OCI console page for this Autonomous VM cluster.
ocidstringThe Oracle Cloud Identifier (OCID) of the Autonomous VM cluster.
odb_network_arnstringThe Amazon Resource Name (ARN) of the ODB network associated with this Autonomous VM cluster. (pattern: <code>arn:(?:aws|aws-cn|aws-us-gov|aws-iso-{0,1}[a-z]{0,1}):[a-z0-9-]+:[a-z0-9-]*:[0-9]+:[a-z0-9-]+/[a-z0-9-_]{6,64}</code>)
odb_network_idstringThe unique identifier of the ODB network associated with this Autonomous VM cluster. (pattern: <code>(arn:(?:aws|aws-cn|aws-us-gov|aws-iso-{0,1}[a-z]{0,1}):[a-z0-9-]+:[a-z0-9-]*:[0-9]+:[a-z0-9-]+/[a-zA-Z0-9_.-]{6,64}|[a-zA-Z0-9_.-]{6,64})</code>)
percent_progressnumber (float)The progress of the current operation on the Autonomous VM cluster, as a percentage.
provisionable_autonomous_container_databasesintegerThe number of Autonomous CDBs that can be provisioned in the Autonomous VM cluster.
provisioned_autonomous_container_databasesintegerThe number of Autonomous CDBs currently provisioned in the Autonomous VM cluster.
provisioned_cpusnumber (float)The number of CPU cores currently provisioned in the Autonomous VM cluster.
reclaimable_cpusnumber (float)The number of CPU cores that can be reclaimed from terminated or scaled-down Autonomous Databases.
reserved_cpusnumber (float)The number of CPU cores reserved for system operations and redundancy.
scan_listener_port_non_tlsintegerThe SCAN listener port for non-TLS (TCP) protocol. The default is 1521.
scan_listener_port_tlsintegerThe SCAN listener port for TLS (TCP) protocol. The default is 2484.
shapestringThe shape of the Exadata infrastructure for the Autonomous VM cluster.
statusstringThe current state of the Autonomous VM cluster. Possible values include CREATING, AVAILABLE, UPDATING, DELETING, DELETED, FAILED. (AVAILABLE, FAILED, PROVISIONING, TERMINATED, TERMINATING, UPDATING, MAINTENANCE_IN_PROGRESS)
status_reasonstringAdditional information about the current status of the Autonomous VM cluster.
time_database_ssl_certificate_expiresstring (date-time)The expiration date and time of the database SSL certificate.
time_ords_certificate_expiresstring (date-time)The expiration date and time of the Oracle REST Data Services (ORDS) certificate.
time_zonestringThe time zone of the Autonomous VM cluster.
total_container_databasesintegerThe total number of Autonomous Container Databases that can be created with the allocated local storage.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_cloud_autonomous_vm_clusterselectregionGets information about a specific Autonomous VM cluster.
list_cloud_autonomous_vm_clustersselectregionLists all Autonomous VM clusters in a specified Cloud Exadata infrastructure.
create_cloud_autonomous_vm_clusterinsertregion, cloudExadataInfrastructureId, odbNetworkId, displayName, autonomousDataStorageSizeInTBs, cpuCoreCountPerNode, memoryPerOracleComputeUnitInGBs, totalContainerDatabasesCreates a new Autonomous VM cluster in the specified Exadata infrastructure.
delete_cloud_autonomous_vm_clusterdeleteregionDeletes an Autonomous 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.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Gets information about a specific Autonomous VM cluster.

SELECT
autonomous_data_storage_percentage,
autonomous_data_storage_size_in_tbs,
available_autonomous_data_storage_size_in_tbs,
available_container_databases,
available_cpus,
cloud_autonomous_vm_cluster_arn,
cloud_autonomous_vm_cluster_id,
cloud_exadata_infrastructure_arn,
cloud_exadata_infrastructure_id,
compute_model,
cpu_core_count,
cpu_core_count_per_node,
cpu_percentage,
created_at,
data_storage_size_in_gbs,
data_storage_size_in_tbs,
db_node_storage_size_in_gbs,
db_servers,
description,
display_name,
domain,
exadata_storage_in_t_bs_lowest_scaled_value,
hostname,
iam_roles,
is_mtls_enabled_vm_cluster,
license_model,
maintenance_window,
max_acds_lowest_scaled_value,
memory_per_oracle_compute_unit_in_gbs,
memory_size_in_gbs,
node_count,
non_provisionable_autonomous_container_databases,
oci_resource_anchor_name,
oci_url,
ocid,
odb_network_arn,
odb_network_id,
percent_progress,
provisionable_autonomous_container_databases,
provisioned_autonomous_container_databases,
provisioned_cpus,
reclaimable_cpus,
reserved_cpus,
scan_listener_port_non_tls,
scan_listener_port_tls,
shape,
status,
status_reason,
time_database_ssl_certificate_expires,
time_ords_certificate_expires,
time_zone,
total_container_databases
FROM aws.odb.cloud_autonomous_vm_clusters
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a new Autonomous VM cluster in the specified Exadata infrastructure.

INSERT INTO aws.odb.cloud_autonomous_vm_clusters (
cloudExadataInfrastructureId,
odbNetworkId,
displayName,
clientToken,
autonomousDataStorageSizeInTBs,
cpuCoreCountPerNode,
dbServers,
description,
isMtlsEnabledVmCluster,
licenseModel,
maintenanceWindow,
memoryPerOracleComputeUnitInGBs,
scanListenerPortNonTls,
scanListenerPortTls,
tags,
timeZone,
totalContainerDatabases,
region
)
SELECT
'{{ cloudExadataInfrastructureId }}' /* required */,
'{{ odbNetworkId }}' /* required */,
'{{ displayName }}' /* required */,
'{{ clientToken }}',
{{ autonomousDataStorageSizeInTBs }} /* required */,
{{ cpuCoreCountPerNode }} /* required */,
'{{ dbServers }}',
'{{ description }}',
{{ isMtlsEnabledVmCluster }},
'{{ licenseModel }}',
'{{ maintenanceWindow }}',
{{ memoryPerOracleComputeUnitInGBs }} /* required */,
{{ scanListenerPortNonTls }},
{{ scanListenerPortTls }},
'{{ tags }}',
'{{ timeZone }}',
{{ totalContainerDatabases }} /* required */,
'{{ region }}'
RETURNING
cloud_autonomous_vm_cluster_id,
display_name,
status,
status_reason
;

DELETE examples

Deletes an Autonomous VM cluster.

DELETE FROM aws.odb.cloud_autonomous_vm_clusters
WHERE region = '{{ region }}' --required
;