gi_version_minor_versions
Creates, updates, deletes, gets or lists a gi_version_minor_versions resource.
Overview​
| Name | gi_version_minor_versions |
| Type | Resource |
| Id | oci.database.gi_version_minor_versions |
Fields​
The following fields are returned by SELECT queries:
- list
The Oracle Grid Infrastructure (GI) minor version.<br /><br />To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see [Getting Started with Policies](/Content/Identity/Concepts/policygetstarted.htm).<br />
| Name | Datatype | Description |
|---|---|---|
gridImageId | string | Grid Infrastructure Image Id |
version | string | A valid Oracle Grid Infrastructure (GI) software version. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | version, region | availabilityDomain, compartmentId, opc-request-id, shapeFamily, isGiVersionForProvisioning, shape, sortBy, sortOrder, limit, page | Gets a list of supported Oracle Grid Infrastructure minor versions for the given major version and shape family. |
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 |
|---|---|---|
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) |
version | string | The Oracle Grid Infrastructure major version. |
availabilityDomain | string | The target availability domain. Only passed if the limit is AD-specific. |
compartmentId | string | The compartment [OCID](/Content/General/Concepts/identifiers.htm). |
isGiVersionForProvisioning | boolean | If true, returns the Grid Infrastructure versions that can be used for provisioning a cluster |
limit | integer | The maximum number of items to return per page. |
opc-request-id | string | Unique identifier for the request. |
page | string | The pagination token to continue listing from. |
shape | string | If provided, filters the results for the given shape. |
shapeFamily | string | If provided, filters the results to the set of database versions which are supported for the given shape family. |
sortBy | string | Sort by VERSION. Default order for VERSION is descending. |
sortOrder | string | The sort order to use, either ascending (ASC) or descending (DESC). |
SELECT examples​
- list
Gets a list of supported Oracle Grid Infrastructure minor versions for the given major version and shape family.
SELECT
gridImageId,
version
FROM oci.database.gi_version_minor_versions
WHERE version = '{{ version }}' -- required
AND region = '{{ region }}' -- required
AND availabilityDomain = '{{ availabilityDomain }}'
AND compartmentId = '{{ compartmentId }}'
AND opc-request-id = '{{ opc-request-id }}'
AND shapeFamily = '{{ shapeFamily }}'
AND isGiVersionForProvisioning = '{{ isGiVersionForProvisioning }}'
AND shape = '{{ shape }}'
AND sortBy = '{{ sortBy }}'
AND sortOrder = '{{ sortOrder }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;