scripts to check Patch details in database level

---------to check inventory ok or not-------------

select dbms_sqlpatch.verify_queryable_inventory from dual;

--------------------------------------------------------------------------------------------------------------------------
ORACLE12c check script
--------------------------------------------------------------------------------------------------------------------------
set pages 300;
set lines 300;
col VERSION format a10;
col STATUS format a10;
col ACTION_TIME format a20;
col DESCRIPTION format a80;

select PATCH_ID,PATCH_UID, VERSION,STATUS, ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;


--------------------------------------------------------------------------------------------------------------------------
ORACLE11G check script
--------------------------------------------------------------------------------------------------------------------------

set lines 300
set pages 300
col ACTION format a15
col NAMESPACE format a15
col version format a10
col COMMENTS format a42
col BUNDLE_SERIES format a20
col action_time format a30
select ACTION_TIME,ACTION,VERSION,ID,COMMENTS,BUNDLE_SERIES from sys.registry$history;


Thanks for your visit!
your comment and suggestions are more helpful in my future posts!