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:
After you upload the file to the OMS Host you can upload it to the OMS itself:
[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]$
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
[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]$
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:
After you download the file and upload it on the OMS server, we have to upload it to OMS as instructed:
[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]$
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