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)
list (identifiers only)

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.

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)
list (identifiers only)

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

Lists all cloud_exadata_infrastructures in a region.

SELECT
  region,
  cloud_exadata_infrastructure_arn
FROM awscc.odb.cloud_exadata_infrastructures_list_only
WHERE
  region = '{{ region }}';

`INSERT` example

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

Required Properties
All Properties
Manifest

/*+ 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 }}'
RETURNING
  ErrorCode,
  EventTime,
  Identifier,
  Operation,
  OperationStatus,
  RequestToken,
  ResourceModel,
  RetryAfter,
  StatusMessage,
  TypeName
;

/*+ 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 }}'
RETURNING
  ErrorCode,
  EventTime,
  Identifier,
  Operation,
  OperationStatus,
  RequestToken,
  ResourceModel,
  RetryAfter,
  StatusMessage,
  TypeName
;

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 }}'
RETURNING
  ErrorCode,
  EventTime,
  Identifier,
  Operation,
  OperationStatus,
  RequestToken,
  ResourceModel,
  RetryAfter,
  StatusMessage,
  TypeName
;

`DELETE` example

/*+ delete */
DELETE FROM awscc.odb.cloud_exadata_infrastructures
WHERE
  Identifier = '{{ cloud_exadata_infrastructure_arn }}' AND
  region = '{{ region }}'
RETURNING
  ErrorCode,
  EventTime,
  Identifier,
  Operation,
  OperationStatus,
  RequestToken,
  ResourceModel,
  RetryAfter,
  StatusMessage,
  TypeName
;

Additional Parameters

Mutable resources in the Cloud Control provider support additional optional parameters which can be supplied with INSERT, UPDATE, or DELETE operations. These include:

Parameter	Description
`ClientToken`	A unique identifier to ensure the idempotency of the resource request. This allows the provider to accurately distinguish between retries and new requests. A client token is valid for 36 hours once used. After that, a resource request with the same client token is treated as a new request. If you do not specify a client token, one is generated for inclusion in the request.
`RoleArn`	The ARN of the IAM role used to perform this resource operation. The role specified must have the permissions required for this operation. If you do not specify a role, a temporary session is created using your AWS user credentials.
`TypeVersionId`	For private resource types, the type version to use in this resource operation. If you do not specify a resource version, the default version is used.

Permissions

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

Create
Read
Update
Delete
List

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

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

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

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

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

Overview​

Fields​

Methods​

SELECT examples​

INSERT example​

UPDATE example​

DELETE example​

Additional Parameters​

Permissions​