gi_versions

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

Overview

Name	gi_versions
Type	Resource
Id	oci.database.gi_versions

Fields

The following fields are returned by SELECT queries:

list

The Oracle Grid Infrastructure (GI) 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
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	compartmentId, region	limit, page, sortOrder, shape, availabilityDomain, shapeAttribute	Gets a list of supported GI versions.

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).
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)
availabilityDomain	string	The target availability domain. Only passed if the limit is AD-specific.
limit	integer	The maximum number of items to return per page.
page	string	The pagination token to continue listing from.
shape	string	If provided, filters the results for the given shape.
shapeAttribute	string	If provided and applicable, return DB System shape parameters based on the shapeAttribute provided
sortOrder	string	The sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples

list

Gets a list of supported GI versions.

SELECT
version
FROM oci.database.gi_versions
WHERE compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND sortOrder = '{{ sortOrder }}'
AND shape = '{{ shape }}'
AND availabilityDomain = '{{ availabilityDomain }}'
AND shapeAttribute = '{{ shapeAttribute }}'
;