Skip to main content

cloud_exadata_infrastructures

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

Overview​

Namecloud_exadata_infrastructures
TypeResource
Idoci.database.cloud_exadata_infrastructures

Fields​

The following fields are returned by SELECT queries:

The cloud Exadata infrastructure details.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the cloud Exadata infrastructure resource.
activatedStorageCountintegerThe requested number of additional storage servers activated for the Exadata infrastructure.
additionalStorageCountintegerThe requested number of additional storage servers for the Exadata infrastructure.
availabilityDomainstringThe name of the availability domain that the cloud Exadata infrastructure resource is located in.
availableStorageSizeInGBsinteger (int32)The available storage can be allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).
clusterPlacementGroupIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the cluster placement group of the Exadata Infrastructure.
compartmentIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
computeCountinteger (int32)The number of compute servers for the cloud Exadata infrastructure.
computeModelstringThe compute model of the Base Database, Exadata Infrastructure, VM Cluster and Autonomous AI Database. (ECPU, OCPU) (x-default-description: Null used when unspecified.)
cpuCountintegerThe total number of CPU cores allocated.
customerContactsarrayThe 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.
dataStorageSizeInTBsnumber (double)Size, in terabytes, of the DATA disk group.
databaseServerTypestringThe database server type of the Exadata infrastructure. (x-default-description: null)
dbNodeStorageSizeInGBsintegerThe local node storage allocated in GBs.
dbServerVersionstringThe software version of the database servers (dom0) in the cloud Exadata infrastructure. Example: 20.1.15
definedFileSystemConfigurationsarrayDetails of the file system configuration of the Exadata infrastructure.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
displayNamestringThe user-friendly name for the cloud Exadata infrastructure resource. The name does not need to be unique.
exascaleConfigobjectThe exascale config response details for the Exadata Cloud@Customer infrastructure or cloud Exadata infrastructure . Applies to both Exadata Cloud@Customer instances and Exadata Cloud Service instances.
freeformTagsobjectFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
isSchedulingPolicyAssociatedbooleanIf true, the infrastructure is using granular maintenance scheduling preference.
lastMaintenanceRunIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the last maintenance run.
lifecycleDetailsstringAdditional information about the current lifecycle state.
lifecycleStatestringThe current lifecycle state of the cloud Exadata infrastructure resource. (PROVISIONING, AVAILABLE, UPDATING, TERMINATING, TERMINATED, FAILED, MAINTENANCE_IN_PROGRESS)
maintenanceVersionPreferencesobjectThe preferences for target versions of future maintenance runs. Currently these preferences are only supported for Monthly maintenance runs created via scheduling plans If no preferences are specified then the version will be set by default to "Latest". Changing preferences will not change versions for an already existing maintenance run.
maintenanceWindowobjectThe scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
maxCpuCountintegerThe total number of CPU cores available.
maxDataStorageInTBsnumber (double)The total available DATA disk group size.
maxDbNodeStorageInGBsintegerThe total local node storage available in GBs.
maxMemoryInGBsintegerThe total memory available in GBs.
memorySizeInGBsintegerThe memory allocated in GBs.
monthlyDbServerVersionstringThe monthly software version of the database servers (dom0) in the cloud Exadata infrastructure. Example: 20.1.15
monthlyStorageServerVersionstringThe monthly software version of the storage servers (cells) in the cloud Exadata infrastructure. Example: 20.1.15
nextMaintenanceRunIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the next maintenance run.
shapestringThe model name of the cloud Exadata infrastructure resource.
storageCountinteger (int32)The number of storage servers for the cloud Exadata infrastructure.
storageServerTypestringThe storage server type of the Exadata infrastructure. (x-default-description: null)
storageServerVersionstringThe software version of the storage servers (cells) in the cloud Exadata infrastructure. Example: 20.1.15
subscriptionIdstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the subscription with which resource needs to be associated with.
systemTagsobjectSystem tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
timeCreatedstring (date-time)The date and time the cloud Exadata infrastructure resource was created.
totalStorageSizeInGBsinteger (int32)The total storage allocated to the cloud Exadata infrastructure resource, in gigabytes (GB).

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectcloudExadataInfrastructureId, regionopc-request-idGets information about the specified cloud Exadata infrastructure resource. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />
listselectcompartmentId, regionlimit, page, opc-request-id, sortBy, sortOrder, lifecycleState, displayName, clusterPlacementGroupIdGets a list of the cloud Exadata infrastructure resources in the specified compartment. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />
createinsertregion, availabilityDomain, compartmentId, displayName, shapeopc-retry-token, opc-request-idCreates a cloud Exadata infrastructure resource. This resource is used to create either an [Exadata Cloud Service](/Content/Database/Concepts/exaoverview.htm) instance or an Autonomous AI Database on dedicated Exadata infrastructure.<br />
updateupdatecloudExadataInfrastructureId, regionif-match, opc-request-idUpdates the Cloud Exadata infrastructure resource. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />
deletedeletecloudExadataInfrastructureId, regionif-match, isDeleteVmClusters, opc-request-idDeletes the cloud Exadata infrastructure resource. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />
add_storage_capacity_cloud_exadata_infrastructureexeccloudExadataInfrastructureId, regionif-match, opc-request-id, opc-retry-tokenMakes the storage capacity from additional storage servers available for Cloud VM Cluster consumption. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />
change_compartmentexeccloudExadataInfrastructureId, region, compartmentIdopc-retry-token, opc-request-id, if-matchMoves a cloud Exadata infrastructure resource and its dependent resources to another compartment. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.For more information about moving resources to a different compartment, see [Moving Database Resources to a Different Compartment](/Content/Database/Concepts/databaseoverview.htm#moveRes).<br />
change_cloud_exadata_infrastructure_subscriptionexeccloudExadataInfrastructureId, regionopc-retry-token, opc-request-id, if-matchAssociate a cloud Exadata infrastructure with a different subscription.<br />
configure_exascale_cloud_exadata_infrastructureexeccloudExadataInfrastructureId, region, totalStorageInGBsif-match, opc-request-id, opc-retry-tokenConfigures Exascale on Cloud exadata infrastructure resource. Applies to Exadata Cloud Service instances only.<br />

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.

NameDatatypeDescription
cloudExadataInfrastructureIdstringThe cloud Exadata infrastructure [OCID](/Content/General/Concepts/identifiers.htm).
compartmentIdstringThe compartment [OCID](/Content/General/Concepts/identifiers.htm).
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
clusterPlacementGroupIdstringA filter to return only resources that match the given cluster placement group ID exactly.
displayNamestringA filter to return only resources that match the entire display name given. The match is not case sensitive.
if-matchstringFor optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
isDeleteVmClustersbooleanIf true, forces the deletion the specified cloud Exadata infrastructure resource as well as all associated VM clusters. If false, the cloud Exadata infrastructure resource can be deleted only if it has no associated VM clusters. Default value is false.
lifecycleStatestringA filter to return only resources that match the given lifecycle state exactly.
limitintegerThe maximum number of items to return per page.
opc-request-idstringUnique identifier for the request.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
pagestringThe pagination token to continue listing from.
sortBystringThe field to sort by. You can provide one sort order (sortOrder). Default order for TIMECREATED is descending. Default order for DISPLAYNAME is ascending. The DISPLAYNAME sort order is case sensitive.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples​

Gets information about the specified cloud Exadata infrastructure resource. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />

SELECT
id,
activatedStorageCount,
additionalStorageCount,
availabilityDomain,
availableStorageSizeInGBs,
clusterPlacementGroupId,
compartmentId,
computeCount,
computeModel,
cpuCount,
customerContacts,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
exascaleConfig,
freeformTags,
isSchedulingPolicyAssociated,
lastMaintenanceRunId,
lifecycleDetails,
lifecycleState,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
monthlyStorageServerVersion,
nextMaintenanceRunId,
shape,
storageCount,
storageServerType,
storageServerVersion,
subscriptionId,
systemTags,
timeCreated,
totalStorageSizeInGBs
FROM oci.database.cloud_exadata_infrastructures
WHERE cloudExadataInfrastructureId = '{{ cloudExadataInfrastructureId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

INSERT examples​

Creates a cloud Exadata infrastructure resource. This resource is used to create either an [Exadata Cloud Service](/Content/Database/Concepts/exaoverview.htm) instance or an Autonomous AI Database on dedicated Exadata infrastructure.<br />

INSERT INTO oci.database.cloud_exadata_infrastructures (
availabilityDomain,
clusterPlacementGroupId,
compartmentId,
computeCount,
customerContacts,
databaseServerType,
definedTags,
displayName,
freeformTags,
maintenanceVersionPreferences,
maintenanceWindow,
shape,
storageCount,
storageServerType,
subscriptionId,
region,
opc-retry-token,
opc-request-id
)
SELECT
'{{ availabilityDomain }}' /* required */,
'{{ clusterPlacementGroupId }}',
'{{ compartmentId }}' /* required */,
{{ computeCount }},
'{{ customerContacts }}',
'{{ databaseServerType }}',
'{{ definedTags }}',
'{{ displayName }}' /* required */,
'{{ freeformTags }}',
'{{ maintenanceVersionPreferences }}',
'{{ maintenanceWindow }}',
'{{ shape }}' /* required */,
{{ storageCount }},
'{{ storageServerType }}',
'{{ subscriptionId }}',
'{{ region }}',
'{{ opc-retry-token }}',
'{{ opc-request-id }}'
RETURNING
id,
activatedStorageCount,
additionalStorageCount,
availabilityDomain,
availableStorageSizeInGBs,
clusterPlacementGroupId,
compartmentId,
computeCount,
computeModel,
cpuCount,
customerContacts,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
exascaleConfig,
freeformTags,
isSchedulingPolicyAssociated,
lastMaintenanceRunId,
lifecycleDetails,
lifecycleState,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
monthlyStorageServerVersion,
nextMaintenanceRunId,
shape,
storageCount,
storageServerType,
storageServerVersion,
subscriptionId,
systemTags,
timeCreated,
totalStorageSizeInGBs
;

UPDATE examples​

Updates the Cloud Exadata infrastructure resource. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />

UPDATE oci.database.cloud_exadata_infrastructures
SET
computeCount = {{ computeCount }},
customerContacts = '{{ customerContacts }}',
definedTags = '{{ definedTags }}',
displayName = '{{ displayName }}',
freeformTags = '{{ freeformTags }}',
maintenanceVersionPreferences = '{{ maintenanceVersionPreferences }}',
maintenanceWindow = '{{ maintenanceWindow }}',
storageCount = {{ storageCount }}
WHERE
cloudExadataInfrastructureId = '{{ cloudExadataInfrastructureId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
AND opc-request-id = '{{ opc-request-id}}'
RETURNING
id,
activatedStorageCount,
additionalStorageCount,
availabilityDomain,
availableStorageSizeInGBs,
clusterPlacementGroupId,
compartmentId,
computeCount,
computeModel,
cpuCount,
customerContacts,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
exascaleConfig,
freeformTags,
isSchedulingPolicyAssociated,
lastMaintenanceRunId,
lifecycleDetails,
lifecycleState,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
monthlyStorageServerVersion,
nextMaintenanceRunId,
shape,
storageCount,
storageServerType,
storageServerVersion,
subscriptionId,
systemTags,
timeCreated,
totalStorageSizeInGBs;

DELETE examples​

Deletes the cloud Exadata infrastructure resource. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />

DELETE FROM oci.database.cloud_exadata_infrastructures
WHERE cloudExadataInfrastructureId = '{{ cloudExadataInfrastructureId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match }}'
AND isDeleteVmClusters = '{{ isDeleteVmClusters }}'
AND opc-request-id = '{{ opc-request-id }}'
;

Lifecycle Methods​

Makes the storage capacity from additional storage servers available for Cloud VM Cluster consumption. Applies to Exadata Cloud Service instances and Autonomous AI Database on dedicated Exadata infrastructure only.<br />

EXEC oci.database.cloud_exadata_infrastructures.add_storage_capacity_cloud_exadata_infrastructure
@cloudExadataInfrastructureId='{{ cloudExadataInfrastructureId }}' --required,
@region='{{ region }}' --required,
@if-match='{{ if-match }}',
@opc-request-id='{{ opc-request-id }}',
@opc-retry-token='{{ opc-retry-token }}'
;