1. REST API for Oracle Database Classic Cloud Service
  2. Tasks
  3. Patches

View a List of Available Patches

get

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

Returns an array detailing the patches available to apply to a Database Classic Cloud Service instance.

Request

Path Parameters
  • Identity domain ID for the Database Classic Cloud Service account:
     

    • For a Cloud account with Identity Cloud Service: the identity service ID, which has the form idcs-letters-and-numbers. You can find this ID in the Identity Service Id field on the Overview tab of the Service Details page for Database Classic Cloud Service in My Services.

    • For a traditional cloud account: the name of the identity domain.

  • Name of the Database Classic Cloud Service instance.
Header Parameters
  • Base64 encoding of the user name and password of the user making the request. For more information, see Security, Authentication and Authorization.
  • Identity domain ID for the Database Classic Cloud Service account:
     

    • For a Cloud account with Identity Cloud Service: the identity service ID, which has the form idcs-letters-and-numbers. You can find this ID in the Identity Service Id field on the Overview tab of the Service Details page for Database Classic Cloud Service in My Services.

    • For a traditional cloud account: the name of the identity domain.

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 a list of available patches by submitting a GET request on the REST endpoint using cURL.

This example uses a traditional cloud account, so the {identityDomainId} path parameter and the X-ID-TENANT-NAME header parameter are set to the account's domain name, which is mydomain. The service instance is db121-ep-si and the Oracle Cloud user name of the user making the call is dbcsadmin.

cURL Command

curl --include --request GET \
--user dbcsadmin:password \
--header "X-ID-TENANT-NAME:mydomain" \
https://dbaas.oraclecloud.com/paas/api/v1.1/instancemgmt/mydomain/services/dbaas/instances/db121-ep-si/patches/available

HTTP Status Code and Response Headers

HTTP/1.0 200 Connection established

HTTP/1.1 200 OK
Server: Oracle-Application-Server-11g
Content-Language: en
Access-Control-Allow-Headers: Content-Type, api_key, Authorization
Access-Control-Allow-Methods: GET, POST, DELETE, PUT, OPTIONS, HEAD
X-ORACLE-DMS-ECID: id-string
X-ORACLE-DMS-ECID: id-string
Access-Control-Allow-Origin: *
X-Frame-Options: DENY
Content-Type: application/json
Vary: user-agent
Date: date-and-time-stamp
Content-Length: 1729
Connection: keep-alive

Response Body

[
  {
    "availablePatchGuiMetadata": {
      "supportsPreCheck": true
    },
    "lastprePreCheckResult": {
      "id": 1887,
      "jobId": "3371498",
      "patchId": "24006101-EE",
      "jsonResult": "{\"resultMessage\":\"Completed\",\"messages\":[]}",
      "startDate": "2016-12-22T19:20:21.318+0000",
      "endDate": "2016-12-22T19:21:33.029+0000",
      "performedBy": "dbcsadmin",
      "inProgress": false,
      "status": "PASSED_PRECHECK",
      "preCheckMessages": [],
      "statusMessage": "Completed"
    },
    "patchId": "24006101-EE",
    "patchNumber": "Patch_12.1.0.2.161018_EE",
    "patchCategory": "DB",
    "patchSeverity": "Normal",
    "includesConfigUpgrade": false,
    "patchDescription": "DB 12.1.0.2.161018 Oct 2016 PSU Enterprise Edition image",
    "patchReleaseUrl": "https:\/\/support.oracle.com\/epmos\/faces\/PatchDetail?patchId=24006101",
    "serviceType": "DBaaS",
    "serviceVersion": "12.1.0.2",
    "releaseDate": "2016-10-18T01:40:00.000+0000",
    "entryDate": "2016-12-10T03:09:25.943+0000",
    "entryUserId": "OCLOUD9_SM_PLATFORM_APPID",
    "componentPatches": {
      "DB": {
        "id": 1105,
        "version": "12.1.0.2.161018",
        "releaseVersion": "12.1.0.2.161018",
        "zipBundles": {
          "DB": {
            "id": 1074,
            "md5sum": "48a8623500c7f4b50e703011a1cfeb67",
            "provisioningObjectRef": "DB\/12c\/database.zip",
            "storageKey": "PATCH\/DB\/12c\/database.zip",
            "zipVersion": "12.1.0.2.161018"
          }
        },
        "preserveFiles": []
      }
    },
    "patchComponents": [
      {
        "id": 1105,
        "component": "DB",
        "version": "12.1.0.2.161018",
        "md5sum": "48a8623500c7f4b50e703011a1cfeb67",
        "provisioningObjectRef": "DB\/12c\/database.zip",
        "patchingObjectRef": "PATCH\/DB\/12c\/database.zip",
        "preserveFiles": []
      }
    ],
    "patchType": "PSU",
    "requiresRestart": true,
    "serviceTypeVersions": "ANY",
    "isDeleted": false,
    "isCustomerVisible": false,
    "isAutoApply": false,
    "induceDownTime": false,
    "displayName": "12.1.0.2.161018",
    "releaseVersion": "12.1.0.2.161018",
    "serviceEditions": "EE,EE_HP,EE_EP",
    "patchCustomActions": []
  }
]
Back to Top