2 Replies Latest reply on Sep 6, 2018 7:50 AM by 3242743

    Can we use the view MGMT$PR_APPL_PATCHES_TO_OH_TGT to check Patch Levels without having Lifecycle Management Pack ?

    3242743

      In OEM 11g it was trivial to see the overall patch levels for all ORACLE_HOME's on a single screen.

       

      In 12c and 13c this is no longer possible ( as far as I am aware)  and Oracle have a note showing how to do this using a query against the OEM repository.

           see  EM 13c, 12c: How to List the Patch Levels for Databases Monitored by Enterprise Manager Cloud Control with a SQL Query on the Repository Database? (Doc ID 2074168.1)

       

      The query runs against the MGMT$PR_APPL_PATCHES_TO_OH_TGT view however use of this this view requires the Lifecycle Management Pack according to

           Oracle Enterprise Manager Licensing Information User Manual 12c Release 5 (12.1.0.5) E24474-39

       

      Can Oracle confirm if it is OK to run the SQL identified in the note without this pack ?

      If not, I suggest Oracle update the note to detail this should only be used if you have the pack.

       

      Thanks.