Patch History

Starting with Oracle Enterprise Manager 13.5 Release Update 21 (13.5.0.21) you can now access database patching history for update and upgrade operations in Fleet Maintenance.

Note:

Your environment's data retention policy dictates how far back Fleet Maintenance can show update and upgrade history.

Obtain Patch History Via EM CLI

• Read Patch History:

  emcli lcm_operations
  -getLcmHistory                
  -input_file="<path of the JSON file>"

  Where the input file contains the following:

   {
      "targetNames" : [<List of targets>],
      "targetType" : "oracle_database",
      "targetIds" : [<List of ID's>],
      "tasks" : ["update", "upgrade"],
      "timeStartedGreaterThanOrEqualTo" : "<Start date format YYYY-MM-DD HH:MM:SS>",
      "timeStartedLessThanOrEqualTo" : "<End date format YYYY-MM-DD HH:MM:SS>",
      "status" : "completed",
      "sort" : "targetType",
      "limit" : 100,
      "page" : "<Page ID>"
  }

• Export Patch History:

  emcli lcm_operations
  -exportLcmHistory                
  -input_file="<path of the JSON file>"

  Where the input file contains:

   { 
     "destinationHostName" : "<host name>",
     "destinationHostCredential" : "<host_cred>",
     "csvFileLocation" : "<CSV file path>",
     "csvFileName" : "<file_name.csv>"
     "targetNames" : [<list of targets>],
     "targetType" : "oracle_database",
     "targetIds" : [<list of ids>],
     "tasks" : ["update", "upgrade"],
     "timeStartedGreaterThanOrEqualTo" : "<Start date format YYYY-MM-DD HH:MM:SS",
     "timeStartedLessThanOrEqualTo" : "<End date format YYYY-MM-DD HH:MM:SS",
     "status" : "completed",
     "sort" : "targetType"
  }

Use the following EM CLI commands to read and export your Fleet Maintenance update and upgrade history:For a complete list of definitions and examples of the lcm_operations verb see: lcm_operations

Obtain Patch History Via REST API

For REST API see: Database Maintenance- Updates (Patching) And Upgrades REST Endpoints.