psm dbcs available-patches

List all patches available to be applied to an Oracle Database Classic 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 Classic 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 Classic 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"
    }
]