exadata_infrastructures

Creates, updates, deletes, gets or lists an exadata_infrastructures resource.

Overview

Name	`exadata_infrastructures`
Type	Resource
Id	`oci.database.exadata_infrastructures`

Fields

The following fields are returned by SELECT queries:

get
list

The Exadata Cloud@Customer infrastructure details.

Name	Datatype	Description
`id`	`string`	The [OCID](/Content/General/Concepts/identifiers.htm) of the Exadata infrastructure.
`activatedStorageCount`	`integer`	The requested number of additional storage servers activated for the Exadata infrastructure.
`additionalComputeCount`	`integer`	The requested number of additional compute servers for the Exadata infrastructure.
`additionalComputeSystemModel`	`string`	Oracle Exadata System Model specification. The system model determines the amount of compute or storage server resources available for use. For more information, please see [System and Shape Configuration Options] (https://docs.oracle.com/en/engineered-systems/exadata-cloud-at-customer/ecccm/ecc-system-config-options.html#GUID-9E090174-5C57-4EB1-9243-B470F9F10D6B) (X7, X8, X8M, X9M, X11M)
`additionalStorageCount`	`integer`	The requested number of additional storage servers for the Exadata infrastructure.
`adminNetworkCIDR`	`string`	The CIDR block for the Exadata administration network.
`availabilityDomain`	`string`	The name of the availability domain that the Exadata infrastructure is located in.
`cloudControlPlaneServer1`	`string`	The IP address for the first control plane server.
`cloudControlPlaneServer2`	`string`	The IP address for the second control plane server.
`compartmentId`	`string`	The [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
`computeCount`	`integer`	The number of compute servers for the Exadata infrastructure.
`computeModel`	`string`	The compute model of the Base Database, Exadata Infrastructure, VM Cluster and Autonomous AI Database. (ECPU, OCPU) (x-default-description: Null used when unspecified.)
`contacts`	`array`	The list of contacts for the Exadata infrastructure.
`corporateProxy`	`string`	The corporate network proxy for access to the control plane network.
`cpusEnabled`	`integer`	The number of enabled CPU cores.
`csiNumber`	`string`	The CSI Number of the Exadata infrastructure.
`dataStorageSizeInTBs`	`number (double)`	Size, in terabytes, of the DATA disk group.
`databaseServerType`	`string`	The database server type of the Exadata infrastructure. (x-default-description: null)
`dbNodeStorageSizeInGBs`	`integer`	The local node storage allocated in GBs.
`dbServerVersion`	`string`	The software version of the database servers (dom0) in the Exadata infrastructure.
`definedFileSystemConfigurations`	`array`	Details of the file system configuration of the Exadata infrastructure.
`definedTags`	`object`	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
`displayName`	`string`	The user-friendly name for the Exadata Cloud@Customer infrastructure. The name does not need to be unique.
`dnsServer`	`array`	The list of DNS server IP addresses. Maximum of 3 allowed.
`freeformTags`	`object`	Free-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"}`
`gateway`	`string`	The gateway for the control plane network.
`infiniBandNetworkCIDR`	`string`	The CIDR block for the Exadata InfiniBand interconnect.
`isMultiRackDeployment`	`boolean`	Indicates if deployment is Multi-Rack or not.
`isSchedulingPolicyAssociated`	`boolean`	If true, the infrastructure is using granular maintenance scheduling preference.
`lifecycleDetails`	`string`	Additional information about the current lifecycle state.
`lifecycleState`	`string`	The current lifecycle state of the Exadata infrastructure. (CREATING, REQUIRES_ACTIVATION, ACTIVATING, ACTIVE, ACTIVATION_FAILED, FAILED, UPDATING, DELETING, DELETED, DISCONNECTED, MAINTENANCE_IN_PROGRESS, WAITING_FOR_CONNECTIVITY)
`maintenanceSLOStatus`	`string`	A field to capture ‘Maintenance SLO Status’ for the Exadata infrastructure with values ‘OK’, ‘DEGRADED’. Default is ‘OK’ when the infrastructure is provisioned. (OK, DEGRADED)
`maintenanceVersionPreferences`	`object`	The 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.
`maintenanceWindow`	`object`	The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
`maxCpuCount`	`integer`	The total number of CPU cores available.
`maxDataStorageInTBs`	`number (double)`	The total available DATA disk group size.
`maxDbNodeStorageInGBs`	`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`	The monthly software version of the database servers (dom0) in the Exadata infrastructure.
`multiRackConfigurationFile`	`string (byte)`	The base64 encoded Multi-Rack configuration json file.
`netmask`	`string`	The netmask for the control plane network.
`networkBondingModeDetails`	`object`	Details of bonding mode for Client and Backup and DR networks of an Exadata infrastructure.
`ntpServer`	`array`	The list of NTP server IP addresses. Maximum of 3 allowed.
`rackSerialNumber`	`string`	The serial number for the Exadata infrastructure.
`shape`	`string`	The shape of the Exadata infrastructure. The shape determines the amount of CPU, storage, and memory resources allocated to the instance.
`storageCount`	`integer`	The number of Exadata storage servers for the Exadata infrastructure.
`storageServerType`	`string`	The storage server type of the Exadata infrastructure. (x-default-description: null)
`storageServerVersion`	`string`	The software version of the storage servers (cells) in the Exadata infrastructure.
`systemTags`	`object`	System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
`timeCreated`	`string (date-time)`	The date and time the Exadata infrastructure was created.
`timeZone`	`string (x-obmcs-time-zone)`	The time zone of the Exadata infrastructure. For details, see [Exadata Infrastructure Time Zones](/Content/Database/References/timezones.htm).

Details of the Exadata Cloud@Customer infrastructure. Applies to Exadata Cloud@Customer instances only. See [CloudExadataInfrastructureSummary Reference](#/en/database/latest/datatypes/CloudExadataInfrastructureSummary) for details of the cloud Exadata infrastructure resource used by Exadata Cloud Service instances.

Name	Datatype	Description
`id`	`string`	The [OCID](/Content/General/Concepts/identifiers.htm) of the Exadata infrastructure.
`activatedStorageCount`	`integer`	The requested number of additional storage servers activated for the Exadata infrastructure.
`additionalComputeCount`	`integer`	The requested number of additional compute servers for the Exadata infrastructure.
`additionalComputeSystemModel`	`string`	Oracle Exadata System Model specification. The system model determines the amount of compute or storage server resources available for use. For more information, please see [System and Shape Configuration Options] (https://docs.oracle.com/en/engineered-systems/exadata-cloud-at-customer/ecccm/ecc-system-config-options.html#GUID-9E090174-5C57-4EB1-9243-B470F9F10D6B) (X7, X8, X8M, X9M, X11M)
`additionalStorageCount`	`integer`	The requested number of additional storage servers for the Exadata infrastructure.
`adminNetworkCIDR`	`string`	The CIDR block for the Exadata administration network.
`availabilityDomain`	`string`	The name of the availability domain that the Exadata infrastructure is located in.
`cloudControlPlaneServer1`	`string`	The IP address for the first control plane server.
`cloudControlPlaneServer2`	`string`	The IP address for the second control plane server.
`compartmentId`	`string`	The [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
`computeCount`	`integer`	The number of compute servers for the Exadata infrastructure.
`computeModel`	`string`	The compute model of the Base Database, Exadata Infrastructure, VM Cluster and Autonomous AI Database. (ECPU, OCPU) (x-default-description: Null used when unspecified.)
`contacts`	`array`	The list of contacts for the Exadata infrastructure.
`corporateProxy`	`string`	The corporate network proxy for access to the control plane network.
`cpusEnabled`	`integer`	The number of enabled CPU cores.
`csiNumber`	`string`	The CSI Number of the Exadata infrastructure.
`dataStorageSizeInTBs`	`number (double)`	Size, in terabytes, of the DATA disk group.
`databaseServerType`	`string`	The database server type of the Exadata infrastructure. (x-default-description: null)
`dbNodeStorageSizeInGBs`	`integer`	The local node storage allocated in GBs.
`dbServerVersion`	`string`	The software version of the database servers (dom0) in the Exadata infrastructure.
`definedFileSystemConfigurations`	`array`	Details of the file system configuration of the Exadata infrastructure.
`definedTags`	`object`	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
`displayName`	`string`	The user-friendly name for the Exadata Cloud@Customer infrastructure. The name does not need to be unique.
`dnsServer`	`array`	The list of DNS server IP addresses. Maximum of 3 allowed.
`freeformTags`	`object`	Free-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"}`
`gateway`	`string`	The gateway for the control plane network.
`infiniBandNetworkCIDR`	`string`	The CIDR block for the Exadata InfiniBand interconnect.
`isMultiRackDeployment`	`boolean`	Indicates if deployment is Multi-Rack or not.
`isSchedulingPolicyAssociated`	`boolean`	If true, the infrastructure is using granular maintenance scheduling preference.
`lifecycleDetails`	`string`	Additional information about the current lifecycle state.
`lifecycleState`	`string`	The current lifecycle state of the Exadata infrastructure. (CREATING, REQUIRES_ACTIVATION, ACTIVATING, ACTIVE, ACTIVATION_FAILED, FAILED, UPDATING, DELETING, DELETED, DISCONNECTED, MAINTENANCE_IN_PROGRESS, WAITING_FOR_CONNECTIVITY)
`maintenanceSLOStatus`	`string`	A field to capture ‘Maintenance SLO Status’ for the Exadata infrastructure with values ‘OK’, ‘DEGRADED’. Default is ‘OK’ when the infrastructure is provisioned. (OK, DEGRADED)
`maintenanceVersionPreferences`	`object`	The 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.
`maintenanceWindow`	`object`	The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
`maxCpuCount`	`integer`	The total number of CPU cores available.
`maxDataStorageInTBs`	`number (double)`	The total available DATA disk group size.
`maxDbNodeStorageInGBs`	`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`	The monthly software version of the database servers (dom0) in the Exadata infrastructure.
`multiRackConfigurationFile`	`string (byte)`	The base64 encoded Multi-Rack configuration json file.
`netmask`	`string`	The netmask for the control plane network.
`networkBondingModeDetails`	`object`	Details of bonding mode for Client and Backup and DR networks of an Exadata infrastructure.
`ntpServer`	`array`	The list of NTP server IP addresses. Maximum of 3 allowed.
`rackSerialNumber`	`string`	The serial number for the Exadata infrastructure.
`shape`	`string`	The shape of the Exadata infrastructure. The shape determines the amount of CPU, storage, and memory resources allocated to the instance.
`storageCount`	`integer`	The number of Exadata storage servers for the Exadata infrastructure.
`storageServerType`	`string`	The storage server type of the Exadata infrastructure. (x-default-description: null)
`storageServerVersion`	`string`	The software version of the storage servers (cells) in the Exadata infrastructure.
`systemTags`	`object`	System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
`timeCreated`	`string (date-time)`	The date and time the Exadata infrastructure was created.
`timeZone`	`string (x-obmcs-time-zone)`	The time zone of the Exadata infrastructure. For details, see [Exadata Infrastructure Time Zones](/Content/Database/References/timezones.htm).

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
`get`	`select`	`exadataInfrastructureId`, `region`	`opc-request-id`, `excludedFields`	Gets information about the specified Exadata infrastructure. Applies to Exadata Cloud@Customer instances only.<br />To get information on an Exadata Cloud Service infrastructure resource, use the [GetCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/GetCloudExadataInfrastructure) operation.<br />
`list`	`select`	`compartmentId`, `region`	`limit`, `page`, `opc-request-id`, `sortBy`, `sortOrder`, `lifecycleState`, `displayName`, `excludedFields`	Lists the Exadata infrastructure resources in the specified compartment. Applies to Exadata Cloud@Customer instances only.<br />To list the Exadata Cloud Service infrastructure resources in a compartment, use the [ListCloudExadataInfrastructures](#/en/database/latest/CloudExadataInfrastructure/ListCloudExadataInfrastructures) operation.<br />
`create`	`insert`	`region`, `compartmentId`, `displayName`, `shape`, `timeZone`, `cloudControlPlaneServer1`, `cloudControlPlaneServer2`, `netmask`, `gateway`, `adminNetworkCIDR`, `infiniBandNetworkCIDR`, `dnsServer`, `ntpServer`, `corporateProxy`	`opc-retry-token`, `opc-request-id`	Creates an Exadata infrastructure resource. Applies to Exadata Cloud@Customer instances only.<br />To create an Exadata Cloud Service infrastructure resource, use the [CreateCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/CreateCloudExadataInfrastructure) operation.<br />
`update`	`update`	`exadataInfrastructureId`, `region`	`if-match`, `opc-request-id`	Updates the Exadata infrastructure resource. Applies to Exadata Cloud@Customer instances only.<br />To update an Exadata Cloud Service infrastructure resource, use the [UpdateCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/UpdateCloudExadataInfrastructure) operation.<br />
`delete`	`delete`	`exadataInfrastructureId`, `region`	`if-match`, `opc-request-id`	Deletes the Exadata Cloud@Customer infrastructure.<br />
`activate_exadata_infrastructure`	`exec`	`exadataInfrastructureId`, `region`, `activationFile`	`opc-request-id`, `opc-retry-token`	Activates the specified Exadata infrastructure resource. Applies to Exadata Cloud@Customer instances only.<br />
`add_storage_capacity_exadata_infrastructure`	`exec`	`exadataInfrastructureId`, `region`	`if-match`, `opc-request-id`, `opc-retry-token`	Makes the storage capacity from additional storage servers available for VM Cluster consumption. Applies to Exadata Cloud@Customer instances only.<br />
`change_compartment`	`exec`	`exadataInfrastructureId`, `region`, `compartmentId`	`opc-retry-token`, `opc-request-id`, `if-match`	Moves an Exadata infrastructure resource and its dependent resources to another compartment. Applies to Exadata Cloud@Customer instances only.<br />To move an Exadata Cloud Service infrastructure resource to another compartment, use the [ChangeCloudExadataInfrastructureCompartment](#/en/database/latest/CloudExadataInfrastructure/ChangeCloudExadataInfrastructureCompartment) operation.<br />
`download_exadata_infrastructure_config_file`	`exec`	`exadataInfrastructureId`, `region`	`opc-request-id`, `opc-retry-token`	Downloads the configuration file for the specified Exadata Cloud@Customer infrastructure.<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.

Name	Datatype	Description
`compartmentId`	`string`	The compartment [OCID](/Content/General/Concepts/identifiers.htm).
`exadataInfrastructureId`	`string`	The Exadata infrastructure [OCID](/Content/General/Concepts/identifiers.htm).
`region`	`string`	OCI 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)
`displayName`	`string`	A filter to return only resources that match the entire display name given. The match is not case sensitive.
`excludedFields`	`array`	If provided, the specified fields will be excluded in the response.
`if-match`	`string`	For 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.
`lifecycleState`	`string`	A filter to return only resources that match the given lifecycle state exactly.
`limit`	`integer`	The maximum number of items to return per page.
`opc-request-id`	`string`	Unique identifier for the request.
`opc-retry-token`	`string`	A 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).
`page`	`string`	The pagination token to continue listing from.
`sortBy`	`string`	The 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.
`sortOrder`	`string`	The sort order to use, either ascending (`ASC`) or descending (`DESC`).

`SELECT` examples

get
list

Gets information about the specified Exadata infrastructure. Applies to Exadata Cloud@Customer instances only. To get information on an Exadata Cloud Service infrastructure resource, use the [GetCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/GetCloudExadataInfrastructure) operation.

SELECT
id,
activatedStorageCount,
additionalComputeCount,
additionalComputeSystemModel,
additionalStorageCount,
adminNetworkCIDR,
availabilityDomain,
cloudControlPlaneServer1,
cloudControlPlaneServer2,
compartmentId,
computeCount,
computeModel,
contacts,
corporateProxy,
cpusEnabled,
csiNumber,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
dnsServer,
freeformTags,
gateway,
infiniBandNetworkCIDR,
isMultiRackDeployment,
isSchedulingPolicyAssociated,
lifecycleDetails,
lifecycleState,
maintenanceSLOStatus,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
multiRackConfigurationFile,
netmask,
networkBondingModeDetails,
ntpServer,
rackSerialNumber,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemTags,
timeCreated,
timeZone
FROM oci.database.exadata_infrastructures
WHERE exadataInfrastructureId = '{{ exadataInfrastructureId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
AND excludedFields = '{{ excludedFields }}'
;

Lists the Exadata infrastructure resources in the specified compartment. Applies to Exadata Cloud@Customer instances only. To list the Exadata Cloud Service infrastructure resources in a compartment, use the [ListCloudExadataInfrastructures](#/en/database/latest/CloudExadataInfrastructure/ListCloudExadataInfrastructures) operation.

SELECT
id,
activatedStorageCount,
additionalComputeCount,
additionalComputeSystemModel,
additionalStorageCount,
adminNetworkCIDR,
availabilityDomain,
cloudControlPlaneServer1,
cloudControlPlaneServer2,
compartmentId,
computeCount,
computeModel,
contacts,
corporateProxy,
cpusEnabled,
csiNumber,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
dnsServer,
freeformTags,
gateway,
infiniBandNetworkCIDR,
isMultiRackDeployment,
isSchedulingPolicyAssociated,
lifecycleDetails,
lifecycleState,
maintenanceSLOStatus,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
multiRackConfigurationFile,
netmask,
networkBondingModeDetails,
ntpServer,
rackSerialNumber,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemTags,
timeCreated,
timeZone
FROM oci.database.exadata_infrastructures
WHERE compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
AND sortBy = '{{ sortBy }}'
AND sortOrder = '{{ sortOrder }}'
AND lifecycleState = '{{ lifecycleState }}'
AND displayName = '{{ displayName }}'
AND excludedFields = '{{ excludedFields }}'
;

`INSERT` examples

create
Manifest

Creates an Exadata infrastructure resource. Applies to Exadata Cloud@Customer instances only. To create an Exadata Cloud Service infrastructure resource, use the [CreateCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/CreateCloudExadataInfrastructure) operation.

INSERT INTO oci.database.exadata_infrastructures (
adminNetworkCIDR,
cloudControlPlaneServer1,
cloudControlPlaneServer2,
compartmentId,
computeCount,
contacts,
corporateProxy,
databaseServerType,
definedTags,
displayName,
dnsServer,
freeformTags,
gateway,
infiniBandNetworkCIDR,
isMultiRackDeployment,
maintenanceVersionPreferences,
maintenanceWindow,
multiRackConfigurationFile,
netmask,
networkBondingModeDetails,
ntpServer,
shape,
storageCount,
storageServerType,
timeZone,
region,
opc-retry-token,
opc-request-id
)
SELECT 
'{{ adminNetworkCIDR }}' /* required */,
'{{ cloudControlPlaneServer1 }}' /* required */,
'{{ cloudControlPlaneServer2 }}' /* required */,
'{{ compartmentId }}' /* required */,
{{ computeCount }},
'{{ contacts }}',
'{{ corporateProxy }}' /* required */,
'{{ databaseServerType }}',
'{{ definedTags }}',
'{{ displayName }}' /* required */,
'{{ dnsServer }}' /* required */,
'{{ freeformTags }}',
'{{ gateway }}' /* required */,
'{{ infiniBandNetworkCIDR }}' /* required */,
{{ isMultiRackDeployment }},
'{{ maintenanceVersionPreferences }}',
'{{ maintenanceWindow }}',
'{{ multiRackConfigurationFile }}',
'{{ netmask }}' /* required */,
'{{ networkBondingModeDetails }}',
'{{ ntpServer }}' /* required */,
'{{ shape }}' /* required */,
{{ storageCount }},
'{{ storageServerType }}',
'{{ timeZone }}' /* required */,
'{{ region }}',
'{{ opc-retry-token }}',
'{{ opc-request-id }}'
RETURNING
id,
activatedStorageCount,
additionalComputeCount,
additionalComputeSystemModel,
additionalStorageCount,
adminNetworkCIDR,
availabilityDomain,
cloudControlPlaneServer1,
cloudControlPlaneServer2,
compartmentId,
computeCount,
computeModel,
contacts,
corporateProxy,
cpusEnabled,
csiNumber,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
dnsServer,
freeformTags,
gateway,
infiniBandNetworkCIDR,
isMultiRackDeployment,
isSchedulingPolicyAssociated,
lifecycleDetails,
lifecycleState,
maintenanceSLOStatus,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
multiRackConfigurationFile,
netmask,
networkBondingModeDetails,
ntpServer,
rackSerialNumber,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemTags,
timeCreated,
timeZone
;

# Description fields are for documentation purposes
- name: exadata_infrastructures
props:
  - name: region
    value: "{{ region }}"
    description: Required parameter for the exadata_infrastructures resource.
  - name: adminNetworkCIDR
    value: "{{ adminNetworkCIDR }}"
    description: |
      The CIDR block for the Exadata administration network.
  - name: cloudControlPlaneServer1
    value: "{{ cloudControlPlaneServer1 }}"
    description: |
      The IP address for the first control plane server.
  - name: cloudControlPlaneServer2
    value: "{{ cloudControlPlaneServer2 }}"
    description: |
      The IP address for the second control plane server.
  - name: compartmentId
    value: "{{ compartmentId }}"
    description: |
      The [OCID](/Content/General/Concepts/identifiers.htm) of the compartment.
  - name: computeCount
    value: {{ computeCount }}
    description: |
      The number of compute servers for the Exadata infrastructure.
  - name: contacts
    description: |
      The list of contacts for the Exadata infrastructure.
    value:
      - email: "{{ email }}"
        isContactMosValidated: {{ isContactMosValidated }}
        isPrimary: {{ isPrimary }}
        name: "{{ name }}"
        phoneNumber: "{{ phoneNumber }}"
  - name: corporateProxy
    value: "{{ corporateProxy }}"
    description: |
      The corporate network proxy for access to the control plane network. Oracle recommends using an HTTPS proxy when possible
      for enhanced security.
  - name: databaseServerType
    value: "{{ databaseServerType }}"
    description: |
      The database server type of the Exadata infrastructure.
  - name: definedTags
    value: "{{ definedTags }}"
    description: |
      Defined tags for this resource. Each key is predefined and scoped to a namespace.
      For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
  - name: displayName
    value: "{{ displayName }}"
    description: |
      The user-friendly name for the Exadata infrastructure. The name does not need to be unique.
  - name: dnsServer
    value:
      - "{{ dnsServer }}"
    description: |
      The list of DNS server IP addresses. Maximum of 3 allowed.
  - name: freeformTags
    value: "{{ freeformTags }}"
    description: |
      Free-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"}`
  - name: gateway
    value: "{{ gateway }}"
    description: |
      The gateway for the control plane network.
  - name: infiniBandNetworkCIDR
    value: "{{ infiniBandNetworkCIDR }}"
    description: |
      The CIDR block for the Exadata InfiniBand interconnect.
  - name: isMultiRackDeployment
    value: {{ isMultiRackDeployment }}
    description: |
      Indicates if deployment is Multi-Rack or not.
  - name: maintenanceVersionPreferences
    description: |
      The 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.
    value:
      referenceResourceIdForImageUpdates: "{{ referenceResourceIdForImageUpdates }}"
  - name: maintenanceWindow
    description: |
      The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
    value:
      customActionTimeoutInMins: {{ customActionTimeoutInMins }}
      daysOfWeek:
        - name: "{{ name }}"
      hoursOfDay:
        - {{ hoursOfDay }}
      isCustomActionTimeoutEnabled: {{ isCustomActionTimeoutEnabled }}
      leadTimeInWeeks: {{ leadTimeInWeeks }}
      months:
        - name: "{{ name }}"
      patchingMode: "{{ patchingMode }}"
      preference: "{{ preference }}"
      skipRu:
        - {{ skipRu }}
      weeksOfMonth:
        - {{ weeksOfMonth }}
  - name: multiRackConfigurationFile
    value: "{{ multiRackConfigurationFile }}"
    description: |
      The base64 encoded Multi-Rack configuration json file.
  - name: netmask
    value: "{{ netmask }}"
    description: |
      The netmask for the control plane network.
  - name: networkBondingModeDetails
    description: |
      Details of bonding mode for Client and Backup and DR networks of an Exadata infrastructure.
    value:
      backupNetworkBondingMode: "{{ backupNetworkBondingMode }}"
      clientNetworkBondingMode: "{{ clientNetworkBondingMode }}"
      drNetworkBondingMode: "{{ drNetworkBondingMode }}"
  - name: ntpServer
    value:
      - "{{ ntpServer }}"
    description: |
      The list of NTP server IP addresses. Maximum of 3 allowed.
  - name: shape
    value: "{{ shape }}"
    description: |
      The shape of the Exadata infrastructure. The shape determines the amount of CPU, storage, and memory resources allocated to the instance.
  - name: storageCount
    value: {{ storageCount }}
    description: |
      The number of storage servers for the Exadata infrastructure.
  - name: storageServerType
    value: "{{ storageServerType }}"
    description: |
      The storage server type of the Exadata infrastructure.
  - name: timeZone
    value: "{{ timeZone }}"
    description: |
      The time zone of the Exadata infrastructure. For details, see [Exadata Infrastructure Time Zones](/Content/Database/References/timezones.htm).
  - name: opc-retry-token
    value: "{{ opc-retry-token }}"
    description: A 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). 
    description: A 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). 
  - name: opc-request-id
    value: "{{ opc-request-id }}"
    description: Unique identifier for the request. 
    description: Unique identifier for the request. 

`UPDATE` examples

update

Updates the Exadata infrastructure resource. Applies to Exadata Cloud@Customer instances only. To update an Exadata Cloud Service infrastructure resource, use the [UpdateCloudExadataInfrastructure](#/en/database/latest/CloudExadataInfrastructure/UpdateCloudExadataInfrastructure) operation.

UPDATE oci.database.exadata_infrastructures
SET 
additionalComputeCount = {{ additionalComputeCount }},
additionalComputeSystemModel = '{{ additionalComputeSystemModel }}',
additionalStorageCount = {{ additionalStorageCount }},
adminNetworkCIDR = '{{ adminNetworkCIDR }}',
cloudControlPlaneServer1 = '{{ cloudControlPlaneServer1 }}',
cloudControlPlaneServer2 = '{{ cloudControlPlaneServer2 }}',
contacts = '{{ contacts }}',
corporateProxy = '{{ corporateProxy }}',
definedTags = '{{ definedTags }}',
dnsServer = '{{ dnsServer }}',
freeformTags = '{{ freeformTags }}',
gateway = '{{ gateway }}',
infiniBandNetworkCIDR = '{{ infiniBandNetworkCIDR }}',
isMultiRackDeployment = {{ isMultiRackDeployment }},
maintenanceVersionPreferences = '{{ maintenanceVersionPreferences }}',
maintenanceWindow = '{{ maintenanceWindow }}',
multiRackConfigurationFile = '{{ multiRackConfigurationFile }}',
netmask = '{{ netmask }}',
networkBondingModeDetails = '{{ networkBondingModeDetails }}',
ntpServer = '{{ ntpServer }}',
timeZone = '{{ timeZone }}'
WHERE 
exadataInfrastructureId = '{{ exadataInfrastructureId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
AND opc-request-id = '{{ opc-request-id}}'
RETURNING
id,
activatedStorageCount,
additionalComputeCount,
additionalComputeSystemModel,
additionalStorageCount,
adminNetworkCIDR,
availabilityDomain,
cloudControlPlaneServer1,
cloudControlPlaneServer2,
compartmentId,
computeCount,
computeModel,
contacts,
corporateProxy,
cpusEnabled,
csiNumber,
dataStorageSizeInTBs,
databaseServerType,
dbNodeStorageSizeInGBs,
dbServerVersion,
definedFileSystemConfigurations,
definedTags,
displayName,
dnsServer,
freeformTags,
gateway,
infiniBandNetworkCIDR,
isMultiRackDeployment,
isSchedulingPolicyAssociated,
lifecycleDetails,
lifecycleState,
maintenanceSLOStatus,
maintenanceVersionPreferences,
maintenanceWindow,
maxCpuCount,
maxDataStorageInTBs,
maxDbNodeStorageInGBs,
maxMemoryInGBs,
memorySizeInGBs,
monthlyDbServerVersion,
multiRackConfigurationFile,
netmask,
networkBondingModeDetails,
ntpServer,
rackSerialNumber,
shape,
storageCount,
storageServerType,
storageServerVersion,
systemTags,
timeCreated,
timeZone;

`DELETE` examples

delete

Deletes the Exadata Cloud@Customer infrastructure.

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

Lifecycle Methods

activate_exadata_infrastructure
add_storage_capacity_exadata_infrastructure
change_compartment
download_exadata_infrastructure_config_file

Activates the specified Exadata infrastructure resource. Applies to Exadata Cloud@Customer instances only.

EXEC oci.database.exadata_infrastructures.activate_exadata_infrastructure 
@exadataInfrastructureId='{{ exadataInfrastructureId }}' --required, 
@region='{{ region }}' --required, 
@opc-request-id='{{ opc-request-id }}', 
@opc-retry-token='{{ opc-retry-token }}' 
@@json=
'{
"activationFile": "{{ activationFile }}"
}'
;

Makes the storage capacity from additional storage servers available for VM Cluster consumption. Applies to Exadata Cloud@Customer instances only.

EXEC oci.database.exadata_infrastructures.add_storage_capacity_exadata_infrastructure 
@exadataInfrastructureId='{{ exadataInfrastructureId }}' --required, 
@region='{{ region }}' --required, 
@if-match='{{ if-match }}', 
@opc-request-id='{{ opc-request-id }}', 
@opc-retry-token='{{ opc-retry-token }}'
;

Moves an Exadata infrastructure resource and its dependent resources to another compartment. Applies to Exadata Cloud@Customer instances only. To move an Exadata Cloud Service infrastructure resource to another compartment, use the [ChangeCloudExadataInfrastructureCompartment](#/en/database/latest/CloudExadataInfrastructure/ChangeCloudExadataInfrastructureCompartment) operation.

EXEC oci.database.exadata_infrastructures.change_compartment 
@exadataInfrastructureId='{{ exadataInfrastructureId }}' --required, 
@region='{{ region }}' --required, 
@opc-retry-token='{{ opc-retry-token }}', 
@opc-request-id='{{ opc-request-id }}', 
@if-match='{{ if-match }}' 
@@json=
'{
"compartmentId": "{{ compartmentId }}"
}'
;

Downloads the configuration file for the specified Exadata Cloud@Customer infrastructure.

EXEC oci.database.exadata_infrastructures.download_exadata_infrastructure_config_file 
@exadataInfrastructureId='{{ exadataInfrastructureId }}' --required, 
@region='{{ region }}' --required, 
@opc-request-id='{{ opc-request-id }}', 
@opc-retry-token='{{ opc-retry-token }}'
;

Overview​

Fields​

Methods​

Parameters​

SELECT examples​

INSERT examples​

UPDATE examples​

DELETE examples​

Lifecycle Methods​