Oracle Patching Guide

 col action_time for a28
col action for a8
col version for a8
col comments for a30
col status for a10
set line 999 pages 999
select patch_id, source_version,patch_type,target_version, status,Action_time from dba_registry_sqlpatch  order by action_time ;
=========================================================================
col action_time for a28;
col description for a80;
set line 999 pages 999;
select patch_id, action, description, action_time from dba_registry_sqlpatch order by action_time;
Output:
----------------
 PATCH_ID ACTION   DESCRIPTION                                                  ACTION_TIME
---------- -------- ------------------------------------------------------------ ----------------------------
  30869156 APPLY    Database Release Update : 19.7.0.0.200414 (30869156)         09-JUL-20 10.25.59.281935 AM
  30805684 APPLY    OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)              09-JUL-20 10.25.59.286150 AM
  31281355 APPLY    Database Release Update : 19.8.0.0.200714 (31281355)         22-JUL-20 01.30.47.736379 PM
  30805684 ROLLBACK OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)              22-JUL-20 01.36.22.283160 PM
  31219897 APPLY    OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)              22-JUL-20 01.36.22.287535 PM
***************************************************************************************************************
To check GRID PATCH VERSION:
$ps -ef | grep -i d.bin 
$ cd bin
/bin:$ 
./crsctl query crs releasepatch
./crsctl query crs activeversion
./crsctl query crs releaseversion
./crsctl query crs softwarepatch [node_name]
eg. ./crsctl query crs softwarepatch flpd670
./crsctl query crs softwareversion [node_name]
eg. ./crsctl query crs softwareversion flpd670
or login as oragrid ---> sqlplus / as sysadmin  ---> run SQL Query