container_database_patches

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

Overview

Name	container_database_patches
Type	Resource
Id	oci.database.container_database_patches

Fields

The following fields are returned by SELECT queries:

list

A patch for an Autonomous Exadata Infrastructure or Autonomous Container Database.<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.
autonomousPatchType	string	Maintenance run type, either "QUARTERLY" or "TIMEZONE". (QUARTERLY, TIMEZONE) (default: QUARTERLY)
description	string	The text describing this patch package.
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)
patchModel	string	Database patching model preference. See [My Oracle Support note 2285040.1](https:​//support.oracle.com/rs?type=doc&id=2285040.1) for information on the Release Update (RU) and Release Update Revision (RUR) patching models. (RELEASE_UPDATES, RELEASE_UPDATE_REVISIONS)
quarter	string	First month of the quarter in which the patch was released.
timeReleased	string (date-time)	The date and time that the patch was released.
type	string	The type of patch. BUNDLE is one example.
version	string	The version of this patch package.
year	string	Year in which the patch was released.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	autonomousContainerDatabaseId, compartmentId, region	limit, page, autonomousPatchType	Lists the patches applicable to the requested container database.<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
autonomousContainerDatabaseId	string	The Autonomous Container Database [OCID](/Content/General/Concepts/identifiers.htm).
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)
autonomousPatchType	string	Autonomous patch type, either "QUARTERLY" or "TIMEZONE".
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 patches applicable to the requested container database.<br />

SELECT
id,
autonomousPatchType,
description,
lifecycleDetails,
lifecycleState,
patchModel,
quarter,
timeReleased,
type,
version,
year
FROM oci.database.container_database_patches
WHERE autonomousContainerDatabaseId = '{{ autonomousContainerDatabaseId }}' -- required
AND compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND autonomousPatchType = '{{ autonomousPatchType }}'
;