autonomous_patches
Creates, updates, deletes, gets or lists an autonomous_patches resource.
Overview​
| Name | autonomous_patches |
| Type | Resource |
| Id | oci.database.autonomous_patches |
Fields​
The following fields are returned by SELECT queries:
- get
The autonomous patch details.
| 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 |
|---|---|---|---|---|
get | select | autonomousPatchId, region | Gets information about a specific autonomous patch. |
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 |
|---|---|---|
autonomousPatchId | string | The autonomous patch [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) |
SELECT examples​
- get
Gets information about a specific autonomous patch.
SELECT
id,
autonomousPatchType,
description,
lifecycleDetails,
lifecycleState,
patchModel,
quarter,
timeReleased,
type,
version,
year
FROM oci.database.autonomous_patches
WHERE autonomousPatchId = '{{ autonomousPatchId }}' -- required
AND region = '{{ region }}' -- required
;