cloud_exadata_infrastructures

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

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Id	azure_isv.oracledatabase.cloud_exadata_infrastructures

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
activatedStorageCount	integer	The requested number of additional storage servers activated for the Exadata infrastructure.
additionalStorageCount	integer	The requested number of additional storage servers for the Exadata infrastructure.
availableStorageSizeInGbs	integer	The available storage can be allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
computeCount	integer	The number of compute servers for the cloud Exadata infrastructure.
computeModel	string	The compute model of the Exadata Infrastructure. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
cpuCount	integer	The total number of CPU cores allocated.
customerContacts	array	The list of customer email addresses that receive information from Oracle about the specified OCI Database service resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a cloud Exadata infrastructure instance.
dataStorageSizeInTbs	number	The quantity of data in the database, in terabytes.
databaseServerType	string	The database server model type of the cloud Exadata infrastructure resource.
dbNodeStorageSizeInGbs	integer	The local node storage to be allocated in GBs.
dbServerVersion	string	The software version of the database servers (dom0) in the Exadata infrastructure.
definedFileSystemConfiguration	array	Defined file system configurations.
displayName	string	The name for the Exadata infrastructure. Required.
estimatedPatchingTime	object	The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
exascaleConfig	object	The exascale config details for the cloud Exadata infrastructure.
lastMaintenanceRunId	string	The OCID of the last maintenance run.
lifecycleDetails	string	Additional information about the current lifecycle state.
lifecycleState	string	CloudExadataInfrastructure lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", "MaintenanceInProgress", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, MaintenanceInProgress, Failed)
location	string	The geo-location where the resource lives. Required.
maintenanceWindow	object	maintenanceWindow property.
maxCpuCount	integer	The total number of CPU cores available.
maxDataStorageInTbs	number	The total available DATA disk group size.
maxDbNodeStorageSizeInGbs	integer	The total local node storage available in GBs.
maxMemoryInGbs	integer	The total memory available in GBs.
memorySizeInGbs	integer	The memory allocated in GBs.
monthlyDbServerVersion	string	Monthly Db Server version.
monthlyStorageServerVersion	string	Monthly Storage Server version.
nextMaintenanceRunId	string	The OCID of the next maintenance run.
ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocid	string	Exadata infra ocid.
provisioningState	string	CloudExadataInfrastructure provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
shape	string	The model name of the cloud Exadata infrastructure resource. Required.
storageCount	integer	The number of storage servers for the cloud Exadata infrastructure.
storageServerType	string	The storage server model type of the cloud Exadata infrastructure resource.
storageServerVersion	string	The software version of the storage servers (cells) in the Exadata infrastructure.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
timeCreated	string	The date and time the cloud Exadata infrastructure resource was created.
totalStorageSizeInGbs	integer	The total storage allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
zones	array	CloudExadataInfrastructure zones. Required.

list_by_resource_group

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
activatedStorageCount	integer	The requested number of additional storage servers activated for the Exadata infrastructure.
additionalStorageCount	integer	The requested number of additional storage servers for the Exadata infrastructure.
availableStorageSizeInGbs	integer	The available storage can be allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
computeCount	integer	The number of compute servers for the cloud Exadata infrastructure.
computeModel	string	The compute model of the Exadata Infrastructure. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
cpuCount	integer	The total number of CPU cores allocated.
customerContacts	array	The list of customer email addresses that receive information from Oracle about the specified OCI Database service resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a cloud Exadata infrastructure instance.
dataStorageSizeInTbs	number	The quantity of data in the database, in terabytes.
databaseServerType	string	The database server model type of the cloud Exadata infrastructure resource.
dbNodeStorageSizeInGbs	integer	The local node storage to be allocated in GBs.
dbServerVersion	string	The software version of the database servers (dom0) in the Exadata infrastructure.
definedFileSystemConfiguration	array	Defined file system configurations.
displayName	string	The name for the Exadata infrastructure. Required.
estimatedPatchingTime	object	The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
exascaleConfig	object	The exascale config details for the cloud Exadata infrastructure.
lastMaintenanceRunId	string	The OCID of the last maintenance run.
lifecycleDetails	string	Additional information about the current lifecycle state.
lifecycleState	string	CloudExadataInfrastructure lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", "MaintenanceInProgress", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, MaintenanceInProgress, Failed)
location	string	The geo-location where the resource lives. Required.
maintenanceWindow	object	maintenanceWindow property.
maxCpuCount	integer	The total number of CPU cores available.
maxDataStorageInTbs	number	The total available DATA disk group size.
maxDbNodeStorageSizeInGbs	integer	The total local node storage available in GBs.
maxMemoryInGbs	integer	The total memory available in GBs.
memorySizeInGbs	integer	The memory allocated in GBs.
monthlyDbServerVersion	string	Monthly Db Server version.
monthlyStorageServerVersion	string	Monthly Storage Server version.
nextMaintenanceRunId	string	The OCID of the next maintenance run.
ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocid	string	Exadata infra ocid.
provisioningState	string	CloudExadataInfrastructure provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
shape	string	The model name of the cloud Exadata infrastructure resource. Required.
storageCount	integer	The number of storage servers for the cloud Exadata infrastructure.
storageServerType	string	The storage server model type of the cloud Exadata infrastructure resource.
storageServerVersion	string	The software version of the storage servers (cells) in the Exadata infrastructure.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
timeCreated	string	The date and time the cloud Exadata infrastructure resource was created.
totalStorageSizeInGbs	integer	The total storage allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
zones	array	CloudExadataInfrastructure zones. Required.

list_by_subscription

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
activatedStorageCount	integer	The requested number of additional storage servers activated for the Exadata infrastructure.
additionalStorageCount	integer	The requested number of additional storage servers for the Exadata infrastructure.
availableStorageSizeInGbs	integer	The available storage can be allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
computeCount	integer	The number of compute servers for the cloud Exadata infrastructure.
computeModel	string	The compute model of the Exadata Infrastructure. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
cpuCount	integer	The total number of CPU cores allocated.
customerContacts	array	The list of customer email addresses that receive information from Oracle about the specified OCI Database service resource. Oracle uses these email addresses to send notifications about planned and unplanned software maintenance updates, information about system hardware, and other information needed by administrators. Up to 10 email addresses can be added to the customer contacts for a cloud Exadata infrastructure instance.
dataStorageSizeInTbs	number	The quantity of data in the database, in terabytes.
databaseServerType	string	The database server model type of the cloud Exadata infrastructure resource.
dbNodeStorageSizeInGbs	integer	The local node storage to be allocated in GBs.
dbServerVersion	string	The software version of the database servers (dom0) in the Exadata infrastructure.
definedFileSystemConfiguration	array	Defined file system configurations.
displayName	string	The name for the Exadata infrastructure. Required.
estimatedPatchingTime	object	The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
exascaleConfig	object	The exascale config details for the cloud Exadata infrastructure.
lastMaintenanceRunId	string	The OCID of the last maintenance run.
lifecycleDetails	string	Additional information about the current lifecycle state.
lifecycleState	string	CloudExadataInfrastructure lifecycle state. Known values are: "Provisioning", "Available", "Updating", "Terminating", "Terminated", "MaintenanceInProgress", and "Failed". (Provisioning, Available, Updating, Terminating, Terminated, MaintenanceInProgress, Failed)
location	string	The geo-location where the resource lives. Required.
maintenanceWindow	object	maintenanceWindow property.
maxCpuCount	integer	The total number of CPU cores available.
maxDataStorageInTbs	number	The total available DATA disk group size.
maxDbNodeStorageSizeInGbs	integer	The total local node storage available in GBs.
maxMemoryInGbs	integer	The total memory available in GBs.
memorySizeInGbs	integer	The memory allocated in GBs.
monthlyDbServerVersion	string	Monthly Db Server version.
monthlyStorageServerVersion	string	Monthly Storage Server version.
nextMaintenanceRunId	string	The OCID of the next maintenance run.
ociUrl	string	HTTPS link to OCI resources exposed to Azure Customer via Azure Interface.
ocid	string	Exadata infra ocid.
provisioningState	string	CloudExadataInfrastructure provisioning state. Known values are: "Succeeded", "Failed", "Canceled", and "Provisioning". (Succeeded, Failed, Canceled, Provisioning)
shape	string	The model name of the cloud Exadata infrastructure resource. Required.
storageCount	integer	The number of storage servers for the cloud Exadata infrastructure.
storageServerType	string	The storage server model type of the cloud Exadata infrastructure resource.
storageServerVersion	string	The software version of the storage servers (cells) in the Exadata infrastructure.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
tags	object	Resource tags.
timeCreated	string	The date and time the cloud Exadata infrastructure resource was created.
totalStorageSizeInGbs	integer	The total storage allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
zones	array	CloudExadataInfrastructure zones. Required.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, cloudexadatainfrastructurename, subscription_id		Get a CloudExadataInfrastructure.
list_by_resource_group	select	resource_group_name, subscription_id		List CloudExadataInfrastructure resources by resource group.
list_by_subscription	select	subscription_id		List CloudExadataInfrastructure resources by subscription ID.
create_or_update	insert	resource_group_name, cloudexadatainfrastructurename, subscription_id, location, zones		Create a CloudExadataInfrastructure.
update	update	resource_group_name, cloudexadatainfrastructurename, subscription_id		Update a CloudExadataInfrastructure.
create_or_update	replace	resource_group_name, cloudexadatainfrastructurename, subscription_id, location, zones		Create a CloudExadataInfrastructure.
delete	delete	resource_group_name, cloudexadatainfrastructurename, subscription_id		Delete a CloudExadataInfrastructure.
add_storage_capacity	exec	resource_group_name, cloudexadatainfrastructurename, subscription_id		Perform add storage capacity on exadata infra.
configure_exascale	exec	resource_group_name, cloudexadatainfrastructurename, subscription_id, totalStorageInGbs		Configures Exascale on Cloud exadata infrastructure resource.

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
cloudexadatainfrastructurename	string	CloudExadataInfrastructure name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string

SELECT examples

get

Get a CloudExadataInfrastructure.

SELECT
id,
name,
activatedStorageCount,
additionalStorageCount,
availableStorageSizeInGbs,
computeCount,
computeModel,
cpuCount,
customerContacts,
dataStorageSizeInTbs,
databaseServerType,
dbNodeStorageSizeInGbs,
dbServerVersion,
definedFileSystemConfiguration,
displayName,
estimatedPatchingTime,
exascaleConfig,
lastMaintenanceRunId,
lifecycleDetails,
lifecycleState,
location,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTbs,
maxDbNodeStorageSizeInGbs,
maxMemoryInGbs,
memorySizeInGbs,
monthlyDbServerVersion,
monthlyStorageServerVersion,
nextMaintenanceRunId,
ociUrl,
ocid,
provisioningState,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemData,
tags,
timeCreated,
totalStorageSizeInGbs,
type,
zones
FROM azure_isv.oracledatabase.cloud_exadata_infrastructures
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_resource_group

List CloudExadataInfrastructure resources by resource group.

SELECT
id,
name,
activatedStorageCount,
additionalStorageCount,
availableStorageSizeInGbs,
computeCount,
computeModel,
cpuCount,
customerContacts,
dataStorageSizeInTbs,
databaseServerType,
dbNodeStorageSizeInGbs,
dbServerVersion,
definedFileSystemConfiguration,
displayName,
estimatedPatchingTime,
exascaleConfig,
lastMaintenanceRunId,
lifecycleDetails,
lifecycleState,
location,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTbs,
maxDbNodeStorageSizeInGbs,
maxMemoryInGbs,
memorySizeInGbs,
monthlyDbServerVersion,
monthlyStorageServerVersion,
nextMaintenanceRunId,
ociUrl,
ocid,
provisioningState,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemData,
tags,
timeCreated,
totalStorageSizeInGbs,
type,
zones
FROM azure_isv.oracledatabase.cloud_exadata_infrastructures
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_subscription

List CloudExadataInfrastructure resources by subscription ID.

SELECT
id,
name,
activatedStorageCount,
additionalStorageCount,
availableStorageSizeInGbs,
computeCount,
computeModel,
cpuCount,
customerContacts,
dataStorageSizeInTbs,
databaseServerType,
dbNodeStorageSizeInGbs,
dbServerVersion,
definedFileSystemConfiguration,
displayName,
estimatedPatchingTime,
exascaleConfig,
lastMaintenanceRunId,
lifecycleDetails,
lifecycleState,
location,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTbs,
maxDbNodeStorageSizeInGbs,
maxMemoryInGbs,
memorySizeInGbs,
monthlyDbServerVersion,
monthlyStorageServerVersion,
nextMaintenanceRunId,
ociUrl,
ocid,
provisioningState,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemData,
tags,
timeCreated,
totalStorageSizeInGbs,
type,
zones
FROM azure_isv.oracledatabase.cloud_exadata_infrastructures
WHERE subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

create_or_update

Create a CloudExadataInfrastructure.

INSERT INTO azure_isv.oracledatabase.cloud_exadata_infrastructures (
tags,
location,
properties,
zones,
resource_group_name,
cloudexadatainfrastructurename,
subscription_id
)
SELECT 
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ zones }}' /* required */,
'{{ resource_group_name }}',
'{{ cloudexadatainfrastructurename }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type,
zones
;

Manifest

# Description fields are for documentation purposes
- name: cloud_exadata_infrastructures
props:
  - name: resource_group_name
    value: "{{ resource_group_name }}"
    description: Required parameter for the cloud_exadata_infrastructures resource.
  - name: cloudexadatainfrastructurename
    value: "{{ cloudexadatainfrastructurename }}"
    description: Required parameter for the cloud_exadata_infrastructures resource.
  - name: subscription_id
    value: "{{ subscription_id }}"
    description: Required parameter for the cloud_exadata_infrastructures resource.
  - name: tags
    value: "{{ tags }}"
    description: |
      Resource tags.
  - name: location
    value: "{{ location }}"
    description: |
      The geo-location where the resource lives. Required.
  - name: properties
    description: |
      The resource-specific properties for this resource.
    value:
      definedFileSystemConfiguration:
        - isBackupPartition: {{ isBackupPartition }}
          isResizable: {{ isResizable }}
          minSizeGb: {{ minSizeGb }}
          mountPoint: "{{ mountPoint }}"
      ocid: "{{ ocid }}"
      computeCount: {{ computeCount }}
      storageCount: {{ storageCount }}
      totalStorageSizeInGbs: {{ totalStorageSizeInGbs }}
      availableStorageSizeInGbs: {{ availableStorageSizeInGbs }}
      timeCreated: "{{ timeCreated }}"
      lifecycleDetails: "{{ lifecycleDetails }}"
      maintenanceWindow:
        preference: "{{ preference }}"
        months:
          - name: "{{ name }}"
        weeksOfMonth:
          - {{ weeksOfMonth }}
        daysOfWeek:
          - name: "{{ name }}"
        hoursOfDay:
          - {{ hoursOfDay }}
        leadTimeInWeeks: {{ leadTimeInWeeks }}
        patchingMode: "{{ patchingMode }}"
        customActionTimeoutInMins: {{ customActionTimeoutInMins }}
        isCustomActionTimeoutEnabled: {{ isCustomActionTimeoutEnabled }}
        isMonthlyPatchingEnabled: {{ isMonthlyPatchingEnabled }}
      estimatedPatchingTime:
        estimatedDbServerPatchingTime: {{ estimatedDbServerPatchingTime }}
        estimatedNetworkSwitchesPatchingTime: {{ estimatedNetworkSwitchesPatchingTime }}
        estimatedStorageServerPatchingTime: {{ estimatedStorageServerPatchingTime }}
        totalEstimatedPatchingTime: {{ totalEstimatedPatchingTime }}
      customerContacts:
        - email: "{{ email }}"
      provisioningState: "{{ provisioningState }}"
      lifecycleState: "{{ lifecycleState }}"
      shape: "{{ shape }}"
      ociUrl: "{{ ociUrl }}"
      cpuCount: {{ cpuCount }}
      maxCpuCount: {{ maxCpuCount }}
      memorySizeInGbs: {{ memorySizeInGbs }}
      maxMemoryInGbs: {{ maxMemoryInGbs }}
      dbNodeStorageSizeInGbs: {{ dbNodeStorageSizeInGbs }}
      maxDbNodeStorageSizeInGbs: {{ maxDbNodeStorageSizeInGbs }}
      dataStorageSizeInTbs: {{ dataStorageSizeInTbs }}
      maxDataStorageInTbs: {{ maxDataStorageInTbs }}
      dbServerVersion: "{{ dbServerVersion }}"
      storageServerVersion: "{{ storageServerVersion }}"
      activatedStorageCount: {{ activatedStorageCount }}
      additionalStorageCount: {{ additionalStorageCount }}
      displayName: "{{ displayName }}"
      lastMaintenanceRunId: "{{ lastMaintenanceRunId }}"
      nextMaintenanceRunId: "{{ nextMaintenanceRunId }}"
      monthlyDbServerVersion: "{{ monthlyDbServerVersion }}"
      monthlyStorageServerVersion: "{{ monthlyStorageServerVersion }}"
      databaseServerType: "{{ databaseServerType }}"
      storageServerType: "{{ storageServerType }}"
      computeModel: "{{ computeModel }}"
      exascaleConfig:
        totalStorageInGbs: {{ totalStorageInGbs }}
        availableStorageInGbs: {{ availableStorageInGbs }}
  - name: zones
    value:
      - "{{ zones }}"
    description: |
      CloudExadataInfrastructure zones. Required.

UPDATE examples

update

Update a CloudExadataInfrastructure.

UPDATE azure_isv.oracledatabase.cloud_exadata_infrastructures
SET 
zones = '{{ zones }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type,
zones;

REPLACE examples

create_or_update

Create a CloudExadataInfrastructure.

REPLACE azure_isv.oracledatabase.cloud_exadata_infrastructures
SET 
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}',
zones = '{{ zones }}'
WHERE 
resource_group_name = '{{ resource_group_name }}' --required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
AND zones = '{{ zones }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type,
zones;

DELETE examples

delete

Delete a CloudExadataInfrastructure.

DELETE FROM azure_isv.oracledatabase.cloud_exadata_infrastructures
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND cloudexadatainfrastructurename = '{{ cloudexadatainfrastructurename }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

add_storage_capacity

Perform add storage capacity on exadata infra.

EXEC azure_isv.oracledatabase.cloud_exadata_infrastructures.add_storage_capacity 
@resource_group_name='{{ resource_group_name }}' --required, 
@cloudexadatainfrastructurename='{{ cloudexadatainfrastructurename }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;

configure_exascale

Configures Exascale on Cloud exadata infrastructure resource.

EXEC azure_isv.oracledatabase.cloud_exadata_infrastructures.configure_exascale 
@resource_group_name='{{ resource_group_name }}' --required, 
@cloudexadatainfrastructurename='{{ cloudexadatainfrastructurename }}' --required, 
@subscription_id='{{ subscription_id }}' --required 
@@json=
'{
"totalStorageInGbs": {{ totalStorageInGbs }}
}'
;