1. REST API for Oracle Database Exadata Cloud at Customer (Gen 1/OCI-C)
  2. Tasks
  3. Manage Patching

View Available Patches

get

/paas/api/v1.1/instancemgmt/{identityDomainId}/services/dbaas/instances/{serviceId}/patches/available

Returns a list of all available patches for an Exadata Cloud at Customer database deployment.

Request

Path Parameters

  • The value depends on the type of Exadata Cloud at Customer account that is used to make the request:

    • For a Traditional Cloud Account, specify the Identity Domain Name that is associated with the service.

    • For a Cloud Account with Identity Cloud Service, specify the Identity Service Id that is associated with the service, which is a character string beginning with idcs-.

  • Name of the Exadata Cloud at Customer deployment.
Header Parameters
Back to Top

Response

Supported Media Types

200 Response

OK. See Status Codes for information about other possible HTTP status codes.
Body ()
Root Schema : available-patches-response
Type: object
The response body contains information about the available patches.
Show Source
Nested Schema : availablePatchGuiMetadata
Type: object
Instruction to the metadata UI about the patch.
Show Source
Nested Schema : componentPatches
Type: array
Group the details of each patches in the component.
Show Source
Nested Schema : patchComponents
Type: array
Group the details of the patch to be applied.
Show Source
Nested Schema : component-patch
Type: object
Group the details of each patch in the component.
Show Source
Nested Schema : preserveFiles
Type: array
List of files to be preserved during patching.
Show Source
Nested Schema : zipBundles
Type: array
Zips that contain the patched binaries or patches.
Show Source
Nested Schema : view-zip-bundles
Type: object
Group the details of zips for the patched binaries.
Show Source
Nested Schema : patch-component
Type: object
Group the details of the patch to be applied.
Show Source
Nested Schema : preserveFiles
Type: array
List of files to be preserved during patching.
Show Source
Back to Top

Examples

The following example shows how to view information about available patches associated with an Exadata Cloud at Customer database deployment by submitting a GET request on the REST endpoint using cURL.

In this example, the identity domain is usexample, the Exadata Cloud at Customer database deployment is db12c and the Oracle Cloud user name and password are serviceadmin and Pa55_word.

cURL Command

curl -i -X GET --cacert ~/cacert.pem -u serviceadmin:Pa55_word -H "X-ID-TENANT-NAME:usexample"  https://dbaas.oraclecloud.com/paas/api/v1.1/instancemgmt/usexample/services/dbaas/instances/db12c/patches/available

HTTP Status Code and Response Headers

HTTP/2.0 200
server: Oracle-Application-Server-11g
strict-transport-security: max-age=31536000;includeSubDomains
content-language: en
access-control-allow-headers: Content-Type, api_key, Authorization, X-ID-TENANT-NAME, X-USER-IDENTITY-DOMAIN-NAME
access-control-allow-methods: GET, POST, DELETE, PUT, OPTIONS, HEAD
x-oracle-dms-ecid: 005KB8ooyHG6uHFpR0H7id00067c0002VD
x-oracle-dms-ecid: 005KB8ooyHG6uHFpR0H7id00067c0002VD
access-control-allow-origin: *
x-frame-options: DENY
content-type: application/json
vary: user-agent
date: Mon, 29 May 2017 23:40:04 GMT
content-length: 1114

Response Body

[{
		"availablePatchGuiMetadata": {
			"supportsPreCheck": false
		},
		"patchId": "24968615",
		"patchNumber": "Patch_12.1.0.2.170117",
		"patchCategory": "DB",
		"patchSeverity": "Normal",
		"includesConfigUpgrade": false,
		"patchDescription": "DB 12.1.0.2.170117 QUARTERLY DATABASE PATCH FOR EXADATA - JAN2017",
		"patchReleaseUrl": "https://support.oracle.com/epmos/faces/PatchDetail?patchId\u003d24968615",
		"serviceType": "DBaaS",
		"serviceVersion": "12.1.0.2",
		"releaseDate": "2017-01-17T01:40:00.000+0000",
		"entryDate": "2017-05-13T06:07:22.073+0000",
		"entryUserId": "smctl",
		"componentPatches": {
			"EXADATA": {
				"id": 2651,
				"version": "12.1.0.2.170117",
				"releaseVersion": "12.1.0.2.170117",
				"zipBundles": {
					"EXADATA": {
						"id": 4721,
						"md5sum": "48a8623500c7f4b50e703011a1cfeb67",
						"storageKey": "PATCH/DB/12c/database.zip",
						"zipVersion": "12.1.0.2.170117"
					}
				},
				"preserveFiles": []
			}
		},
		"patchType": "PSU",
		"requiresRestart": true,
		"serviceTypeVersions": "ANY",
		"isDeleted": false,
		"displayName": "12.1.0.2.170117",
		"supportedStrategy": "Rolling",
		"releaseVersion": "12.1.0.2.170117",
		"serviceEditions": "EE_EP"
	}
]
Back to Top