vm_cluster_patches

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

Overview

Name	vm_cluster_patches
Type	Resource
Id	oci.database.vm_cluster_patches

Fields

The following fields are returned by SELECT queries:

get

The patch package.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch.
availableActions	array	Actions that can possibly be performed using this patch.
description	string	The text describing this patch package.
lastAction	string	Action that is currently being performed or was completed last. (APPLY, PRECHECK)
lifecycleDetails	string	A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
lifecycleState	string	The current state of the patch as a result of lastAction. (AVAILABLE, SUCCESS, IN_PROGRESS, FAILED)
timeReleased	string (date-time)	The date and time that the patch was released.
version	string	The version of this patch package.

list

A Patch for a DB system or DB Home.<br /><br />To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized,<br />talk to an administrator. If you're an administrator who needs to write policies to give users access,<br />see [Getting Started with Policies](/Content/Identity/Concepts/policygetstarted.htm).<br />

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch.
availableActions	array	Actions that can possibly be performed using this patch.
description	string	The text describing this patch package.
lastAction	string	Action that is currently being performed or was completed last. (APPLY, PRECHECK)
lifecycleDetails	string	A descriptive text associated with the lifecycleState. Typically can contain additional displayable text.
lifecycleState	string	The current state of the patch as a result of lastAction. (AVAILABLE, SUCCESS, IN_PROGRESS, FAILED)
timeReleased	string (date-time)	The date and time that the patch was released.
version	string	The version of this patch package.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	vmClusterId, patchId, region		Gets information about a specified patch package.<br />
list	select	vmClusterId, region	limit, page	Lists the patches applicable to the specified VM cluster in an Exadata Cloud@Customer system.<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
patchId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch.
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)
vmClusterId	string	The VM cluster [OCID](/Content/General/Concepts/identifiers.htm).
limit	integer	The maximum number of items to return per page.
page	string	The pagination token to continue listing from.

SELECT examples

get

Gets information about a specified patch package.<br />

SELECT
id,
availableActions,
description,
lastAction,
lifecycleDetails,
lifecycleState,
timeReleased,
version
FROM oci.database.vm_cluster_patches
WHERE vmClusterId = '{{ vmClusterId }}' -- required
AND patchId = '{{ patchId }}' -- required
AND region = '{{ region }}' -- required
;

list

Lists the patches applicable to the specified VM cluster in an Exadata Cloud@Customer system.<br />

SELECT
id,
availableActions,
description,
lastAction,
lifecycleDetails,
lifecycleState,
timeReleased,
version
FROM oci.database.vm_cluster_patches
WHERE vmClusterId = '{{ vmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;