cloud_exadata_infrastructures

Creates, updates, deletes or gets a cloud_exadata_infrastructure resource or lists cloud_exadata_infrastructures in a region

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Description	The AWS::ODB::CloudExadataInfrastructure resource creates an Exadata Infrastructure
Id	awscc.odb.cloud_exadata_infrastructures

Fields

Name	Datatype	Description
activated_storage_count	integer	The number of storage servers requested for the Exadata infrastructure.
additional_storage_count	integer	The number of storage servers requested for the Exadata infrastructure.
availability_zone	string	The name of the Availability Zone (AZ) where the Exadata infrastructure is located.
availability_zone_id	string	The AZ ID of the AZ where the Exadata infrastructure is located.
available_storage_size_in_gbs	integer	The amount of available storage, in gigabytes (GB), for the Exadata infrastructure.
cloud_exadata_infrastructure_arn	string	The Amazon Resource Name (ARN) for the Exadata infrastructure.
cloud_exadata_infrastructure_id	string	The unique identifier for the Exadata infrastructure.
compute_count	integer	The number of database servers for the Exadata infrastructure.
compute_model	string	The OCI model compute model used when you create or clone an instance: ECPU or OCPU. An ECPU is an abstracted measure of compute resources. ECPUs are based on the number of cores elastically allocated from a pool of compute and storage servers. An OCPU is a legacy physical measure of compute resources. OCPUs are based on the physical core of a processor with hyper-threading enabled.
cpu_count	integer	The total number of CPU cores that are allocated to the Exadata infrastructure.
▶customer_contacts_to_send_to_oc_i	array	The email addresses of contacts to receive notification from Oracle about maintenance updates for the Exadata infrastructure.
data_storage_size_in_tbs	number	The size of the Exadata infrastructure's data disk group, in terabytes (TB).
database_server_type	string	The database server model type of the Exadata infrastructure. For the list of valid model names, use the ListDbSystemShapes operation.
db_node_storage_size_in_gbs	integer	The size of the Exadata infrastructure's local node storage, in gigabytes (GB).
db_server_version	string	The software version of the database servers (dom0) in the Exadata infrastructure.
display_name	string	The user-friendly name for the Exadata infrastructure.
max_cpu_count	integer	The total number of CPU cores available on the Exadata infrastructure.
max_data_storage_in_tbs	number	The total amount of data disk group storage, in terabytes (TB), that's available on the Exadata infrastructure.
max_db_node_storage_size_in_gbs	integer	The total amount of local node storage, in gigabytes (GB), that's available on the Exadata infrastructure.
max_memory_in_gbs	integer	The total amount of memory, in gigabytes (GB), that's available on the Exadata infrastructure.
memory_size_in_gbs	integer	The amount of memory, in gigabytes (GB), that's allocated on the Exadata infrastructure.
oci_resource_anchor_name	string	The name of the OCI resource anchor for the Exadata infrastructure.
oci_url	string	The HTTPS link to the Exadata infrastructure in OCI.
ocid	string	The OCID of the Exadata infrastructure.
shape	string	The model name of the Exadata infrastructure.
storage_count	integer	The number of storage servers that are activated for the Exadata infrastructure.
storage_server_type	string	The storage server model type of the Exadata infrastructure. For the list of valid model names, use the ListDbSystemShapes operation.
storage_server_version	string	The software version of the storage servers on the Exadata infrastructure.
▶tags	array	Tags to assign to the Exadata Infrastructure.
total_storage_size_in_gbs	integer	The total amount of storage, in gigabytes (GB), on the the Exadata infrastructure.
db_server_ids	array	The list of database server identifiers for the Exadata infrastructure.
region	string	AWS region.

For more information, see AWS::ODB::CloudExadataInfrastructure.

Methods

Name	Accessible by	Required Params
create_resource	INSERT	region
delete_resource	DELETE	data__Identifier, region
update_resource	UPDATE	data__Identifier, data__PatchDocument, region
list_resources	SELECT	region
get_resource	SELECT	data__Identifier, region

SELECT examples

Gets all properties from an individual cloud_exadata_infrastructure.

SELECT
region,
activated_storage_count,
additional_storage_count,
availability_zone,
availability_zone_id,
available_storage_size_in_gbs,
cloud_exadata_infrastructure_arn,
cloud_exadata_infrastructure_id,
compute_count,
compute_model,
cpu_count,
customer_contacts_to_send_to_oc_i,
data_storage_size_in_tbs,
database_server_type,
db_node_storage_size_in_gbs,
db_server_version,
display_name,
max_cpu_count,
max_data_storage_in_tbs,
max_db_node_storage_size_in_gbs,
max_memory_in_gbs,
memory_size_in_gbs,
oci_resource_anchor_name,
oci_url,
ocid,
shape,
storage_count,
storage_server_type,
storage_server_version,
tags,
total_storage_size_in_gbs,
db_server_ids
FROM awscc.odb.cloud_exadata_infrastructures
WHERE region = 'us-east-1' AND data__Identifier = '<CloudExadataInfrastructureArn>';

INSERT example

Use the following StackQL query and manifest file to create a new cloud_exadata_infrastructure resource, using stack-deploy.

Required Properties

/*+ create */
INSERT INTO awscc.odb.cloud_exadata_infrastructures (
 AvailabilityZone,
 AvailabilityZoneId,
 ComputeCount,
 CustomerContactsToSendToOCI,
 DatabaseServerType,
 DisplayName,
 Shape,
 StorageCount,
 StorageServerType,
 Tags,
 region
)
SELECT 
'{{ AvailabilityZone }}',
 '{{ AvailabilityZoneId }}',
 '{{ ComputeCount }}',
 '{{ CustomerContactsToSendToOCI }}',
 '{{ DatabaseServerType }}',
 '{{ DisplayName }}',
 '{{ Shape }}',
 '{{ StorageCount }}',
 '{{ StorageServerType }}',
 '{{ Tags }}',
'{{ region }}';

All Properties

/*+ create */
INSERT INTO awscc.odb.cloud_exadata_infrastructures (
 AvailabilityZone,
 AvailabilityZoneId,
 ComputeCount,
 CustomerContactsToSendToOCI,
 DatabaseServerType,
 DisplayName,
 Shape,
 StorageCount,
 StorageServerType,
 Tags,
 region
)
SELECT 
 '{{ AvailabilityZone }}',
 '{{ AvailabilityZoneId }}',
 '{{ ComputeCount }}',
 '{{ CustomerContactsToSendToOCI }}',
 '{{ DatabaseServerType }}',
 '{{ DisplayName }}',
 '{{ Shape }}',
 '{{ StorageCount }}',
 '{{ StorageServerType }}',
 '{{ Tags }}',
 '{{ region }}';

Manifest

version: 1
name: stack name
description: stack description
providers:
  - aws
globals:
  - name: region
    value: '{{ vars.AWS_REGION }}'
resources:
  - name: cloud_exadata_infrastructure
    props:
      - name: AvailabilityZone
        value: '{{ AvailabilityZone }}'
      - name: AvailabilityZoneId
        value: '{{ AvailabilityZoneId }}'
      - name: ComputeCount
        value: '{{ ComputeCount }}'
      - name: CustomerContactsToSendToOCI
        value:
          - Email: '{{ Email }}'
      - name: DatabaseServerType
        value: '{{ DatabaseServerType }}'
      - name: DisplayName
        value: '{{ DisplayName }}'
      - name: Shape
        value: '{{ Shape }}'
      - name: StorageCount
        value: '{{ StorageCount }}'
      - name: StorageServerType
        value: '{{ StorageServerType }}'
      - name: Tags
        value:
          - Key: '{{ Key }}'
            Value: '{{ Value }}'

DELETE example

/*+ delete */
DELETE FROM awscc.odb.cloud_exadata_infrastructures
WHERE data__Identifier = '<CloudExadataInfrastructureArn>'
AND region = 'us-east-1';

Permissions

To operate on the cloud_exadata_infrastructures resource, the following permissions are required:

Create

odb:CreateCloudExadataInfrastructure,
ec2:DescribeAvailabilityZones,
iam:CreateServiceLinkedRole,
odb:ListCloudExadataInfrastructures,
odb:GetCloudExadataInfrastructure,
odb:ListDbServers,
odb:TagResource,
sts:GetCallerIdentity,
odb:ListTagsForResource

Read

odb:GetCloudExadataInfrastructure,
odb:ListDbServers,
sts:GetCallerIdentity,
odb:ListTagsForResource

Update

odb:UpdateCloudExadataInfrastructure,
odb:TagResource,
odb:UntagResource,
odb:ListCloudExadataInfrastructures,
odb:GetCloudExadataInfrastructure,
odb:ListDbServers,
sts:GetCallerIdentity,
odb:ListTagsForResource

Delete

odb:DeleteCloudExadataInfrastructure,
odb:ListCloudExadataInfrastructures,
odb:GetCloudExadataInfrastructure,
odb:ListDbServers,
sts:GetCallerIdentity,
odb:ListTagsForResource

List

odb:ListCloudExadataInfrastructures,
sts:GetCallerIdentity,
odb:ListTagsForResource,
odb:ListDbServers