======Overview======
Updates in Oracle Enterprise Manager Cloud control can be done in two ways:

  * Online - Requires Access to the Oracle support
  * Offline - Download the software and upload it to the OMS and the target host


======Offline======
Since oracle goes backwards to common sense. In 12c+ we have to upload the latest catalog (that is latest versions of agents, plugins and so on) to the OMS.

It is important to mention that the catalog doesn't contain the software itself, but rather only list of them with the location of the location to download them.

So let's update the catalog:

=====Catalog Update=====
I spent A LOT OF TIME to find the location to download the files, but in nutshell you have to download the latest update from:
https://updates.oracle.com/Orion/Download/download_patch/p9348486_112000_Generic.zip


That link can be found in:

https://docs.oracle.com/cd/E73210_01/EMADM/GUID-ECA444F6-88B3-436D-8B96-F65581AD2E2E.htm#GUID-5DF33C50-59DD-4187-B769-D66E886EC1BB

After you upload the file to the OMS Host you can upload it to the OMS itself:

<sxh bash>
[oracle@tbp-cx-oms01 oradata]$ emcli login -username=sysman
Enter password

Login successful
[oracle@tbp-cx-oms01 oradata]$ emcli sync
Synchronized successfully
[oracle@tbp-cx-oms01 oradata]$ emcli import_update_catalog -file="/app/oradata/p9348486_112000_Generic.zip" -omslocal



Processing catalog for Agent Software
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for HP-UX PA-RISC (64-bit)
************************************************************************************************
Processing catalog for Compliance Content
Processing update: Compliance Content - Compliance Framework - Security Technical Implementation Guides (STIGs)
Processing update: Compliance Content - Compliance Standard - Security Technical Implementation Guide (STIG Version 1.1) for Oracle WebLogic Server 12c
Processing catalog for Informational
Processing update: Informational - Announcing New and Updated Cloud Management Capabilites for Database, Infrastructure, and Testing
Processing update: Informational - Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (12.1.0.2) now available on OTN
Processing update: Informational - Enterprise Manager Cloud Control 12C white papers available now on Oracle Technology Network
Processing update: Informational - Integration of Oracle Business Intelligence (BI) Publisher 11.1.1.5.0 with Enterprise Manager Cloud Control 12.1.0.1
Processing update: Informational - Management of Oracle VM 3.1.1 now available with Oracle Enterprise Manager 12c
Processing update: Informational - Oracle Enterprise Manager Cloud Control Mobile now available for Apple iPhone
Processing catalog for Provisioning Bundle
Processing catalog for Event Monitoring Service
Processing update: Event Monitoring Service - Always-On Monitoring Archive
Processing catalog for Diagnostic Tools

Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.
Time taken for import catalog is 01:12.897.
[oracle@tbp-cx-oms01 oradata]$
[oracle@tbp-cx-oms01 oradata]$
</sxh>

After the catalog has been updated we can download the software itself. In our case, we will manually upload the agent.
The upload of the agent is used to distribute that agent centrally to other hosts.

In our case we will upload teh SQL Server Agent.

=====Agent Update=====
The agents are usually big files compared to the plugins. For example the windows plugin is ~600 MBs

<sxh bash>
[oracle@tbp-cx-oms01 ~]$ emcli login -username=sysman
Enter password :
Login successful
[oracle@tbp-cx-oms01 ~]$ emcli sync
Synchronized successfully
[oracle@tbp-cx-oms01 oradata]$ emcli import_update -omslocal -file=/app/oradata/p28239183_112000_Generic.zip
Processing update: Agent Software - Agent Software (13.3.0.0.0) for Microsoft Windows x64 (64-bit)
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.
[oracle@tbp-cx-oms01 oradata]$
</sxh>

Since we are doing it, let's do also plugin:

=====Plugin Update=====
Once we update the catalog, navigate to oms:

  * Settings -> Extensability -> Self Update
  * Self Update -> Plugins -> SQL Server -> Download

Once you press the Download, the OMS will show you the following message:

{{:oms_plugin_sqlserver.jpg?400|}}


After you download the file and upload it on the OMS server, we have to upload it to OMS as instructed:

<sxh bash>
[oracle@tbp-cx-oms01 ~]$ emcli login -username=sysman
Enter password :
Login successful
[oracle@tbp-cx-oms01 ~]$ emcli sync
Synchronized successfully
[oracle@tbp-cx-oms01 ~]$
[oracle@tbp-cx-oms01 OMS_Uploads]$ emcli import_update -omslocal -file=/app/oradata/OMS_Uploads/p27507741_112000_Generic.zip
Processing update: Plug-in - Enterprise Manager for Microsoft SQL Server
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.
[oracle@tbp-cx-oms01 OMS_Uploads]$
</sxh>

======Deployment======
After an agent or plugin has been uploaded, it has to be deployed on the OMS.
This is done using the following steps:

  * Settings -> Extensability -> Self Update
  * Self Update -> Navigate to the Product -> Deploy