Wednesday 18 May 2022

Oracle 12c/18 : How to find out if a PSU has been applied? DBMS_QOPATCH

PBMLOL>set serveroutput on
PBMLOL>exec dbms_qopatch.get_sqlpatch_status;

Patch Id : 28090523
        Action : APPLY
        Action Time : 12-MAY-2019 00:22:22
        Description : Database Release Update : 18.3.0.0.180717 (28090523)
        Logfile :
/u01/app/oracle/cfgtoollogs/sqlpatch/28090523/22329768/28090523_apply_MYDB_2019May12_00_21_46.log
        Status : SUCCESS

Patch Id : 27923415
        Action : APPLY
        Action Time : 12-MAY-2019 00:29:39
        Description : OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)
        Logfile :
/u01/app/oracle/cfgtoollogs/sqlpatch/27923415/22239273/27923415_apply_MYDB_2019May12_00_29_39.log
        Status : SUCCESS

PL/SQL procedure successfully completed.