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

View a List of Applied and Rolled Back Patches

get

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

Returns an array detailing the patch application operations on a Database Classic Cloud Service instance. Additionally, if an applied patch was rolled back, information about the rollback operation is included in the array element for that patch application operation.

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 : applied-patches-response
Type: array
The response body includes details of all applied patches.
Show Source
Nested Schema : applied-patch
Type: object
Information about an applied 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 : patching-result
Type: object
Groups information about the results of the patch.
Show Source
Nested Schema : progressMessages
Type: array
List of progress messages for the patch.
Show Source
Nested Schema : rollback-result
Type: object
Groups information about the results of the rollback operation. This attribute displays only when a rollback of the patch had been performed.
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
Nested Schema : progressMessages
Type: array
List of progress messages for the patch.
Show Source
Nested Schema : progressMessages
Type: array
List of progress messages for the rollback.
Show Source
Back to Top

Examples

The following example shows how to view a list of applied and rolled back 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/applied

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: 2808
Connection: keep-alive

Response Body

[
  {
    "backupStatus": "Unknown",
    "additionalNote": "Rolling back Oct 2016 PSU",
    "appliedBy": "dbcsadmin",
    "appliedDate": "2016-12-22T23:09:22.142+0000",
    "totalTime": "23 min, 6 sec",
    "patchId": "24006101-EE",
    "patchDescription": "DB 12.1.0.2.161018 Oct 2016 PSU Enterprise Edition image",
    "patchReleaseUrl": "https:\/\/support.oracle.com\/epmos\/faces\/PatchDetail?patchId=24006101",
    "releaseDate": "2016-10-18T01:40:00.000+0000",
    "resultMessage": "Completed",
    "lastStatus": "COMPLETED_ROLLBACK",
    "lastStatusMessage": "Completed",
    "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",
    "patchCategory": "DB",
    "patchSeverity": "Normal",
    "jobId": "3373771",
    "displayName": "12.1.0.2.161018",
    "toVersion": "12.1.0.2.161018",
    "inProgress": false,
    "operationType": "None",
    "id": 78919,
    "patchingResult": {
      "patchingId": 60170,
      "versionBeforeThisPatch": "DB 12.1.0.2.160719",
      "strategy": "Rolling",
      "releaseVersionBeforeThisPatch": "12.1.0.2",
      "customRollbackId": "3375102_1482440121001",
      "startDate": "2016-12-22T20:55:21.001+0000",
      "endDate": "2016-12-22T21:30:54.526+0000",
      "patchingStatus": "COMPLETED",
      "resultMessage": "Completed",
      "additionalNote": "Applying Oct 2016 PSU",
      "appliedBy": "dbcsadmin",
      "jobId": "3375102",
      "completeLog": "",
      "progressMessages": [
        "8:55:20.980 PM Phase initialize started",
        "8:55:21.038 PM Phase initialize completed",
        "8:55:21.104 PM Phase patch started",
        "9:30:54.244 PM Phase patch completed",
        "9:30:54.324 PM Phase finalize started",
        "9:30:54.373 PM Completed"
      ]
    },
    "rollbackResult": {
      "rollbackId": 451,
      "startDate": "2016-12-22T23:09:22.142+0000",
      "endDate": "2016-12-22T23:32:28.232+0000",
      "patchingStatus": "COMPLETED_ROLLBACK",
      "resultMessage": "Completed",
      "additionalNote": "Rolling back Oct 2016 PSU",
      "appliedBy": "dbcsadmin",
      "jobId": "3373771",
      "completeLog": "",
      "progressMessages": [
        "11:09:22.123 PM Phase initialize started",
        "11:09:22.185 PM Phase initialize completed",
        "11:09:22.237 PM Phase rollback started",
        "11:32:27.818 PM Phase rollback completed",
        "11:32:27.953 PM Phase finalize started",
        "11:32:28.044 PM Completed"
      ]
    },
    "rollbackId": "78919",
    "currentPatchLevel": "DB 12.1.0.2.161018",
    "progressMessages": [
      "11:09:22.123 PM Phase initialize started",
      "11:09:22.185 PM Phase initialize completed",
      "11:09:22.237 PM Phase rollback started",
      "11:32:27.818 PM Phase rollback completed",
      "11:32:27.953 PM Phase finalize started",
      "11:32:28.044 PM Completed"
    ]
  }
]
Back to Top