Check DBA Registry and Patch Version status in CDB/PDB environment

Check DBA_REGISTRY Component Version/Status

COL comp_id for a15
COL status for a10
COL version for a15
COL comp_name for a40
SELECT con_id,SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10) version, SUBSTR(comp_name,1,40) comp_name FROM cdb_registry;

Check the Patching Registry Version/Status

COL action_time for a20
COL action for a10
COL status for a10
select con_id,TO_CHAR(action_time,'YYYY-MM-DD HH24:MI') action_time,PATCH_UID,PATCH_ID,PATCH_TYPE,SUBSTR(action,1,10) ACTION,SOURCE_VERSION,TARGET_VERSION,SUBSTR(status,1,10) status,DESCRIPTION,logfile from cdb_registry_sqlpatch ORDER by TO_CHAR(cdb_registry_sqlpatch.action_time,'YYYY-MM-DD HH24:MI') desc;