Check the patches more in details with lsinventory details command
--on Windows:
%ORACLE_HOME%\opatch\opatch lsinventory -details
--on linux
$ORACLE_HOME/OPatch/opatch lsinventory -details
Check Patches from SQLPLUS by connecting with SYSDBA
-- For upto 11g
COLUMN action_time FORMATA20COLUMN action FORMATA20COLUMN version FORMATA10COLUMN comments FORMATA30COLUMN bundle_series FORMATA10SELECTTO_CHAR(action_time,'DD-MON-YYYY HH24:MI:SS')AS action_time,
action,
version, id, comments, bundle_series
FROM sys.registry$history
ORDER by action_time;
--From 12c onwards
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, version, status, Action,Action_time from dba_registry_sqlpatch order by action_time;
Check patch is applied or not withDBMSpackage
List the patches applied in Oracle Database
Go to directory CD %ORACLE_HOME%\OPatch opatch lspatches
List the patches with lsinventory
-- on Windows system:
CD %ORACLE_HOME%\OPatch opatch lsinventory
--On Linux
$ORACLE_HOME/OPatch/opatch lsinventory|grep "Patch description"
Check the patches more in details with lsinventory details command
--on Windows:
%ORACLE_HOME%\opatch\opatch lsinventory -details
--on linux
$ORACLE_HOME/OPatch/opatch lsinventory -details
Check Patches from SQLPLUS by connecting with SYSDBA
-- For upto 11g
COLUMN action_time FORMAT A20 COLUMN action FORMAT A20 COLUMN version FORMAT A10 COLUMN comments FORMAT A30 COLUMN bundle_series FORMAT A10 SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time, action, version, id, comments, bundle_series FROM sys.registry$history ORDER by action_time;
--From 12c onwards
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, version, status, Action,Action_time from dba_registry_sqlpatch order by action_time; Check patch is applied or not with DBMS package
--- Put patch number which you want to check
select xmltransform(dbms_qopatch.is_patch_installed('29494060'),dbms_qopatch.get_opatch_xslt) "Patch installed?" from dual; Check all patches applied from DBMS set serverout on; exec dbms_qopatch.get_sqlpatch_status;