How To List Applied Patches in Oracle

dbtut

4 years ago

You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and earlier, and DBA_REGISTRY_SQLPATCH for databases 12c. You can get information about patches applied with a query like the following.

SQL> select * from DBA_REGISTRY_HISTORY;

1	SQL> select * from DBA_REGISTRY_HISTORY;

SQL> SET LINESIZE 400
SQL> COLUMN action_time FORMAT A20
SQL> COLUMN action FORMAT A10
SQL> COLUMN status FORMAT A10
SQL> COLUMN description FORMAT A40
SQL> COLUMN version FORMAT A10
SQL> COLUMN bundle_series FORMAT A10

SQL> SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
       action,
       status,
       description,
       version,
       patch_id,
       bundle_series
FROM   dba_registry_sqlpatch
ORDER by action_time;

SQL> SET LINESIZE 400

SQL> COLUMN action_time FORMAT A20

SQL> COLUMN action FORMAT A10

SQL> COLUMN status FORMAT A10

SQL> COLUMN description FORMAT A40

SQL> COLUMN version FORMAT A10

SQL> COLUMN bundle_series FORMAT A10

SQL> SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,

action,

status,

description,

version,

patch_id,

bundle_series

FROM dba_registry_sqlpatch

ORDER by action_time;