Acronym -
OCI - Oracle Cloud Infrastructure
Intro
Security is a major concern in current data era and value of the data is getting higher in every minute .To keep the data secured , organization are trying hard to meet the industry standard compliance scores for their systems. database security plays a major role in any organization. To address these vulnerabilities organizations needs to be proactive to update their systems with the latest security patches. Significant part of the maintenance is applying the psu patches quarterly to meet the database compliance requirements. This process required considerable amount of time to stage the patches and test in lower environments.
OCI enables really stable automation to all the maintenance work such as patching , creating homes and server os patching etc ... .Also oracle has ease this task by taking the responsibility of staging .
In-addition, there are many tools introduced by oracle for addressing these work , major tools are
1. dbaascli
2. exacli
3. dbcli
4. exadbcpatchmulti
To easy the work on bare metal and vm server patching in OCI introduces new tool called dbcli.
We have two ways of patching the database:
In this article I will illustrate about the commands line patching using dbcli.
We have two ways of patching the database:
- Oracle Cloud GUI
- Command line tool
In this article I will illustrate about the commands line patching using dbcli.
Now we
will discuss about the steps and best practices for vm patching.
This patching
includes server , db and grid components.
1. Gather environment details
First we need to gather environment details using dbcli toolList database details
[root@dbsdpl21 ~]# dbcli list-databases
ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID
---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------
08bae22b-c9c6-4fdf-b90e-894e43d3b431 PWSH01 Rac 19.11.0.0.0 true Oltp ASM Configured 42935588-54f1-4f08-98cb-5f95d95cb881
List of database homes
[root@dbsdpl21 ~]# dbcli list-dbhomes
ID Name DB Version Home Location Status
---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
42935588-54f1-4f08-98cb-5f95d95cb881 OraDB19000_home1 19.11.0.0.0
List storages
[root@dbsdpl21 ~]# dbcli list-dbstorages
ID Type DBUnique Name Status
---------------------------------------- ------ -------------------- ----------
60728c08-a03e-409e-80cc-6bea218efc79 Asm PWSH01_yyz16x Configured
List components
[root@dbsdpl21 ~]# 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 19.11.0.0.0 19.12.0.0
List storages
[root@dbsdpl21 ~]# dbcli list-dbstorages
ID Type DBUnique Name Status
---------------------------------------- ------ -------------------- ----------
60728c08-a03e-409e-80cc-6bea218efc79 Asm PWSH01_yyz16x Configured
We need to identify which psu are available to patch. dbcli describe-latestpatch will display the currently patches. Oracle will stage these patches for us, ease our work on staging.
[root@dbsdpl21 ~]# dbcli describe-latestpatch
componentType availableVersion
--------------- --------------------
gi 12.2.0.1.210720
gi 12.1.0.2.210720
gi 18.15.0.0.0
gi 19.12.0.0.0
gi 21.3.0.0.0
db 11.2.0.4.210720
db 12.2.0.1.210720
db 12.1.0.2.210720
db 18.15.0.0.0
db 19.12.0.0.0
db 21.3.0.0.0
[root@dbsdpl21 ~]#
dbcli -h commands gives all the possible commands that we can execute this tool.
Also if you are not sure about commands still can check the options using dbcli
[root@dbsdpl21 ~]# dbcli update-dbhome -h -- check the update-home options
Usage: update-dbhome [options]
Options:
--cloneOcid, -o
clone OCID
--cloneType, -cc
Clone type
--cloneVersion, -cv
cloneVersion
* --dbhomeid, -i
Db home to be updated
--help, -h
get help
--json, -j
json output
--local, -l
Update Db home Locally
--node, -n
Node to be updated
--parUrl, -pu
par Url
--precheck, -p
Only Analyze the patch
--sha256sum, -ss
sha256sum
--version, -v
Patch version to be updated
Patching Prechecks
OCI vm server patching consist 3 major components.
- Server patching (updating the os version)
- Grid patching
- DB Patching
1. Pre-requisites
Access to the Oracle Cloud Infrastructure Object Storage service,including connectivity to the applicable Swift endpoint for Object Storage.
Oracle recommend using Service Gateway to enable this access.
- /u01 FS with at least 15Gb of free space
- Clusterware should be up and running
- All DB system nodes running
Backup
Backup your database prior to the patch event.
Non Prod first
Test this patch on non prod (or test) server first
Patching
Before performing patching run pre check commands to validate the environment with these patches.Also make sure to update the cliadm before patching..
I always recommend to patch standby database first before moving to prod.
[root@dbsdpl251 ~]# cliadm update-dbcli
Job details
----------------------------------------------------------------
ID: 89f9b8b6-1955-43f8-855e-a5de265bfa44
Description: DcsCli patching
Status: Created
Created: October 21, 2021 6:42:06 PM UTC
Message: Dcs cli will be updated
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
List Running Jobs
[root@dbsdpl251 ~]# dbcli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
ae6866f3-d990-47e9-8e98-ba2620355ec2 Provisioning service creation Friday, October 15, 2021, 19:49:31 UTC Success
1d1c9757-69ec-4e3b-a203-f0286ca55122 Authentication key update for DCS_ADMIN Friday, October 15, 2021, 20:30:54 UTC Success
bfc170d1-a6f4-4df5-837a-f70c7b982953 Infra upgrade Friday, October 15, 2021, 20:31:42 UTC Success
f7a6e930-6e33-4c90-bb79-5791fe5b805b Authentication key update for DCS_ADMIN Friday, October 15, 2021, 20:31:48 UTC Success
6d2a0753-047d-4e72-8c6d-e6abe27a15a6 Infra upgrade Friday, October 15, 2021, 20:31:50 UTC Success
dc1b0f78-7292-4b3c-a47b-b60e30ccfcda SSH keys update Friday, October 15, 2021, 20:33:26 UTC Success
03b9fed6-a69a-4263-89dc-a1497b94599b Manage AHF telemetry Friday, October 15, 2021, 20:34:54 UTC Success
5d5ec39b-2cd6-4666-be3e-a16e378a9c51 Manage AHF telemetry Friday, October 15, 2021, 20:35:19 UTC Success
691faa9f-586c-4a09-9f2f-7e8caae8b0d4 SSH key delete Friday, October 15, 2021, 20:35:23 UTC Success
b6154703-23a0-47b0-8508-b75bbe1d2e20 SSH key delete Friday, October 15, 2021, 20:35:31 UTC Success
d9c5168c-3272-49b9-b360-afe7dbe209d7 DG Config service creation Friday, October 15, 2021, 20:41:54 UTC Success
b8a249cb-f0f3-45f1-9e51-a7ad9a645902 Dataguard new status creation Friday, October 15, 2021, 20:56:24 UTC Success
1cce75d2-c5ce-4fe3-8f5c-26022e6cf5b8 Server Patching Prechecks Thursday, October 21, 2021, 18:11:01 UTC Success
eb316d24-72b6-4880-9213-755df5a5f691 DBHome Prechecks Thursday, October 21, 2021, 18:26:19 UTC Success
89f9b8b6-1955-43f8-855e-a5de265bfa44 DcsCli patching Thursday, October 21, 2021, 18:42:06 UTC Success
[root@dbsdpl251 ~]#
1.1 Update cliadm
Check patching status cliadm
[root@dbsdpl251 ~]# dbcli describe-job -i 89f9b8b6-1955-43f8-855e-a5de265bfa44
Job details
----------------------------------------------------------------
ID: 89f9b8b6-1955-43f8-855e-a5de265bfa44
Description: DcsCli patching
Status: Success
Created: October 21, 2021 6:42:06 PM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
[root@dbsdpl251 ~]#
1.2 Server Precheck
Execute Server precheck
[root@dbsdpl21 ~]# dbcli update-server --precheck
{
"jobId" : "053f8b83-d4d0-4560-9004-ec13d78f1bc0",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "October 15, 2021 19:22:14 PM UTC",
"resourceList" : [ ],
"description" : "Server Patching Prechecks",
"updatedTime" : "October 15, 2021 19:22:14 PM UTC",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
This is really convenient feature , once you execute this it will automatically run in background . Status can be checked from describing the job id. For each job there will be unique job id.
[root@dbsdpl21 ~]# dbcli describe-job -i 053f8b83-d4d0-4560-9004-ec13d78f1bc0
Job details
----------------------------------------------------------------
ID: 053f8b83-d4d0-4560-9004-ec13d78f1bc0
Description: Server Patching Prechecks
Status: Running
Created: October 15, 2021 7:22:14 PM UTC
Progress: 0%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching
1.3 DB Precheck
Execute DB Precheck
[root@dbsdpl21 ~]# dbcli update-dbhome -i 42935588-54f1-4f08-98cb-5f95d95cb881 --precheck
{
"jobId" : "60b6303f-a92d-4aec-b1f3-dcad87630f09",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "October 15, 2021 17:41:34 PM UTC",
"resourceList" : [ ],
"description" : "DBHome Prechecks",
"updatedTime" : "October 15, 2021 17:41:34 PM UTC",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
-- While it's running
[root@dbsdpl21 ~]# dbcli describe-job -i 60b6303f-a92d-4aec-b1f3-dcad87630f09
Job details
----------------------------------------------------------------
ID: 60b6303f-a92d-4aec-b1f3-dcad87630f09
Description: DBHome Prechecks
Status: Running
Created: October 15, 2021 5:41:34 PM UTC
Progress: 33%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for DBHome patching October 15, 2021 5:41:35 PM UTC October 15, 2021 5:45:18 PM UTC Success
DBHome patching October 15, 2021 5:45:18 PM UTC October 15, 2021 5:45:18 PM UTC Running
--- Precheck complete
[root@dbsdpl21 ~]# dbcli describe-job -i 60b6303f-a92d-4aec-b1f3-dcad87630f09
Job details
----------------------------------------------------------------
ID: 60b6303f-a92d-4aec-b1f3-dcad87630f09
Description: DBHome Prechecks
Status: Success
Created: October 15, 2021 5:41:34 PM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for DBHome patching October 15, 2021 5:41:35 PM UTC October 15, 2021 5:45:18 PM UTC Success
DBHome patching October 15, 2021 5:45:18 PM UTC October 15, 2021 5:55:45 PM UTC Success
Post-operations for DBHome patching October 15, 2021 5:55:45 PM UTC October 15, 2021 5:56:27 PM UTC Success
Install object store swift module October 15, 2021 5:55:51 PM UTC October 15, 2021 5:56:26 PM UTC Success
2. Patching
-– rolling fashion
Patching happen in rolling fashion.
This server patch includes with grid patching.
2.1 Server Patching
[root@dbsdpl251 ~]# dbcli update-server
{
"jobId" : "4b5e32fe-bd08-4684-b49d-9361c444b45a",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "October 21, 2021 18:46:16 PM UTC",
"resourceList" : [ ],
"description" : "Server Patching",
"updatedTime" : "October 21, 2021 18:46:16 PM UTC",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
[root@dbsdpl251 ~]#
Check status
[root@dbsdpl251 ~]# dbcli describe-job -i 4b5e32fe-bd08-4684-b49d-9361c444b45a
Job details
----------------------------------------------------------------
ID: 4b5e32fe-bd08-4684-b49d-9361c444b45a
Description: Server Patching
Status: Running
Created: October 21, 2021 6:46:16 PM UTC
Progress: 0%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching October 21, 2021 6:46:16 PM UTC October 21, 2021 6:46:16 PM UTC Running
[root@dbsdpl251 ~]#
Update status
[root@dbsdpl251 ~]# dbcli describe-job -i 4b5e32fe-bd08-4684-b49d-9361c444b45a
Job details
----------------------------------------------------------------
ID: 4b5e32fe-bd08-4684-b49d-9361c444b45a
Description: Server Patching
Status: Running
Created: October 21, 2021 6:46:16 PM UTC
Progress: 28%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching October 21, 2021 6:46:16 PM UTC October 21, 2021 6:48:07 PM UTC Success
Server Patching October 21, 2021 6:48:07 PM UTC October 21, 2021 6:48:07 PM UTC Running
[root@dbsdpl251 ~]#
2.2 Server patching failures.
While performing the server patch , patched failed due to conflicts .
In this senario best option is to raise a SR with oracle and get the work plan. There can be change oracle will provide merge patch to address some of the bugs.
root@dbsdpl251 ~]# dbcli describe-job -i 4b5e32fe-bd08-4684-b49d-9361c444b45a
Job details
----------------------------------------------------------------
ID: 4b5e32fe-bd08-4684-b49d-9361c444b45a
Description: Server Patching
Status: Failure
Created: October 21, 2021 6:46:16 PM UTC
Progress: 42%
Message: DCS-10001:Internal error encountered: Failure : failed to apply 32904851 on /u01/app/19.0.0.0/grid.
Cause: This is an internal error.
Action: Contact Oracle Support Services for assistance.
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Server Patching October 21, 2021 6:46:16 PM UTC October 21, 2021 7:11:58 PM UTC Failure
Pre-operations for Server Patching October 21, 2021 6:46:16 PM UTC October 21, 2021 6:48:07 PM UTC Success
Server Patching October 21, 2021 6:48:07 PM UTC October 21, 2021 7:11:58 PM UTC Failure
task:TaskSequential_4802 October 21, 2021 6:48:08 PM UTC October 21, 2021 7:11:58 PM UTC Failure
task:TaskSequential_4861 October 21, 2021 6:56:25 PM UTC October 21, 2021 7:11:58 PM UTC Failure
task:TaskSequential_4862 October 21, 2021 6:56:25 PM UTC October 21, 2021 7:11:58 PM UTC Failure
GI: Applying clusterware patch[dbsdpl251] October 21, 2021 6:56:25 PM UTC October 21, 2021 7:11:58 PM UTC Failure
[root@dbsdpl251 ~]#
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.0.0.0/grid, host: dbsdpl251.
Command failed: /u01/app/19.0.0.0/grid/OPatch/opatchauto apply /u01/odaPatchingTempDir/32895426 -oh /u01/app/19.0.0.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.0.0.0/grid/oraInst.loc -jre /u01/app/19.0.0.0/grid/OPatch/jre -persistresult /u01/app/19.0.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_dbsdpl251_crs_1.ser -analyze -online -prepare_home
Command failure output:
==Following patches FAILED in analysis for apply:
Patch: /u01/odaPatchingTempDir/32895426/32916816
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-10-21_19-10-44PM_1.log
Reason: Failed during Analysis: CheckConflictAgainstOracleHome Failed, [ Prerequisite Status: FAILED, Prerequisite output:
Summary of Conflict Analysis:
Patches that can be applied now without any conflicts are :
32904851, 32915586, 32918050
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
32847378, 32916816
Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
3258 ...
After fixing the cause of failure Run opatchauto resume
]]. Failures:
OPATCHAUTO-68067: Check the details to determine the cause of the failure.
at com.oracle.glcm.patch.auto.action.PatchActionExecutor.execute(PatchActionExecutor.java:172)
at com.oracle.glcm.patch.auto.wizard.silent.tasks.PatchActionTask.execute(PatchActionTask.java:102)
... 2 more
2021-10-21 19:11:21,951 INFO [1] com.oracle.glcm.patch.auto.db.integration.model.productsupport.DBBaseProductSupport - Space available after session: 173521 MB
2021-10-21 19:11:21,996 SEVERE [1] com.oracle.glcm.patch.auto.OPatchAuto - OPatchAuto failed.
Troubleshooting
DCS logs are located under /opt/oracle mount point
======================
Patching Pre check log
======================
/opt/oracle/dcs/log/
Below mention url is really useful link to get understanding and troubleshooting this oci patching.
Patching Failures on Bare Metal and Virtual Machine DB Systems
Solution
############# rollback patch
[grid@dbsdpl251 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 32847378
Patch 32847378 : applied on Mon May 17 15:34:08 UTC 2021
Patch description: "OCW Interim patch for 32847378"
32847378, 29160462, 29248723, 28642469, 29003617, 29186091, 29169739
[grid@dbsdpl251 ~]$
$ORACLE_HOME/OPatch/opatch rollback -id 32847378
Once the rollback complete rerun the server patch again to start the patching.
[root@dbsdpl251 ~]# dbcli describe-job -i 98de8e8e-72f5-42dc-be10-dc4f4e267a39
Job details
----------------------------------------------------------------
ID: 98de8e8e-72f5-42dc-be10-dc4f4e267a39
Description: Server Patching
Status: Running
Created: November 3, 2021 7:27:52 PM UTC
Progress: 71%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching November 3, 2021 7:27:53 PM UTC November 3, 2021 7:30:10 PM UTC Success
Server Patching November 3, 2021 7:30:10 PM UTC November 3, 2021 7:30:10 PM UTC Running
--- Complete server patching.
[root@dbsdpl251 ~]# dbcli describe-job -i 98de8e8e-72f5-42dc-be10-dc4f4e267a39
Job details
----------------------------------------------------------------
ID: 98de8e8e-72f5-42dc-be10-dc4f4e267a39
Description: Server Patching
Status: Success
Created: November 3, 2021 7:27:52 PM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for Server Patching November 3, 2021 7:27:53 PM UTC November 3, 2021 7:30:10 PM UTC Success
Server Patching November 3, 2021 7:30:10 PM UTC November 3, 2021 8:47:14 PM UTC Success 2.4 DB Patching
Once the server patching completes , we can move the db patching. run the precheck command to verify the conflicts.
[root@dbsdpl251 ~]# dbcli update-dbhome -i dea9250b-3dc7-45d5-b60c-f143aef7c550 {
"jobId" : "ae119988-9c62-4707-942f-6ce1b61e10e8",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "November 08, 2021 17:27:01 PM UTC",
"resourceList" : [ ],
"description" : "DBHome Patching: Home ID is dea9250b-3dc7-45d5-b60c-f143aef7c550",
"updatedTime" : "November 08, 2021 17:27:02 PM UTC",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
db patching job completion details.
[root@dbsdpl251 ~]# dbcli describe-job -i ae119988-9c62-4707-942f-6ce1b61e10e8
Job details
----------------------------------------------------------------
ID: ae119988-9c62-4707-942f-6ce1b61e10e8
Description: DBHome Patching: Home ID is dea9250b-3dc7-45d5-b60c-f143aef7c550
Status: Success
Created: November 8, 2021 5:27:01 PM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for DBHome patching November 8, 2021 5:27:02 PM UTC November 8, 2021 5:28:59 PM UTC Success
DBHome patching November 8, 2021 5:28:59 PM UTC November 8, 2021 6:48:27 PM UTC Success
Post-operations for DBHome patching November 8, 2021 6:48:27 PM UTC November 8, 2021 6:48:35 PM UTC Success
[root@dbsdpl251 ~]#
{
"jobId" : "ae119988-9c62-4707-942f-6ce1b61e10e8",
"status" : "Created",
"message" : null,
"reports" : [ ],
"createTimestamp" : "November 08, 2021 17:27:01 PM UTC",
"resourceList" : [ ],
"description" : "DBHome Patching: Home ID is dea9250b-3dc7-45d5-b60c-f143aef7c550",
"updatedTime" : "November 08, 2021 17:27:02 PM UTC",
"percentageProgress" : "0%",
"cause" : null,
"action" : null
}
db patching job completion details.
[root@dbsdpl251 ~]# dbcli describe-job -i ae119988-9c62-4707-942f-6ce1b61e10e8
Job details
----------------------------------------------------------------
ID: ae119988-9c62-4707-942f-6ce1b61e10e8
Description: DBHome Patching: Home ID is dea9250b-3dc7-45d5-b60c-f143aef7c550
Status: Success
Created: November 8, 2021 5:27:01 PM UTC
Progress: 100%
Message:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Pre-operations for DBHome patching November 8, 2021 5:27:02 PM UTC November 8, 2021 5:28:59 PM UTC Success
DBHome patching November 8, 2021 5:28:59 PM UTC November 8, 2021 6:48:27 PM UTC Success
Post-operations for DBHome patching November 8, 2021 6:48:27 PM UTC November 8, 2021 6:48:35 PM UTC Success
[root@dbsdpl251 ~]#
Verification
Once the patching complete on grid use dbcli describe-component to verify the component.
[root@dbsdpl251 ~]# 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 19.11.0.0.0 19.12.0.0
[root@dbsdpl251 ~]#
[root@dbsdpl252 ~]# 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 19.11.0.0.0 19.12.0.0
[root@dbsdpl252 ~]#
Verify the db component patch using dbcli describe-component. It should display as up-to-date.
[root@dbsdpl251 ~]# dbcli describe-component
System Version
---------------
21.3.2.2.0
Component Installed Version Available Version
---------------------------------------- -------------------- --------------------
GI 19.13.0.0.0 up-to-date
DB 19.13.0.0.0 up-to-date
As a practice I used to check from opatch lsinventory.
export GI=/u01/app/19.0.0.0/grid
export OH=/u01/app/oracle/product/19.0.0.0/dbhome_1
/u01/app/19.0.0.0/grid/OPatch/opatch lsinventory -oh $GI | grep ^Patch << to collect data at end.
/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lsinventory -oh $OH | grep ^Patch << to collect data at end.
===================
node01
===================
[grid@dbsdpl251 ~]$ /u01/app/19.0.0.0/grid/OPatch/opatch lsinventory -oh $GI | grep ^Patch
Patch 33197296 : applied on Mon Nov 08 16:43:36 UTC 2021
Patch description: "JDK BUNDLE PATCH 19.0.0.0.211019"
Patch 33239955 : applied on Mon Nov 08 16:37:08 UTC 2021
Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (33239955)"
Patch 33208123 : applied on Mon Nov 08 16:35:21 UTC 2021
Patch description: "OCW RELEASE UPDATE 19.13.0.0.0 (33208123)"
Patch 33208107 : applied on Mon Nov 08 16:33:19 UTC 2021
Patch description: "ACFS RELEASE UPDATE 19.13.0.0.0 (33208107)"
Patch 33192793 : applied on Mon Nov 08 16:27:13 UTC 2021
Patch description: "Database Release Update : 19.13.0.0.211019 (33192793)"
Patch 31732095 : applied on Mon May 17 15:26:17 UTC 2021
Patch description: "UPDATE PERL IN 19C DATABASE ORACLE HOME TO V5.32"
Patch 32585572 : applied on Mon May 17 15:22:03 UTC 2021
Patch description: "DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572)"
[grid@dbsdpl251 ~]$
[oracle@dbsdpl251 ~]$ export OH=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@dbsdpl251 ~]$ /u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatch lsinventory -oh $OH | grep ^Patch
Patch 33028462 : applied on Mon Nov 08 18:12:27 UTC 2021
Patch description: "FAILOVER FAILED FOR MAX AVAILABILITY + FAST SYNC MODE FOR ALL DB VERSIONS"
Patch 29780459 : applied on Mon Nov 08 18:10:30 UTC 2021
Patch description: "INCREASE _LM_RES_HASH_BUCKET AND BACK OUT CHANGES FROM THE BUG 29416368 FIX"
Patch 33197296 : applied on Mon Nov 08 18:08:57 UTC 2021
Patch description: "JDK BUNDLE PATCH 19.0.0.0.211019"
Patch 33208123 : applied on Mon Nov 08 18:04:47 UTC 2021
Patch description: "OCW RELEASE UPDATE 19.13.0.0.0 (33208123)"
Patch 33192793 : applied on Mon Nov 08 17:58:14 UTC 2021
Patch description: "Database Release Update : 19.13.0.0.211019 (33192793)"
Patch 32327201 : applied on Tue May 04 03:29:07 UTC 2021
Patch description: "RDBMS - DSTV36 UPDATE - TZDATA2020E"
Patch 31335037 : applied on Tue May 04 03:27:51 UTC 2021
Patch description: "RDBMS - DSTV35 UPDATE - TZDATA2020A"
Patch 30432118 : applied on Tue May 04 03:26:37 UTC 2021
Patch description: "MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937"
Patch 31732095 : applied on Tue May 04 03:25:16 UTC 2021
Patch description: "UPDATE PERL IN 19C DATABASE ORACLE HOME TO V5.32"
Patch 32399816 : applied on Tue May 04 03:20:20 UTC 2021
Patch description: "OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816)"
[oracle@dbsdpl251 ~]$
No comments:
Post a Comment