db_system_upgrades

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

Overview

Name	db_system_upgrades
Type	Resource
Id	oci.database.db_system_upgrades

Fields

The following fields are returned by SELECT queries:

list

It describes the various upgrade properties such as component, osversion, giversion for any VM DB system.<br />

Name	Datatype	Description
component	string	The component on which upgrade is applicable. OS (Operating System upgrade), GI (Grid Infrastructure upgrade) or OS_GI (both Operating System and Grid Infrastructure upgrade) (OS, OS_GI, GI)
giVersion	string	The version of the grid infrastructure for this upgrade. This is only applicable for ASM based DbSystems
osVersion	string	The version of the OS for this upgrade eg. Oracle Linux Server release 7.9

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	dbSystemId, region	limit, page	Lists the applicable upgrade components for a DB systems.<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
dbSystemId	string	The DB system [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)
limit	integer	The maximum number of items to return per page.
page	string	The pagination token to continue listing from.

SELECT examples

list

Lists the applicable upgrade components for a DB systems.<br />

SELECT
component,
giVersion,
osVersion
FROM oci.database.db_system_upgrades
WHERE dbSystemId = '{{ dbSystemId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;