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 A20COLUMN action FORMAT A20COLUMN version FORMAT A10COLUMN comments FORMAT A30COLUMN bundle_series FORMAT A10SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,action, version, id, comments, bundle_seriesFROM sys.registry$historyORDER by action_time;
--From 12c onwards
col action_time for a28col action for a8col version for a8col comments for a30col status for a10set line 999 pages 999select 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;
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;