Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we use the view MGMT$PR_APPL_PATCHES_TO_OH_TGT to check Patch Levels without having Lifecycle Ma

Sean WaltersSep 5 2018 — edited Sep 6 2018

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.

This post has been answered by Ian Baugaard on Sep 5 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2018

Added on Sep 5 2018

2 comments

404 views