psm dbcs patch

Apply a patch to an Oracle Database Cloud Service instance.

Syntax

In the following syntax, line breaks have been added for clarity. Do not include them when entering the command.

psm dbcs patch
  -s|--service-name instance-name
  -p|--patch-id patch-id
  [-n|--additional-note note-text]
  [-of|--output-format json|html|short]

Parameters

Parameter Description

-s|--service-name instance-name

Specifies the name of the Database Cloud Service instance you want to patch.

-p|--patch—id patch-id

Specifies the patch ID of the patch to apply. To retrieve a list of patch IDs available to apply a service instance, see psm dbcs available-patches.

-n|--additional-note note-text

(Optional) Specifies custom note text you want to associate with the patching operation.

-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 applies patch 22291127-EE to the db12c-xp-si Database Cloud Service instance.

$ psm dbcs patch --service-name db12c-xp-si --patch-id 22291127-EE
{
    "status":"Completed",
    "details":{
        "message":"PATCHING-5068: Patching service with patch [22291127-EE] is submitted as an asynchronous job.",
        "jobId":"5859931"
    }
}
Job ID : 5859931

Here is the information about job 5859931 upon successful completion of the operation:

$ psm dbcs operation-status --job-id 5859931
{
    "activityLogId":3651105,
    "serviceName":"db12c-xp-si",
    "serviceType":"dbaas",
    "identityDomain":"usexample",
    "serviceId":129996,
    "jobId":5859931,
    "startDate":"2016-07-27T18:32:12.481+0000",
    "endDate":"2016-07-27T18:59:46.429+0000",
    "status":"SUCCEED",
    "operationId":129996,
    "operationType":"PATCH",
    "summaryMessage":"PATCH",
    "authDomain":"usexample",
    "authUser":"dbaasadmin",
    "initiatedBy":"USER",
    "messages":[
        {
            "activityDate":"2016-07-27T18:32:12.480+0000",
            "message":"Phase initialize completed"
        },
        {
            "activityDate":"2016-07-27T18:32:12.481+0000",
            "message":"Patching job [5859931] initiated by [dbaasadmin] started.."
        },
        {
            "activityDate":"2016-07-27T18:59:46.207+0000",
            "message":"Phase patch completed"
        },
        {
            "activityDate":"2016-07-27T18:59:46.427+0000",
            "message":"Completed"
        }
    ]
}