Forum Stats

  • 3,767,949 Users
  • 2,252,733 Discussions
  • 7,874,388 Comments

Discussions

How to create report of current PSU patches across all databases from OEM.

User_A65N5
User_A65N5 Member Posts: 2 Red Ribbon
edited Feb 7, 2020 9:35AM in Enterprise Manager

How to create report of current PSU patches across all databases

I want to take out an report which should give list of all database current PSU patches version from OEM.

Regards

Mohammed

Mukhtar Ahmad

Best Answer

Answers

  • Venkata Thiruveedhi-Oracle
    Venkata Thiruveedhi-Oracle Posts: 590 Employee
    edited Jan 17, 2020 7:18AM

    Hi Mohammed,

    You would like to take a report of all the targets monitored in EM and their PSU Patch levels.

    Correct me if my understanding is correct!!

    If yes!! Then you can fetch this details from the following navigation:

    Enterprise  -->  Configuration  -->  Inventory and Usage Details

    Under Summary  -->  Select "Databases" from the dropdown and that should list all the Databases along with their Patch levels under "Selection Details: Databases" section.

    Here you can export the content in an xls file which should be helpful for your report.

    Best Regards,

    Venkat

    Mukhtar Ahmad
  • User_A65N5
    User_A65N5 Member Posts: 2 Red Ribbon
    edited Jan 17, 2020 7:48AM

    Thanks for reply Venkata.

    The above you suggested gives me the list of DB and Oracle version but not the latest patches applied on those databases . Is there any similar report where i can find the latest patch applied on the database something similar to  output when we do opatch lsinventory.

  • Venkata Thiruveedhi-Oracle
    Venkata Thiruveedhi-Oracle Posts: 590 Employee
    edited Jan 17, 2020 8:06AM Accepted Answer

    Hi,

    NO!! We do not have any default report available to get that information.

    select HOST_NAME, TARGET_NAME, PATCH_ID, PATCH_TYPE, PATCH_PRODUCT from MGMT$PR_APPL_PATCHES_TO_OH_TGT where PATCH_PRODUCT = 'Oracle Database';

    Listed below are the contents of the MGMT$PR_APPL_PATCHES_TO_OH_TGT view:


    SQL> desc MGMT$PR_APPL_PATCHES_TO_OH_TGT
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    PATCH_GUID RAW(16)
    PATCH_ID NUMBER
    PATCH_TYPE VARCHAR2(64)
    PATCH_PRODUCT VARCHAR2(512)
    PATCH_PLATFORM VARCHAR2(512)
    PATCH_RELEASE VARCHAR2(40)
    HOST_GUID NOT NULL RAW(16)
    HOST_NAME NOT NULL VARCHAR2(256)
    HOME_LOCATION VARCHAR2(1024)
    TARGET_GUID NOT NULL RAW(16)
    TARGET_NAME NOT NULL VARCHAR2(256)
    TARGET_TYPE NOT NULL VARCHAR2(64)

    You have to use the above query and create a report in EM by yourself.

    Reference:
    https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.3.1/emadm/custom-reports.html#GUID-1A823D73-48B8-4A8D-B260-8D7CD66F7DF8

    Best Regards,

    Venkat

    Mukhtar Ahmad