Check the Patch Applied to the Oracle Database

Find the date and patch number applied in Oracle Database.

List the patches applied in Oracle Database

Go to directory
opatch lspatches

List the patches with lsinventory

-- on Windows system:
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 comments FORMAT A30
COLUMN bundle_series FORMAT A10

SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
 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;

2 thoughts on “Check the Patch Applied to the Oracle Database

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 )

Twitter picture

You are commenting using your Twitter 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.