psm dbcs applied-patches

List all patches that have been applied to an Oracle Database Classic Cloud Service instance.

Syntax

psm dbcs applied-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 see a list of applied 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 applied to the db12c-xp-si Database Classic Cloud Service instance.

$ psm dbcs applied-patches --service-name db12c-xp-si
[
    {
        "backupStatus":"Available",
        "additionalNote":"This note is the default note: Applying patch [22291127-EE].",
        "appliedBy":"dbaasadmin",
        "appliedDate":"Jul 27, 2016 6:32:12 PM",
        "totalTime":"27 min, 34 sec",
        "patchId":"22291127-EE",
        "patchDescription":"DB 12.1.0.2.160419 Apr 2016 PSU Enterprise Edition image",
        "patchReleaseUrl":"https://support.oracle.com/epmos/faces/PatchDetail?patchId=22291127",
        "releaseDate":"Apr 16, 2016 1:40:00 AM",
        "resultMessage":"Completed",
        "lastStatus":"COMPLETED",
        "lastStatusMessage":"Completed",
        "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",
        "patchCategory":"DB",
        "patchSeverity":"Normal",
        "jobId":"5859931",
        "displayName":"12.1.0.2.160419",
        "toVersion":"12.1.0.2.160419",
        "inProgress":false,
        "operationType":"None",
        "id":131003,
        "patchingResult":{
            "patchingId":110800,
            "versionBeforeThisPatch":"DB 12.1.0.2.160119",
            "strategy":"Rolling",
            "metaVersionBeforeThisPatch":"16.2.5",
            "customRollbackId":"5859931_1469644332452",
            "startDate":"Jul 27, 2016 6:32:12 PM",
            "endDate":"Jul 27, 2016 6:59:46 PM",
            "patchingStatus":"COMPLETED",
            "resultMessage":"Completed",
            "additionalNote":"This note is the default note: Applying patch [22291127-EE].",
            "appliedBy":"dbaasadmin",
            "jobId":"5859931",
            "completeLog":"",
            "progressMessages":[
                "6:32:12.366 PM Phase initialize started",
                "6:32:12.480 PM Phase initialize completed",
                "6:32:12.597 PM Phase patch started",
                "6:59:46.207 PM Phase patch completed",
                "6:59:46.320 PM Phase finalize started",
                "6:59:46.427 PM Completed"
            ]
        },
        "rollbackId":"131003",
        "rollbackVersion":"DB 12.1.0.2.160119",
        "currentPatchLevel":"DB 12.1.0.2.160419",
        "progressMessages":[
            "6:32:12.366 PM Phase initialize started",
            "6:32:12.480 PM Phase initialize completed",
            "6:32:12.597 PM Phase patch started",
            "6:59:46.207 PM Phase patch completed",
            "6:59:46.320 PM Phase finalize started",
            "6:59:46.427 PM Completed"
        ]
    }
]