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

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;
This entry was posted in Oracle on by .

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.