cloud_exadata_infrastructures

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

Overview

Name	cloud_exadata_infrastructures
Type	Resource
Id	google.oracledatabase.cloud_exadata_infrastructures

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
name	string	Identifier. The name of the Exadata Infrastructure resource with the format: projects/{project}/locations/{region}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}
createTime	string (google-datetime)	Output only. The date and time that the Exadata Infrastructure was created.
displayName	string	Optional. User friendly name for this resource.
entitlementId	string	Output only. Entitlement ID of the private offer against which this infrastructure resource is provisioned.
gcpOracleZone	string	Optional. The GCP Oracle zone where Oracle Exadata Infrastructure is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
labels	object	Optional. Labels or tags associated with the resource.
properties	object	Optional. Various properties of the infra. (id: CloudExadataInfrastructureProperties)

list

Name	Datatype	Description

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	projectsId, locationsId, cloudExadataInfrastructuresId		Gets details of a single Exadata Infrastructure.
list	select	projectsId, locationsId	pageSize, orderBy, pageToken, filter	Lists Exadata Infrastructures in a given project and location.
create	insert	projectsId, locationsId	requestId, cloudExadataInfrastructureId	Creates a new Exadata Infrastructure in a given project and location.
delete	delete	projectsId, locationsId, cloudExadataInfrastructuresId	requestId, force	Deletes a single Exadata Infrastructure.
configure_exascale	exec	projectsId, locationsId, cloudExadataInfrastructuresId		Configures Exascale for a single 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
cloudExadataInfrastructuresId	string
locationsId	string
projectsId	string
cloudExadataInfrastructureId	string
filter	string
force	boolean
orderBy	string
pageSize	integer (int32)
pageToken	string
requestId	string

SELECT examples

get

Gets details of a single Exadata Infrastructure.

SELECT
name,
createTime,
displayName,
entitlementId,
gcpOracleZone,
labels,
properties
FROM google.oracledatabase.cloud_exadata_infrastructures
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND cloudExadataInfrastructuresId = '{{ cloudExadataInfrastructuresId }}' -- required
;

list

Lists Exadata Infrastructures in a given project and location.

SELECT
*
FROM google.oracledatabase.cloud_exadata_infrastructures
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND orderBy = '{{ orderBy }}'
AND pageToken = '{{ pageToken }}'
AND filter = '{{ filter }}'
;

INSERT examples

create

Creates a new Exadata Infrastructure in a given project and location.

INSERT INTO google.oracledatabase.cloud_exadata_infrastructures (
data__properties,
data__name,
data__gcpOracleZone,
data__labels,
data__displayName,
projectsId,
locationsId,
requestId,
cloudExadataInfrastructureId
)
SELECT 
'{{ properties }}',
'{{ name }}',
'{{ gcpOracleZone }}',
'{{ labels }}',
'{{ displayName }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ requestId }}',
'{{ cloudExadataInfrastructureId }}'
RETURNING
name,
done,
error,
metadata,
response
;

Manifest

# Description fields are for documentation purposes
- name: cloud_exadata_infrastructures
props:
  - name: projectsId
    value: "{{ projectsId }}"
    description: Required parameter for the cloud_exadata_infrastructures resource.
  - name: locationsId
    value: "{{ locationsId }}"
    description: Required parameter for the cloud_exadata_infrastructures resource.
  - name: properties
    description: |
      Optional. Various properties of the infra.
    value:
      monthlyStorageServerVersion: "{{ monthlyStorageServerVersion }}"
      ocid: "{{ ocid }}"
      availableStorageSizeGb: {{ availableStorageSizeGb }}
      exascaleConfig:
        totalStorageSizeGb: {{ totalStorageSizeGb }}
        availableStorageSizeGb: {{ availableStorageSizeGb }}
      additionalStorageCount: {{ additionalStorageCount }}
      computeModel: "{{ computeModel }}"
      totalStorageSizeGb: {{ totalStorageSizeGb }}
      maintenanceWindow:
        weeksOfMonth:
          - {{ weeksOfMonth }}
        hoursOfDay:
          - {{ hoursOfDay }}
        months:
          - "{{ months }}"
        customActionTimeoutMins: {{ customActionTimeoutMins }}
        leadTimeWeek: {{ leadTimeWeek }}
        daysOfWeek:
          - "{{ daysOfWeek }}"
        patchingMode: "{{ patchingMode }}"
        isCustomActionTimeoutEnabled: {{ isCustomActionTimeoutEnabled }}
        preference: "{{ preference }}"
      dbServerVersion: "{{ dbServerVersion }}"
      memorySizeGb: {{ memorySizeGb }}
      maxDbNodeStorageSizeGb: {{ maxDbNodeStorageSizeGb }}
      storageServerVersion: "{{ storageServerVersion }}"
      cpuCount: {{ cpuCount }}
      nextMaintenanceRunTime: "{{ nextMaintenanceRunTime }}"
      storageServerType: "{{ storageServerType }}"
      maxDataStorageTb: {{ maxDataStorageTb }}
      nextMaintenanceRunId: "{{ nextMaintenanceRunId }}"
      shape: "{{ shape }}"
      activatedStorageCount: {{ activatedStorageCount }}
      computeCount: {{ computeCount }}
      databaseServerType: "{{ databaseServerType }}"
      maxCpuCount: {{ maxCpuCount }}
      storageCount: {{ storageCount }}
      dbNodeStorageSizeGb: {{ dbNodeStorageSizeGb }}
      monthlyDbServerVersion: "{{ monthlyDbServerVersion }}"
      maxMemoryGb: {{ maxMemoryGb }}
      dataStorageSizeTb: {{ dataStorageSizeTb }}
      state: "{{ state }}"
      ociUrl: "{{ ociUrl }}"
      customerContacts:
        - email: "{{ email }}"
      nextSecurityMaintenanceRunTime: "{{ nextSecurityMaintenanceRunTime }}"
  - name: name
    value: "{{ name }}"
    description: |
      Identifier. The name of the Exadata Infrastructure resource with the format: projects/{project}/locations/{region}/cloudExadataInfrastructures/{cloud_exadata_infrastructure}
  - name: gcpOracleZone
    value: "{{ gcpOracleZone }}"
    description: |
      Optional. The GCP Oracle zone where Oracle Exadata Infrastructure is hosted. Example: us-east4-b-r2. If not specified, the system will pick a zone based on availability.
  - name: labels
    value: "{{ labels }}"
    description: |
      Optional. Labels or tags associated with the resource.
  - name: displayName
    value: "{{ displayName }}"
    description: |
      Optional. User friendly name for this resource.
  - name: requestId
    value: "{{ requestId }}"
  - name: cloudExadataInfrastructureId
    value: "{{ cloudExadataInfrastructureId }}"

DELETE examples

delete

Deletes a single Exadata Infrastructure.

DELETE FROM google.oracledatabase.cloud_exadata_infrastructures
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND cloudExadataInfrastructuresId = '{{ cloudExadataInfrastructuresId }}' --required
AND requestId = '{{ requestId }}'
AND force = '{{ force }}'
;

Lifecycle Methods

configure_exascale

Configures Exascale for a single Exadata Infrastructure.

EXEC google.oracledatabase.cloud_exadata_infrastructures.configure_exascale 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required, 
@cloudExadataInfrastructuresId='{{ cloudExadataInfrastructuresId }}' --required 
@@json=
'{
"totalStorageSizeGb": {{ totalStorageSizeGb }}, 
"requestId": "{{ requestId }}"
}'
;