cloud_exadata_infrastructures

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

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Id	aws.odb.cloud_exadata_infrastructures

Fields

The following fields are returned by SELECT queries:

get_cloud_exadata_infrastructure

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. (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_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. (ECPU, OCPU)
cpu_count	integer	The total number of CPU cores that are allocated to the Exadata infrastructure.
created_at	string (date-time)	The date and time when the Exadata infrastructure was created.
customer_contacts_to_send_to_oci	array	The email addresses of contacts to receive notification from Oracle about maintenance updates for the Exadata infrastructure.
data_storage_size_in_tbs	number (double)	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.
last_maintenance_run_id	string	The Oracle Cloud Identifier (OCID) of the last maintenance run for the Exadata infrastructure.
maintenance_window	object	The scheduling details for the maintenance window. Patching and system updates take place during the maintenance window.
max_cpu_count	integer	The total number of CPU cores available on the Exadata infrastructure.
max_data_storage_in_tbs	number (double)	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.
monthly_db_server_version	string	The monthly software version of the database servers installed on the Exadata infrastructure.
monthly_storage_server_version	string	The monthly software version of the storage servers installed on the Exadata infrastructure.
next_maintenance_run_id	string	The OCID of the next maintenance run for 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.
percent_progress	number (float)	The amount of progress made on the current operation on the Exadata infrastructure, expressed as a percentage.
shape	string	The model name of the Exadata infrastructure.
status	string	The current status of the Exadata infrastructure. (AVAILABLE, FAILED, PROVISIONING, TERMINATED, TERMINATING, UPDATING, MAINTENANCE_IN_PROGRESS)
status_reason	string	Additional information about the status 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.
total_storage_size_in_gbs	integer	The total amount of storage, in gigabytes (GB), on the the Exadata infrastructure.

list_cloud_exadata_infrastructures

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. (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_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. (ECPU, OCPU)
cpu_count	integer	The total number of CPU cores that are allocated to the Exadata infrastructure.
created_at	string (date-time)	The date and time when the Exadata infrastructure was created.
customer_contacts_to_send_to_oci	array	The email addresses of contacts to receive notification from Oracle about maintenance updates for the Exadata infrastructure.
data_storage_size_in_tbs	number (double)	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 on the Exadata infrastructure.
display_name	string	The user-friendly name for the Exadata infrastructure.
last_maintenance_run_id	string	The Oracle Cloud Identifier (OCID) of the last maintenance run for the Exadata infrastructure.
maintenance_window	object	The scheduling details for the maintenance window. Patching and system updates take place during the maintenance window.
max_cpu_count	integer	The total number of CPU cores available on the Exadata infrastructure.
max_data_storage_in_tbs	number (double)	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.
monthly_db_server_version	string	The monthly software version of the database servers (dom0) installed on the Exadata infrastructure.
monthly_storage_server_version	string	The monthly software version of the storage servers installed on the Exadata infrastructure.
next_maintenance_run_id	string	The OCID of the next maintenance run for 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.
percent_progress	number (float)	The amount of progress made on the current operation on the Exadata infrastructure, expressed as a percentage.
shape	string	The model name of the Exadata infrastructure.
status	string	The current status of the Exadata infrastructure. (AVAILABLE, FAILED, PROVISIONING, TERMINATED, TERMINATING, UPDATING, MAINTENANCE_IN_PROGRESS)
status_reason	string	Additional information about the status 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.
total_storage_size_in_gbs	integer	The total amount of storage, in gigabytes (GB), on the the Exadata infrastructure.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_cloud_exadata_infrastructure	select	region		Returns information about the specified Exadata infrastructure.
list_cloud_exadata_infrastructures	select	region		Returns information about the Exadata infrastructures owned by your Amazon Web Services account.
create_cloud_exadata_infrastructure	insert	region, displayName, shape, computeCount, storageCount		Creates an Exadata infrastructure.
update_cloud_exadata_infrastructure	update	region, cloudExadataInfrastructureId		Updates the properties of an Exadata infrastructure resource.
delete_cloud_exadata_infrastructure	delete	region		Deletes the specified Exadata infrastructure. Before you use this operation, make sure to delete all of the VM clusters that are hosted on this Exadata infrastructure.

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.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_cloud_exadata_infrastructure

Returns information about the specified Exadata infrastructure.

SELECT
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,
created_at,
customer_contacts_to_send_to_oci,
data_storage_size_in_tbs,
database_server_type,
db_node_storage_size_in_gbs,
db_server_version,
display_name,
last_maintenance_run_id,
maintenance_window,
max_cpu_count,
max_data_storage_in_tbs,
max_db_node_storage_size_in_gbs,
max_memory_in_gbs,
memory_size_in_gbs,
monthly_db_server_version,
monthly_storage_server_version,
next_maintenance_run_id,
oci_resource_anchor_name,
oci_url,
ocid,
percent_progress,
shape,
status,
status_reason,
storage_count,
storage_server_type,
storage_server_version,
total_storage_size_in_gbs
FROM aws.odb.cloud_exadata_infrastructures
WHERE region = '{{ region }}' -- required
;

list_cloud_exadata_infrastructures

Returns information about the Exadata infrastructures owned by your Amazon Web Services account.

SELECT
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,
created_at,
customer_contacts_to_send_to_oci,
data_storage_size_in_tbs,
database_server_type,
db_node_storage_size_in_gbs,
db_server_version,
display_name,
last_maintenance_run_id,
maintenance_window,
max_cpu_count,
max_data_storage_in_tbs,
max_db_node_storage_size_in_gbs,
max_memory_in_gbs,
memory_size_in_gbs,
monthly_db_server_version,
monthly_storage_server_version,
next_maintenance_run_id,
oci_resource_anchor_name,
oci_url,
ocid,
percent_progress,
shape,
status,
status_reason,
storage_count,
storage_server_type,
storage_server_version,
total_storage_size_in_gbs
FROM aws.odb.cloud_exadata_infrastructures
WHERE region = '{{ region }}' -- required
;

INSERT examples

create_cloud_exadata_infrastructure

Creates an Exadata infrastructure.

INSERT INTO aws.odb.cloud_exadata_infrastructures (
displayName,
shape,
availabilityZone,
availabilityZoneId,
tags,
computeCount,
customerContactsToSendToOCI,
maintenanceWindow,
storageCount,
clientToken,
databaseServerType,
storageServerType,
region
)
SELECT 
'{{ displayName }}' /* required */,
'{{ shape }}' /* required */,
'{{ availabilityZone }}',
'{{ availabilityZoneId }}',
'{{ tags }}',
{{ computeCount }} /* required */,
'{{ customerContactsToSendToOCI }}',
'{{ maintenanceWindow }}',
{{ storageCount }} /* required */,
'{{ clientToken }}',
'{{ databaseServerType }}',
'{{ storageServerType }}',
'{{ region }}'
RETURNING
cloud_exadata_infrastructure_id,
display_name,
status,
status_reason
;

Manifest

# Description fields are for documentation purposes
- name: cloud_exadata_infrastructures
props:
  - name: region
    value: "{{ region }}"
    description: Required parameter for the cloud_exadata_infrastructures resource.
  - name: displayName
    value: "{{ displayName }}"
    description: |
      A user-friendly name for the Exadata infrastructure.
  - name: shape
    value: "{{ shape }}"
    description: |
      The model name of the Exadata infrastructure. For the list of valid model names, use the ListDbSystemShapes operation.
  - name: availabilityZone
    value: "{{ availabilityZone }}"
    description: |
      The name of the Availability Zone (AZ) where the Exadata infrastructure is located. This operation requires that you specify a value for either availabilityZone or availabilityZoneId. Example: us-east-1a
  - name: availabilityZoneId
    value: "{{ availabilityZoneId }}"
    description: |
      The AZ ID of the AZ where the Exadata infrastructure is located. This operation requires that you specify a value for either availabilityZone or availabilityZoneId. Example: use1-az1
  - name: tags
    value: "{{ tags }}"
    description: |
      The list of resource tags to apply to the Exadata infrastructure.
  - name: computeCount
    value: {{ computeCount }}
    description: |
      The number of database servers for the Exadata infrastructure. Valid values for this parameter depend on the shape. To get information about the minimum and maximum values, use the ListDbSystemShapes operation.
  - name: customerContactsToSendToOCI
    description: |
      The email addresses of contacts to receive notification from Oracle about maintenance updates for the Exadata infrastructure.
    value:
      - email: "{{ email }}"
  - name: maintenanceWindow
    description: |
      The maintenance window configuration for the Exadata Cloud infrastructure. This allows you to define when maintenance operations such as patching and updates can be performed on the infrastructure.
    value:
      customActionTimeoutInMins: {{ customActionTimeoutInMins }}
      daysOfWeek:
        - name: "{{ name }}"
      hoursOfDay:
        - {{ hoursOfDay }}
      isCustomActionTimeoutEnabled: {{ isCustomActionTimeoutEnabled }}
      leadTimeInWeeks: {{ leadTimeInWeeks }}
      months:
        - name: "{{ name }}"
      patchingMode: "{{ patchingMode }}"
      preference: "{{ preference }}"
      skipRu: {{ skipRu }}
      weeksOfMonth:
        - {{ weeksOfMonth }}
  - name: storageCount
    value: {{ storageCount }}
    description: |
      The number of storage servers to activate for this Exadata infrastructure. Valid values for this parameter depend on the shape. To get information about the minimum and maximum values, use the ListDbSystemShapes operation.
  - name: clientToken
    value: "{{ clientToken }}"
    description: |
      A unique, case-sensitive identifier that you provide to ensure the idempotency of the request. If you don't specify a client token, the Amazon Web Services SDK automatically generates a client token and uses it for the request to ensure idempotency. The client token is valid for up to 24 hours after it's first used.
  - name: databaseServerType
    value: "{{ databaseServerType }}"
    description: |
      The database server model type of the Exadata infrastructure. For the list of valid model names, use the ListDbSystemShapes operation.
  - name: storageServerType
    value: "{{ storageServerType }}"
    description: |
      The storage server model type of the Exadata infrastructure. For the list of valid model names, use the ListDbSystemShapes operation.

UPDATE examples

update_cloud_exadata_infrastructure

Updates the properties of an Exadata infrastructure resource.

UPDATE aws.odb.cloud_exadata_infrastructures
SET 
cloudExadataInfrastructureId = '{{ cloudExadataInfrastructureId }}',
maintenanceWindow = '{{ maintenanceWindow }}'
WHERE 
region = '{{ region }}' --required
AND cloudExadataInfrastructureId = '{{ cloudExadataInfrastructureId }}' --required
RETURNING
cloud_exadata_infrastructure_id,
display_name,
status,
status_reason;

DELETE examples

delete_cloud_exadata_infrastructure

Deletes the specified Exadata infrastructure. Before you use this operation, make sure to delete all of the VM clusters that are hosted on this Exadata infrastructure.

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