cloud_exadata_infrastructures

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

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Id	azure_isv.oracle.cloud_exadata_infrastructures

Fields

vw_cloud_exadata_infrastructures

Name	Datatype	Description
activated_storage_count	text	field from the properties object
additional_storage_count	text	field from the properties object
available_storage_size_in_gbs	text	field from the properties object
cloudexadatainfrastructurename	text	field from the properties object
compute_count	text	field from the properties object
cpu_count	text	field from the properties object
customer_contacts	text	field from the properties object
data_storage_size_in_tbs	text	field from the properties object
db_node_storage_size_in_gbs	text	field from the properties object
db_server_version	text	field from the properties object
display_name	text	field from the properties object
estimated_patching_time	text	field from the properties object
last_maintenance_run_id	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
location	text	The geo-location where the resource lives
maintenance_window	text	field from the properties object
max_cpu_count	text	field from the properties object
max_data_storage_in_tbs	text	field from the properties object
max_db_node_storage_size_in_gbs	text	field from the properties object
max_memory_in_gbs	text	field from the properties object
memory_size_in_gbs	text	field from the properties object
monthly_db_server_version	text	field from the properties object
monthly_storage_server_version	text	field from the properties object
next_maintenance_run_id	text	field from the properties object
oci_url	text	field from the properties object
ocid	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
shape	text	field from the properties object
storage_count	text	field from the properties object
storage_server_version	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
time_created	text	field from the properties object
total_storage_size_in_gbs	text	field from the properties object
zones	text	CloudExadataInfrastructure zones

cloud_exadata_infrastructures

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	CloudExadataInfrastructure resource model
tags	object	Resource tags.
zones	array	CloudExadataInfrastructure zones

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cloudexadatainfrastructurename, resourceGroupName, subscriptionId	Get a CloudExadataInfrastructure
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List CloudExadataInfrastructure resources by resource group
list_by_subscription	SELECT	subscriptionId	List CloudExadataInfrastructure resources by subscription ID
create_or_update	INSERT	cloudexadatainfrastructurename, resourceGroupName, subscriptionId, data__zones	Create a CloudExadataInfrastructure
delete	DELETE	cloudexadatainfrastructurename, resourceGroupName, subscriptionId	Delete a CloudExadataInfrastructure
update	UPDATE	cloudexadatainfrastructurename, resourceGroupName, subscriptionId	Update a CloudExadataInfrastructure
add_storage_capacity	EXEC	cloudexadatainfrastructurename, resourceGroupName, subscriptionId	Perform add storage capacity on exadata infra

SELECT examples

List CloudExadataInfrastructure resources by subscription ID

vw_cloud_exadata_infrastructures

SELECT
activated_storage_count,
additional_storage_count,
available_storage_size_in_gbs,
cloudexadatainfrastructurename,
compute_count,
cpu_count,
customer_contacts,
data_storage_size_in_tbs,
db_node_storage_size_in_gbs,
db_server_version,
display_name,
estimated_patching_time,
last_maintenance_run_id,
lifecycle_details,
lifecycle_state,
location,
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_url,
ocid,
provisioning_state,
resourceGroupName,
shape,
storage_count,
storage_server_version,
subscriptionId,
tags,
time_created,
total_storage_size_in_gbs,
zones
FROM azure_isv.oracle.vw_cloud_exadata_infrastructures
WHERE subscriptionId = '{{ subscriptionId }}';

cloud_exadata_infrastructures

SELECT
location,
properties,
tags,
zones
FROM azure_isv.oracle.cloud_exadata_infrastructures
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new cloud_exadata_infrastructures resource.

All Properties

/*+ create */
INSERT INTO azure_isv.oracle.cloud_exadata_infrastructures (
cloudexadatainfrastructurename,
resourceGroupName,
subscriptionId,
data__zones,
properties,
zones,
tags,
location
)
SELECT 
'{{ cloudexadatainfrastructurename }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__zones }}',
'{{ properties }}',
'{{ zones }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: ocid
          value: []
        - name: computeCount
          value: integer
        - name: storageCount
          value: integer
        - name: totalStorageSizeInGbs
          value: integer
        - name: availableStorageSizeInGbs
          value: integer
        - name: timeCreated
          value: string
        - name: lifecycleDetails
          value: string
        - name: maintenanceWindow
          value:
            - name: preference
              value: []
            - name: months
              value:
                - - name: name
                    value: []
            - name: weeksOfMonth
              value:
                - integer
            - name: daysOfWeek
              value:
                - - name: name
                    value: []
            - name: hoursOfDay
              value:
                - integer
            - name: leadTimeInWeeks
              value: integer
            - name: patchingMode
              value: []
            - name: customActionTimeoutInMins
              value: integer
            - name: isCustomActionTimeoutEnabled
              value: boolean
            - name: isMonthlyPatchingEnabled
              value: boolean
        - name: estimatedPatchingTime
          value:
            - name: estimatedDbServerPatchingTime
              value: integer
            - name: estimatedNetworkSwitchesPatchingTime
              value: integer
            - name: estimatedStorageServerPatchingTime
              value: integer
            - name: totalEstimatedPatchingTime
              value: integer
        - name: customerContacts
          value:
            - - name: email
                value: string
        - name: provisioningState
          value: []
        - name: lifecycleState
          value: []
        - name: shape
          value: string
        - name: ociUrl
          value: string
        - name: cpuCount
          value: integer
        - name: maxCpuCount
          value: integer
        - name: memorySizeInGbs
          value: integer
        - name: maxMemoryInGbs
          value: integer
        - name: dbNodeStorageSizeInGbs
          value: integer
        - name: maxDbNodeStorageSizeInGbs
          value: integer
        - name: dataStorageSizeInTbs
          value: number
        - name: maxDataStorageInTbs
          value: number
        - name: dbServerVersion
          value: string
        - name: storageServerVersion
          value: string
        - name: activatedStorageCount
          value: integer
        - name: additionalStorageCount
          value: integer
        - name: displayName
          value: string
        - name: monthlyDbServerVersion
          value: string
        - name: monthlyStorageServerVersion
          value: string
    - name: zones
      value:
        - string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a cloud_exadata_infrastructures resource.

/*+ update */
UPDATE azure_isv.oracle.cloud_exadata_infrastructures
SET 
zones = '{{ zones }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified cloud_exadata_infrastructures resource.

/*+ delete */
DELETE FROM azure_isv.oracle.cloud_exadata_infrastructures
WHERE cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';