db_versions
Creates, updates, deletes, gets or lists a db_versions resource.
Overview​
| Name | db_versions |
| Type | Resource |
| Id | oci.database.db_versions |
Fields​
The following fields are returned by SELECT queries:
- list
The Oracle Database software 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 |
|---|---|---|
isLatestForMajorVersion | boolean | True if this version of the Oracle Database software is the latest version for a release. |
isPreviewDbVersion | boolean | True if this version of the Oracle Database software is the preview version. |
isUpgradeSupported | boolean | True if this version of the Oracle Database software is supported for Upgrade. |
supportsPdb | boolean | True if this version of the Oracle Database software supports pluggable databases. |
version | string | A valid Oracle Database version. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | compartmentId, region | limit, page, dbSystemShape, dbSystemId, storageManagement, shapeAttribute, isUpgradeSupported, isDatabaseSoftwareImageSupported | Gets a list of supported Oracle Database 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) |
dbSystemId | string | The DB system [OCID](/Content/General/Concepts/identifiers.htm). If provided, filters the results to the set of database versions which are supported for the DB system. |
dbSystemShape | string | If provided, filters the results to the set of database versions which are supported for the given shape. |
isDatabaseSoftwareImageSupported | boolean | If true, filters the results to the set of Oracle Database versions that are supported for OCI database software images. |
isUpgradeSupported | boolean | If provided, filters the results to the set of database versions which are supported for Upgrade. |
limit | integer | The maximum number of items to return per page. |
page | string | The pagination token to continue listing from. |
shapeAttribute | string | If provided and applicable, return DB System shape parameters based on the shapeAttribute provided |
storageManagement | string | The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM. * ASM specifies Oracle Automatic Storage Management * LVM specifies logical volume manager, sometimes called logical disk manager. |
SELECT examples​
- list
Gets a list of supported Oracle Database versions.
SELECT
isLatestForMajorVersion,
isPreviewDbVersion,
isUpgradeSupported,
supportsPdb,
version
FROM oci.database.db_versions
WHERE compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND dbSystemShape = '{{ dbSystemShape }}'
AND dbSystemId = '{{ dbSystemId }}'
AND storageManagement = '{{ storageManagement }}'
AND shapeAttribute = '{{ shapeAttribute }}'
AND isUpgradeSupported = '{{ isUpgradeSupported }}'
AND isDatabaseSoftwareImageSupported = '{{ isDatabaseSoftwareImageSupported }}'
;