psm dbcs available-patches

List all patches available to be applied to an Oracle Database Cloud Service instance.

Syntax

psm dbcs available-patches -s|--service-name instance-name [-of|--output-format json|html|short]

Parameters

Parameter Description

-s|--service-name instance-name

Specifies the name of the Database Cloud Service instance for which you want to list available patches.

-of|--output-format json|html|short

(Optional) Specifies the output format of the command’s response:

  • json—output is formatted as a JSON array.

  • html—output is formatted as HTML

  • short—output is formatted as a brief summary.

The default output format is the one you specified when using the psm setup command to configure the psm CLI.

Examples

The following example lists patches available for the db12c-xp-si Database Cloud Service instance.

$ psm dbcs available-patches --service-name db12c-xp-si
[
    {
        "availablePatchGuiMetadata":{
            "supportsPreCheck":true
        },
        "lastprePreCheckResult":{
            "id":2307,
            "jobId":"5753350",
            "patchId":"22291127-EE",
            "jsonResult":"{\"resultMessage\":\"Completed\",\"messages\":[]}",
            "startDate":"Jul 15, 2016 5:12:47 PM",
            "endDate":"Jul 15, 2016 5:13:52 PM",
            "performedBy":"dbaasadmin",
            "inProgress":false,
            "status":"PASSED_PRECHECK",
            "preCheckMessages":[]
        },
        "patchId":"22291127-EE",
        "patchNumber":"Patch_12.1.0.2.160419_EE",
        "patchCategory":"DB",
        "patchSeverity":"Normal",
        "includesConfigUpgrade":false,
        "patchDescription":"DB 12.1.0.2.160419 Apr 2016 PSU Enterprise Edition image",
        "patchReleaseUrl":"https://support.oracle.com/epmos/faces/PatchDetail?patchId=22291127",
        "serviceType":"DBaaS",
        "serviceVersion":"12.1.0.2",
        "releaseDate":"Apr 16, 2016 1:40:00 AM",
        "entryDate":"Jul 2, 2016 2:44:07 AM",
        "entryUserId":"OCLOUD9_TAS_APPID",
        "componentPatches":{
            "DB":{
                "id":820,
                "version":"12.1.0.2.160419",
                "releaseVersion":"12.1.0.2.160419",
                "zipBundles":{
                    "DB":{
                        "id":790,
                        "md5sum":"48a8623500c7f4b50e703011a1cfeb67",
                        "provisioningObjectRef":"DB/12c/database.zip",
                        "storageKey":"PATCH/DB/12c/database.zip",
                        "zipVersion":"12.1.0.2.160419"
                    }
                },
                "preserveFiles":[]
            }
        },
        "patchComponents":[
            {
                "id":820,
                "component":"DB",
                "version":"12.1.0.2.160419",
                "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.160419",
        "releaseVersion":"12.1.0.2.160419",
        "serviceEditions":"EE,EE_HP,EE_EP"
    }
]