Oracle Patching of Databases (DB) and Grid Infrastructure (GI) is a routine and recommended process for any Oracle database. It’s no different in Oracle Cloud Infrastructure (OCI). In fact, OCI makes it even easier for DBAs to patch the required Oracle Homes.
This post will show you how to patch a OCI DB System via OCI .
For clarity, in the OCI Database Cloud Service (DBCS) the GI software stack is considered part of the DB system and is referenced as such in the web console.
Note: The below article assumes that:
- Access to Oracle Cloud tenancy exists and all examples are referred via OCI CLI.
- The reader is familiar with OCI CLI (Command Line Interface). If you’re new to OCI CLI, I suggest you check out my earlier post to get started on OCI CLI: https://blog.pythian.com/the-ocidtab-a-solution-to-make-oci-cli-scripting-easier
- For further reference OCI CLI, check out the following Pythian blogs for some very useful information: https://blog.pythian.com/installing-oci-command-line-utilities-in-linux-and-windows/; https://blog.pythian.com/oracle-database-cloud-service/
While the same patching process could also be completed using the OCI web console, patching using the OCI CLI makes the process more consistent and repeatable.This might be especially important if many systems need to be patched using automation tooling.
A word about “dbcli”
The “dbcli” is a utility available in Database VM and Bare Metal systems which can be used to check the current and available patches for the components Installed. (Dbcli is specific to OCI DBCS and is not available in on-premises Oracle implementations or with other OCI Oracle Database services.) We will use the dbcli to check the versions and monitor the status patching. The “dbcli” needs to run as the root user of the DB system (dbcli by itself has several features which will not be covered in this blog).
We’ll assume the DB/GI system we have in OCI is 11g DB/19c GI, which is the minimum required for customers still on a 11g database and are looking to move to OCI DBCS. (The GI release needs to match or exceed the DB release and for the DBCS service, the most recent stable release is chosen automatically. You can’t choose a specific release.)
Before patching to a higher version of the DB system, we need to identify the version in use, like the DB and GI versions of an OCI database system shown below:
[[email protected] ~]# dbcli describe-component System Version --------------- 21.2.3.0.0 Component Installed Version Available Version ---------------------------------------- -------------------- -------------------- GI 19.11.0.0.0 19.12.0.0 DB 11.2.0.4.210420 11.2.0.4.210720
As we can see above, a new version is available for both the DB and the GI software.
GI patching
We’ll need to identify the DB system OCID we have created for the 11g(DB) / 19c(GI). Each database system will have a unique OCID identified with it. Once the DB system OCID is identified, we’ll need to identify what patches are available.
Note that OCI calls the GI patching a DB system patch and not explicitly as a GI patch; in this case, we’ll search for the July 19c DB system patch and identify the OCID for this patch. Also, note that OCI makes the patches available automatically for DBCS, so you don’t need to manually download patches from My Oracle Support like you would for on-premises databases.
### Set up the Dev Environment variables
$ . ~/.DEV-ocidtab
### DB System OCID
$ export DB_SYSTEM_OCID=$(oci db system list -c $COMP_OCID --profile DEV --query "data[?contains(\"hostname\",'ocilabhost01')].{id:id}" | jq -r '.[]."id"');echo $DB_SYSTEM_OCID
ocid1.dbsystem.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
### DB System Patch OCID
$ export DB_SYSTEM_PATCH=$(oci db patch list by-db-system --db-system-id $DB_SYSTEM_OCID --profile DEV --all --query "data[?contains(\"description\",'Jul 2021 19c Db System patch')]" | jq -r '.[]."id"');echo $DB_SYSTEM_PATCH
ocid1.dbpatch.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# NOTE : That even though we are patching the GI the patch OCID values are always references as ocid.dbpatch.x.x.x in the OCI value , the patch naming
# Does not differentiate between a DB Patch and a GI Patch
### Identify the the DB System Patch that is required
$ oci db patch list by-db-system --db-system-id $DB_SYSTEM_OCID --profile DEV --all
{
"data": [
{
"available-actions": [
"APPLY",
"PRECHECK"
],
"description": "Jul 2021 19c Db System patch",
"id": "ocid1.dbpatch.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"last-action": null,
"lifecycle-details": null,
"lifecycle-state": null,
"time-released": "2021-07-20T01:00:00+00:00",
"version": "19.12.0.0.210720"
}
]
}
From the above we can see the patch options (“available-actions”) available are PRECHECK and APPLY. As always, we run a precheck to ensure the patching requirements are appropriate. The following shows how we run the precheck after identifying the OCIS of the DB system and the patches:
--- Running Prechecks
$ oci db system patch --db-system-id $DB_SYSTEM_OCID --patch-action PRECHECK --patch-id $DB_SYSTEM_PATCH --profile DEV
{
"data": {
"availability-domain": "lhaE:US-ASHBURN-AD-1",
"backup-network-nsg-ids": null,
"backup-subnet-id": null,
"cluster-name": null,
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"cpu-core-count": 4,
"data-storage-percentage": 80,
"data-storage-size-in-gbs": 2048,
"database-edition": "STANDARD_EDITION",
"db-system-options": {
"storage-management": "ASM"
},
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "abhilash_kumar",
"CreatedOn": "2021-10-27T08:07:30.319Z"
}
},
"disk-redundancy": "NORMAL",
"display-name": "ocilabhost01",
"domain": "net02.ocideviad.oraclevcn.com",
"fault-domains": [
"FAULT-DOMAIN-1"
],
"freeform-tags": {},
"hostname": "ocilabhost01",
"id": "ocid1.dbsystem.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"iorm-config-cache": null,
"kms-key-id": null,
"last-maintenance-run-id": null,
"last-patch-history-entry-id": "ocid1.dbpatchhistory.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"license-model": "LICENSE_INCLUDED",
"lifecycle-details": null,
"lifecycle-state": "UPDATING",
"listener-port": 1521,
"maintenance-window": null,
"next-maintenance-run-id": null,
"node-count": 1,
"nsg-ids": null,
"point-in-time-data-disk-clone-timestamp": null,
"reco-storage-size-in-gb": 408,
"scan-dns-name": "ocilabhost01-scan.net02.ocideviad.oraclevcn.com",
"scan-dns-record-id": "ocid1.vcndnsrecord.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"scan-ip-ids": null,
"shape": "VM.Standard2.4",
"source-db-system-id": null,
"sparse-diskgroup": null,
"ssh-public-keys": [
"ssh-rsa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [email protected]",
"ssh-rsa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [email protected]",
"ssh-rsa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [email protected]",
],
"subnet-id": "ocid1.subnet.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"time-created": "2021-10-27T08:07:32.908000+00:00",
"time-zone": "America/Toronto",
"version": "19.11.0.0.0",
"vip-ids": null,
"zone-id": "ocid1.dns-zone.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
}
}
The use of “dbcli listjobs” would show the precheck is completed:
--- Check Current GI Version for ocilabhost01
$ oci db system list -c $COMP_OCID --profile DEV --output table --query "data[?contains(\"hostname\",'ocilabhost01')].{hostname:hostname,verson:version}"
+-------------------+-------------+
| hostname | verson |
+-------------------+-------------+
| ocilabhost01 | 19.11.0.0.0 |
+-------------------+-------------+
# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
.
.
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Server Patching Prechecks Friday, October 29, 2021, 09:57:03 EDT Success
Applying the GI patch is done by using the APPLY clause. (However, during the patching process, the entire database will be unavailable.)
$ oci db system patch --db-system-id $DB_SYSTEM_OCID --patch-action APPLY --patch-id $DB_SYSTEM_PATCH --profile DEV
{
"data": {
"availability-domain": "lhaE:US-ASHBURN-AD-1",
"backup-network-nsg-ids": null,
"backup-subnet-id": null,
"cluster-name": null,
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"cpu-core-count": 4,
"data-storage-percentage": 80,
"data-storage-size-in-gbs": 2048,
"database-edition": "STANDARD_EDITION",
"db-system-options": {
"storage-management": "ASM"
},
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "abhilash_kumar",
"CreatedOn": "2021-10-27T08:07:30.319Z"
}
},
"disk-redundancy": "NORMAL",
"display-name": "ocideviaddb02",
"domain": "net02.ocideviad.oraclevcn.com",
"fault-domains": [
"FAULT-DOMAIN-1"
],
"freeform-tags": {},
"hostname": "ocilabhost01",
"id": "ocid1.dbsystem.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"iorm-config-cache": null,
"kms-key-id": null,
"last-maintenance-run-id": null,
"last-patch-history-entry-id": "ocid1.dbpatchhistory.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"license-model": "LICENSE_INCLUDED",
"lifecycle-details": null,
"lifecycle-state": "UPDATING",
"listener-port": 1521,
"maintenance-window": null,
"next-maintenance-run-id": null,
"node-count": 1,
"nsg-ids": null,
"point-in-time-data-disk-clone-timestamp": null,
"reco-storage-size-in-gb": 408,
"scan-dns-name": "ocilabhost01-scan.net02.ocideviad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.com",
"scan-dns-record-id": "ocid1.vcndnsrecord.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"scan-ip-ids": null,
"shape": "VM.Standard2.4",
"source-db-system-id": null,
"sparse-diskgroup": null,
"ssh-public-keys": [
"ssh-rsa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [email protected]",
"ssh-rsa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [email protected]",
"ssh-rsa xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [email protected]"
],
"subnet-id": "ocid1.subnet.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"time-created": "2021-10-27T08:07:32.908000+00:00",
"time-zone": "America/Toronto",
"version": "19.11.0.0.0",
"vip-ids": null,
"zone-id": "ocid1.dns-zone.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
}
}
This patch application might take its time depending on each patch set. Here’s what the completion looks like:
[[email protected] ~]# dbcli list-jobs ID Description Created Status ---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ---------- . . . . . . xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Server Patching Prechecks Friday, October 29, 2021, 09:57:03 EDT Success yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy Server Patching Saturday, October 30, 2021, 11:24:27 EDT Success ### Summary of Patching Job [[email protected] ~]# dbcli describe-job -i yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy Job details ---------------------------------------------------------------- ID: yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy Description: Server Patching Status: Success Created: October 30, 2021 11:24:27 AM EDT Progress: 100% Message: Task Name Start Time End Time Status ------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ---------- Pre-operations for Server Patching October 30, 2021 11:24:27 AM EDT October 30, 2021 11:25:51 AM EDT Success Server Patching October 30, 2021 11:25:51 AM EDT October 30, 2021 12:05:38 PM EDT Success ### For more detailed Verbose Output for theJob [[email protected] ~]# dbcli describe-job -i yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy -l Verbose Job details ---------------------------------------------------------------- ID: yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy Description: Server Patching Status: Success Created: October 30, 2021 11:24:27 AM EDT Progress: 100% Message: Task Name Start Time End Time Status ------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ---------- Server Patching October 30, 2021 11:24:27 AM EDT October 30, 2021 12:05:38 PM EDT Success Starting Server Components Updation October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success Pre-operations for Server Patching October 30, 2021 11:24:27 AM EDT October 30, 2021 11:25:51 AM EDT Success Starting Server patching Pre-operations October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success task:TaskParallel_3314 October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success Deleting patching Dirs October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success task:TaskSequential_3317 October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success Create patching repository directories[ocilabhost01] October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success task:TaskSequential_3320 October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success Download latest patch metadata[ocilabhost01] October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success task:TaskParallel_3323 October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success minimum DcsAgent version checking October 30, 2021 11:24:27 AM EDT October 30, 2021 11:24:27 AM EDT Success task:TaskSequential_3326 October 30, 2021 11:24:27 AM EDT October 30, 2021 11:25:51 AM EDT Success Update Patching Repository[ocilabhost01] October 30, 2021 11:24:27 AM EDT October 30, 2021 11:25:51 AM EDT Success Server Patching October 30, 2021 11:25:51 AM EDT October 30, 2021 12:05:38 PM EDT Success Starting Server Patching Operations October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskSequential_3332 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskSequential_3333 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success Create patching repository directories[ocilabhost01] October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskSequential_3246 October 30, 2021 11:25:51 AM EDT October 30, 2021 12:05:38 PM EDT Success Starting gi Patching October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskParallel_3249 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success Cleanup unwanted clones October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskParallel_3252 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success Generating SSH key October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskParallel_3255 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success Generating SSH key October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskSequential_3258 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success task:TaskZJsonRpcExt_3259 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:51 AM EDT Success Adding USER SSH_EQUIVALENCE October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:52 AM EDT Success task:TaskZJsonRpcExt_3262 October 30, 2021 11:25:51 AM EDT October 30, 2021 11:25:52 AM EDT Success task:TaskZJsonRpcExt_3264 October 30, 2021 11:25:52 AM EDT October 30, 2021 11:25:52 AM EDT Success task:TaskZJsonRpcExt_3266 October 30, 2021 11:25:52 AM EDT October 30, 2021 11:25:52 AM EDT Success task:TaskParallel_3268 October 30, 2021 11:25:52 AM EDT October 30, 2021 11:25:56 AM EDT Success Opatch updation[ocilabhost01] October 30, 2021 11:25:52 AM EDT October 30, 2021 11:25:56 AM EDT Success task:TaskSequential_3271 October 30, 2021 11:25:56 AM EDT October 30, 2021 11:29:34 AM EDT Success Patch conflict check[ocilabhost01] October 30, 2021 11:25:56 AM EDT October 30, 2021 11:29:34 AM EDT Success task:TaskParallel_3274 October 30, 2021 11:29:34 AM EDT October 30, 2021 11:29:34 AM EDT Success Setting owner to patching Dirs October 30, 2021 11:29:34 AM EDT October 30, 2021 11:29:34 AM EDT Success task:TaskSequential_3277 October 30, 2021 11:29:34 AM EDT October 30, 2021 12:05:33 PM EDT Success task:TaskSequential_3278 October 30, 2021 11:29:34 AM EDT October 30, 2021 12:05:33 PM EDT Success GI: Applying clusterware patch[ocilabhost01] October 30, 2021 11:29:34 AM EDT October 30, 2021 12:05:33 PM EDT Success task:TaskParallel_3281 October 30, 2021 12:05:33 PM EDT October 30, 2021 12:05:33 PM EDT Success Updating GiHome version[ocilabhost01] October 30, 2021 12:05:33 PM EDT October 30, 2021 12:05:33 PM EDT Success task:TaskParallel_3284 October 30, 2021 12:05:33 PM EDT October 30, 2021 12:05:36 PM EDT Success Updating All DBHome version October 30, 2021 12:05:33 PM EDT October 30, 2021 12:05:36 PM EDT Success Removing SSHKey October 30, 2021 12:05:36 PM EDT October 30, 2021 12:05:37 PM EDT Success Removing Znode October 30, 2021 12:05:36 PM EDT October 30, 2021 12:05:36 PM EDT Success Removing keys from authorized_keys file October 30, 2021 12:05:36 PM EDT October 30, 2021 12:05:36 PM EDT Success Removing PrivatePublic key Files October 30, 2021 12:05:36 PM EDT October 30, 2021 12:05:36 PM EDT Success Running updatedb command October 30, 2021 12:05:36 PM EDT October 30, 2021 12:05:37 PM EDT Success Running SSHKey Gen October 30, 2021 12:05:37 PM EDT October 30, 2021 12:05:37 PM EDT Success Removing SSHKey October 30, 2021 12:05:37 PM EDT October 30, 2021 12:05:38 PM EDT Success Removing Znode October 30, 2021 12:05:37 PM EDT October 30, 2021 12:05:37 PM EDT Success Removing keys from authorized_keys file October 30, 2021 12:05:37 PM EDT October 30, 2021 12:05:37 PM EDT Success Removing PrivatePublic key Files October 30, 2021 12:05:37 PM EDT October 30, 2021 12:05:37 PM EDT Success Running updatedb command October 30, 2021 12:05:37 PM EDT October 30, 2021 12:05:38 PM EDT Success Running SSHKey Gen October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success Ending gi Patching October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success task:TaskSequential_3336 October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success Update System version[ocilabhost01] October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success task:TaskParallel_3339 October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success cleanup temp files October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success task:TaskParallel_3342 October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success Deleting patching Dirs October 30, 2021 12:05:38 PM EDT October 30, 2021 12:05:38 PM EDT Success
Checking components versions we see the that the GI part of the DB system patch is now up to date:
[[email protected] ~]# dbcli describe-component System Version --------------- 21.2.3.0.0 Component Installed Version Available Version ---------------------------------------- -------------------- -------------------- GI 19.12.0.0.0 up-to-date DB 11.2.0.4.210420 11.2.0.4.210720
DB patching
Moving on to the database patching the method of identifying the relevant patches, running prechecks and applying the patches are very similar. In this case, we can see that patch 11.2.0.4.210720 is now available:
$ oci db patch list by-database --database-id $DB_OCID --profile DEV --all
{
"data": [
{
"available-actions": [
"APPLY",
"PRECHECK"
],
"description": "Jul 2021 11.2.0.4 Database patch",
"id": "ocid1.dbpatch.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"last-action": null,
"lifecycle-details": null,
"lifecycle-state": null,
"time-released": "2021-07-20T01:00:00+00:00",
"version": "11.2.0.4.210720"
}
]
}
Let’s source the database OCID for the database orcl01 and patch for 11.2.0.4.210720:
### DB_OCID for the Database we want to apply the patch $ export DB_OCID=$(oci db database list --compartment-id $COMP_OCID --profile DEV --query "data[?contains(\"db-name\",'0rcl01')]" | jq -r '.[]."id"');echo $DB_OCID ocid1.database.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ### PATCH_OCID for the Database we want to apply the patch $ PATCH_OCID=$(oci db patch list by-database --database-id $DB_OCID --profile DEV --all | jq -r '.data[0]."id"');echo $PATCH_OCID ocid1.dbpatch.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Just like the patches and databases have their own OCI, the database home will also be associated with an OCID. To keep things simple, let’s source the OCID of the database home manually:
$ oci db database get --database-id $DB_OCID --profile DEV
{
"data": {
"character-set": "AL32UTF8",
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"connection-strings": {
"all-connection-strings": {
"cdbDefault": "ocilabhost01.net02.ocideviad.oraclevcn.com:1521/orcl01_iad1tz.net02.ocideviad.oraclevcn.com",
"cdbIpDefault": "(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=11.2.1.32)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl01_iad1tz.net02.ocideviad.oraclevcn.com)))"
},
"cdb-default": "ocilabhost01.net02.ocideviad.oraclevcn.com:1521/orcl01_iad1tz.net02.ocideviad.oraclevcn.com",
"cdb-ip-default": "(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=11.2.1.32)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl01_iad1tz.net02.ocideviad.oraclevcn.com)))"
},
"database-software-image-id": null,
"db-backup-config": {
"auto-backup-enabled": false,
"auto-backup-window": null,
"backup-destination-details": null,
"recovery-window-in-days": null
},
"db-home-id": "ocid1.dbhome.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"db-name": "orcl01",
"db-system-id": "ocid1.dbsystem.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"db-unique-name": "orcl01_iad1tz",
"db-workload": "OLTP",
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "abhilash_kumar",
"CreatedOn": "2021-10-27T08:07:31.955Z"
}
},
"freeform-tags": {},
"id": "ocid1.database.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"kms-key-id": null,
"last-backup-timestamp": null,
"lifecycle-details": null,
"lifecycle-state": "AVAILABLE",
"ncharacter-set": "AL16UTF16",
"pdb-name": null,
"source-database-point-in-time-recovery-timestamp": null,
"time-created": "2021-10-27T08:07:32.911000+00:00",
"vm-cluster-id": null
},
"etag": "bfe5cbad--gzip"
}
### Set the DB Home OCID
export DB_HOME_OCID=ocid1.dbhome.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Now that we have the database, database home and patch OCID, let’s apply the database precheck first. The method is very similar to the one we used for the DB system earlier:
$ oci db database patch --database-id $DB_OCID --patch-id $PATCH_OCID --patch-action PRECHECK --profile DEV
{
"data": {
"character-set": "AL32UTF8",
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"connection-strings": {
"all-connection-strings": {
"cdbDefault": "ocilabhost01.net02.ocideviad.oraclevcn.com:1521/orcl01_iad1tz.net02.ocideviad.oraclevcn.com",
"cdbIpDefault": "(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=11.2.1.32)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl01_iad1tz.net02.ocideviad.oraclevcn.com)))"
},
"cdb-default": "ocilabhost01.net02.ocideviad.oraclevcn.com:1521/orcl01_iad1tz.net02.ocideviad.oraclevcn.com",
"cdb-ip-default": "(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=11.2.1.32)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl01_iad1tz.net02.ocideviad.oraclevcn.com)))"
},
"database-software-image-id": null,
"db-backup-config": {
"auto-backup-enabled": false,
"auto-backup-window": null,
"backup-destination-details": null,
"recovery-window-in-days": null
},
"db-home-id": "ocid1.dbhome.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"db-name": "orcl01",
"db-system-id": "ocid1.dbsystem.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"db-unique-name": "orcl01_iad1tz",
"db-workload": "OLTP",
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "abhilash_kumar",
"CreatedOn": "2021-10-27T08:07:31.955Z"
}
},
"freeform-tags": {},
"id": "ocid1.database.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"kms-key-id": null,
"last-backup-timestamp": null,
"lifecycle-details": null,
"lifecycle-state": "UPDATING",
"ncharacter-set": "AL16UTF16",
"pdb-name": null,
"source-database-point-in-time-recovery-timestamp": null,
"time-created": "2021-10-27T08:07:32.911000+00:00",
"vm-cluster-id": null
}
}
The database patching is monitored a differently using work OCI requests, which are the history of database configurations/patching activities that happen for DB system databases:
----- Can see PRECHECK is in Progress -- 15%
$ oci work-requests work-request list -c $COMP_OCID --profile DEV
{
"data": [
{
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"id": "ocid1.coreservicesworkrequest.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"operation-type": "Patch DB Home",
"percent-complete": 15.0,
"status": "IN_PROGRESS",
"time-accepted": "2021-10-27T17:43:41.130000+00:00",
"time-finished": null,
"time-started": "2021-10-27T17:43:51.525000+00:00"
},
{
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"id": "ocid1.coreservicesworkrequest.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"operation-type": "Start Node",
"percent-complete": 100.0,
"status": "SUCCEEDED",
"time-accepted": "2021-10-27T13:00:04.901000+00:00",
"time-finished": "2021-10-27T13:02:35.799000+00:00",
"time-started": "2021-10-27T13:00:22.043000+00:00"
},
{
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"id": "ocid1.coreservicesworkrequest.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"operation-type": "Create DB System",
"percent-complete": 100.0,
"status": "SUCCEEDED",
"time-accepted": "2021-10-27T08:07:32.971000+00:00",
"time-finished": "2021-10-27T13:54:19.722000+00:00",
"time-started": "2021-10-27T08:33:04.010000+00:00"
}
]
}
----- Can see PRECHECK is completed 100%
$ oci work-requests work-request list -c $COMP_OCID --profile DEV
{
"data": [
{
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"id": "ocid1.coreservicesworkrequest.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"operation-type": "Stop Node",
"percent-complete": 100.0,
"status": "SUCCEEDED",
"time-accepted": "2021-10-28T01:00:04.506000+00:00",
"time-finished": "2021-10-28T01:04:15.124000+00:00",
"time-started": "2021-10-28T01:01:11.884000+00:00"
},
{
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"id": "ocid1.coreservicesworkrequest.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"operation-type": "Patch DB Home",
"percent-complete": 100.0,
"status": "SUCCEEDED", <<------ Can see precheck runs well
"time-accepted": "2021-10-27T17:43:41.130000+00:00",
"time-finished": "2021-10-27T17:50:19.082000+00:00",
"time-started": "2021-10-27T17:43:51.525000+00:00"
},
{
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"id": "ocid1.coreservicesworkrequest.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"operation-type": "Create DB System",
"percent-complete": 100.0,
"status": "SUCCEEDED",
"time-accepted": "2021-10-27T08:07:32.971000+00:00",
"time-finished": "2021-10-27T13:54:19.722000+00:00",
"time-started": "2021-10-27T08:33:04.010000+00:00"
}
]
}
We can also check the history of activities on the database home. This is similar to an oral inventory where we find the on-premises systems:
$ oci db patch-history list-db-home --db-home-id $DB_HOME_OCID --profile -DEV
{
"data": [
{
"action": "PRECHECK",
"id": "ocid1.dbpatchhistory.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"lifecycle-details": null,
"lifecycle-state": "SUCCEEDED",
"patch-id": "ocid1.dbpatch.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"time-ended": "2021-10-27T17:49:03.452000+00:00",
"time-started": "2021-10-27T17:43:40.705000+00:00"
}
]
}
Let’s apply the database patch now using the APPLY clause (remember that this is an operation for a single-instance database and will mean some downtime):
$ oci db database patch --database-id $DB_OCID --patch-id $PATCH_OCID --patch-action APPLY --profile DEV
{
"data": {
"character-set": "AL32UTF8",
"compartment-id": "ocid1.compartment.oc1..xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"connection-strings": {
"all-connection-strings": {
"cdbDefault": "ocilabhost01.net02.ocideviad.oraclevcn.com:1521/orcl01_iad1tz.net02.ocideviad.oraclevcn.com",
"cdbIpDefault": "(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=11.2.1.32)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl01_iad1tz.net02.ocideviad.oraclevcn.com)))"
},
"cdb-default": "ocilabhost01.net02.ocideviad.oraclevcn.com:1521/orcl01_iad1tz.net02.ocideviad.oraclevcn.com",
"cdb-ip-default": "(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=11.2.1.32)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl01_iad1tz.net02.ocideviad.oraclevcn.com)))"
},
"database-software-image-id": null,
"db-backup-config": {
"auto-backup-enabled": false,
"auto-backup-window": null,
"backup-destination-details": null,
"recovery-window-in-days": null
},
"db-home-id": "ocid1.dbhome.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"db-name": "orcl01",
"db-system-id": "ocid1.dbsystem.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"db-unique-name": "orcl01_iad1tz",
"db-workload": "OLTP",
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "abhilash_kumar",
"CreatedOn": "2021-10-27T08:07:31.955Z"
}
},
"freeform-tags": {},
"id": "ocid1.database.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"kms-key-id": null,
"last-backup-timestamp": null,
"lifecycle-details": null,
"lifecycle-state": "UPDATING",
"ncharacter-set": "AL16UTF16",
"pdb-name": null,
"source-database-point-in-time-recovery-timestamp": null,
"time-created": "2021-10-27T08:07:32.911000+00:00",
"vm-cluster-id": null
}
}
The patch history and progress is seen using the dbcli list-jobs:
[[email protected] ~]# dbcli list-jobs ID Description Created Status ---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ---------- . . . xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Server Patching Prechecks Friday, October 29, 2021, 09:57:03 EDT Success yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy Server Patching Saturday, October 30, 2021, 11:24:27 EDT Success zzzzzzzz-zzzz-zzzz-zzzz-zzzzzzzzzzzz DBHome Patching: Home ID is bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb Saturday, October 30, 2021, 13:38:53 EDT Running [[email protected] ~]# dbcli describe-job -i zzzzzzzz-zzzz-zzzz-zzzz-zzzzzzzzzzzz Job details ---------------------------------------------------------------- ID: zzzzzzzz-zzzz-zzzz-zzzz-zzzzzzzzzzzz Description: DBHome Patching: Home ID is bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb Status: Success Created: October 30, 2021 1:38:53 PM EDT Progress: 100% Message: Task Name Start Time End Time Status ------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ---------- Pre-operations for DBHome patching October 30, 2021 1:38:53 PM EDT October 30, 2021 1:40:08 PM EDT Success DBHome patching October 30, 2021 1:40:08 PM EDT October 30, 2021 1:52:30 PM EDT Success Post-operations for DBHome patching October 30, 2021 1:52:30 PM EDT October 30, 2021 1:52:47 PM EDT Success [[email protected] ~]# [[email protected] ~]# dbcli describe-job -i zzzzzzzz-zzzz-zzzz-zzzz-zzzzzzzzzzzz -l Verbose Job details ---------------------------------------------------------------- ID: zzzzzzzz-zzzz-zzzz-zzzz-zzzzzzzzzzzz Description: DBHome Patching: Home ID is bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb Status: Success Created: October 30, 2021 1:38:53 PM EDT Progress: 100% Message: Task Name Start Time End Time Status ------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ---------- DBHome Patching October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success DBHome Patching October 30, 2021 1:38:53 PM EDT October 30, 2021 1:52:47 PM EDT Success DBHome Patching October 30, 2021 1:38:53 PM EDT October 30, 2021 1:52:47 PM EDT Success DBHome Patching October 30, 2021 1:38:53 PM EDT October 30, 2021 1:52:47 PM EDT Success Pre-operations for DBHome patching October 30, 2021 1:38:53 PM EDT October 30, 2021 1:40:08 PM EDT Success Starting Pre-Patching of dbHome bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success task:TaskParallel_4373 October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success Deleting patching Dirs October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success task:TaskSequential_4376 October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success Create patching repository directories[ocilabhost01] October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success task:TaskSequential_4379 October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success Download latest patch metadata[ocilabhost01] October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success task:TaskParallel_4382 October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success checking GiHome version[ocilabhost01] October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success task:TaskSequential_4385 October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success Update System version[ocilabhost01] October 30, 2021 1:38:53 PM EDT October 30, 2021 1:38:53 PM EDT Success task:TaskSequential_4388 October 30, 2021 1:38:53 PM EDT October 30, 2021 1:40:06 PM EDT Success Update Patching Repository[ocilabhost01] October 30, 2021 1:38:53 PM EDT October 30, 2021 1:40:06 PM EDT Success task:TaskSequential_4391 October 30, 2021 1:40:06 PM EDT October 30, 2021 1:40:06 PM EDT Success Space checks[ocilabhost01] October 30, 2021 1:40:06 PM EDT October 30, 2021 1:40:06 PM EDT Success task:TaskParallel_4394 October 30, 2021 1:40:06 PM EDT October 30, 2021 1:40:06 PM EDT Success Cleanup unwanted clones October 30, 2021 1:40:06 PM EDT October 30, 2021 1:40:06 PM EDT Success task:TaskParallel_4397 October 30, 2021 1:40:06 PM EDT October 30, 2021 1:40:08 PM EDT Success Save PDBs state October 30, 2021 1:40:06 PM EDT October 30, 2021 1:40:08 PM EDT Success Ending Pre-Patching of dbHome bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb October 30, 2021 1:40:08 PM EDT October 30, 2021 1:40:08 PM EDT Success DBHome patching October 30, 2021 1:40:08 PM EDT October 30, 2021 1:52:30 PM EDT Success Starting Patching of dbHome bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb October 30, 2021 1:40:08 PM EDT October 30, 2021 1:40:08 PM EDT Success task:TaskParallel_4405 October 30, 2021 1:40:08 PM EDT October 30, 2021 1:40:12 PM EDT Success Opatch updation[ocilabhost01] October 30, 2021 1:40:08 PM EDT October 30, 2021 1:40:12 PM EDT Success task:TaskSequential_4408 October 30, 2021 1:40:12 PM EDT October 30, 2021 1:42:48 PM EDT Success Patch conflict check[ocilabhost01] October 30, 2021 1:40:12 PM EDT October 30, 2021 1:42:48 PM EDT Success task:TaskParallel_4411 October 30, 2021 1:42:48 PM EDT October 30, 2021 1:42:48 PM EDT Success Setting owner to patching Dirs October 30, 2021 1:42:48 PM EDT October 30, 2021 1:42:48 PM EDT Success task:TaskSequential_4414 October 30, 2021 1:42:48 PM EDT October 30, 2021 1:52:30 PM EDT Success task:TaskSequential_4415 October 30, 2021 1:42:48 PM EDT October 30, 2021 1:52:30 PM EDT Success DB: Applying DBHome patch[ocilabhost01] October 30, 2021 1:42:48 PM EDT October 30, 2021 1:52:30 PM EDT Success Ending Patching of dbHome bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb October 30, 2021 1:52:30 PM EDT October 30, 2021 1:52:30 PM EDT Success Post-operations for DBHome patching October 30, 2021 1:52:30 PM EDT October 30, 2021 1:52:47 PM EDT Success Starting Post-Patching of dbHome bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb October 30, 2021 1:52:30 PM EDT October 30, 2021 1:52:30 PM EDT Success SqlPatch upgrade October 30, 2021 1:52:30 PM EDT October 30, 2021 1:52:41 PM EDT Success task:TaskParallel_4425 October 30, 2021 1:52:41 PM EDT October 30, 2021 1:52:44 PM EDT Success Updating DbHome version October 30, 2021 1:52:41 PM EDT October 30, 2021 1:52:44 PM EDT Success task:TaskParallel_4428 October 30, 2021 1:52:44 PM EDT October 30, 2021 1:52:46 PM EDT Success updating the Database version October 30, 2021 1:52:44 PM EDT October 30, 2021 1:52:46 PM EDT Success task:TaskParallel_4431 October 30, 2021 1:52:46 PM EDT October 30, 2021 1:52:47 PM EDT Success cleanup temp files October 30, 2021 1:52:47 PM EDT October 30, 2021 1:52:47 PM EDT Success task:TaskParallel_4434 October 30, 2021 1:52:47 PM EDT October 30, 2021 1:52:47 PM EDT Success Deleting patching Dirs October 30, 2021 1:52:47 PM EDT October 30, 2021 1:52:47 PM EDT Success Ending Post-Patching of dbHome bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb October 30, 2021 1:52:47 PM EDT October 30, 2021 1:52:47 PM EDT Success
With a final check of configured DB homes and components status by dbcli, we can now see that all the GB and DI patches are up to date:
### Database Home Configuration [[email protected] ~]# dbcli describe-dbhome -i bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb DB Home details ---------------------------------------------------------------- ID: bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb Name: OraDB11204_home1 Version: 11.2.0.4.210720 Home Location: /u01/app/oracle/product/11.2.0.4/dbhome_1 Status: Configured Created: October 27, 2021 8:08:26 AM EDT Database Edition: SE Unified Auditing: false ### Overall Database System Component Details [[email protected] ~]# dbcli describe-component System Version --------------- 21.2.3.0.0 Component Installed Version Available Version ---------------------------------------- -------------------- -------------------- GI 19.12.0.0.0 up-to-date DB 11.2.0.4.210720 up-to-date
I hope you find this post useful. Feel free to ask me questions in the comments.
If you haven’t already, sign up for my next post here.
No comments