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

get (all properties)

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.

list (identifiers only)

Name	Datatype	Description
cloud_exadata_infrastructure_arn	string	The Amazon Resource Name (ARN) for the Exadata infrastructure.
region	string	AWS region.

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

Methods

Name	Resource	Accessible by	Required Params
create_resource	cloud_exadata_infrastructures	INSERT	region
delete_resource	cloud_exadata_infrastructures	DELETE	Identifier, region
update_resource	cloud_exadata_infrastructures	UPDATE	Identifier, PatchDocument, region
list_resources	cloud_exadata_infrastructures_list_only	SELECT	region
get_resource	cloud_exadata_infrastructures	SELECT	Identifier, region

SELECT examples

get (all properties)

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
  Identifier = '{{ cloud_exadata_infrastructure_arn }}';

list (identifiers only)

Lists all cloud_exadata_infrastructures in a region.

SELECT
  region,
  cloud_exadata_infrastructure_arn
FROM awscc.odb.cloud_exadata_infrastructures_list_only
WHERE
  region = 'us-east-1';

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
  '{{ availability_zone }}',
  '{{ availability_zone_id }}',
  '{{ compute_count }}',
  '{{ customer_contacts_to_send_to_oc_i }}',
  '{{ database_server_type }}',
  '{{ display_name }}',
  '{{ shape }}',
  '{{ storage_count }}',
  '{{ storage_server_type }}',
  '{{ tags }}',
  '{{ region }}';

All Properties

/*+ create */
INSERT INTO awscc.odb.cloud_exadata_infrastructures (
  AvailabilityZone,
  AvailabilityZoneId,
  ComputeCount,
  CustomerContactsToSendToOCI,
  DatabaseServerType,
  DisplayName,
  Shape,
  StorageCount,
  StorageServerType,
  Tags,
  region
)
SELECT
  '{{ availability_zone }}',
  '{{ availability_zone_id }}',
  '{{ compute_count }}',
  '{{ customer_contacts_to_send_to_oc_i }}',
  '{{ database_server_type }}',
  '{{ display_name }}',
  '{{ shape }}',
  '{{ storage_count }}',
  '{{ storage_server_type }}',
  '{{ 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: availability_zone
        value: '{{ availability_zone }}'
      - name: availability_zone_id
        value: '{{ availability_zone_id }}'
      - name: compute_count
        value: '{{ compute_count }}'
      - name: customer_contacts_to_send_to_oc_i
        value:
          - email: '{{ email }}'
      - name: database_server_type
        value: '{{ database_server_type }}'
      - name: display_name
        value: '{{ display_name }}'
      - name: shape
        value: '{{ shape }}'
      - name: storage_count
        value: '{{ storage_count }}'
      - name: storage_server_type
        value: '{{ storage_server_type }}'
      - name: tags
        value:
          - key: '{{ key }}'
            value: '{{ value }}'

UPDATE example

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

/*+ update */
UPDATE awscc.odb.cloud_exadata_infrastructures
SET PatchDocument = string('{{ {
    "Tags": tags
} | generate_patch_document }}')
WHERE
  region = '{{ region }}' AND
  Identifier = '{{ cloud_exadata_infrastructure_arn }}';

DELETE example

/*+ delete */
DELETE FROM awscc.odb.cloud_exadata_infrastructures
WHERE
  Identifier = '{{ cloud_exadata_infrastructure_arn }}' 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