The new Oracle OEM Cloud Control 12.1.0.4 release migration makes it necessary for the DBA to migrate the old agent version to 12.1.0.4. If your infrastructure has a huge number of agents and if you want to apply the agent patches to the upgraded agents, this might be a very time-consuming job. However, there is a way to realize the operation in just one shot.

In my example, we have an agent in version 12.1.0.3:

oracle@vmtestfusion01:/u00/app/oracle/agent12c/core/12.1.0.3.0/OPatch/ [agent12c] ./opatch lsinventory

Oracle Interim Patch Installer version 11.1.0.10.0

Copyright (c) 2013, Oracle Corporation.

All rights reserved.

Oracle Home       : /u00/app/oracle/agent12c/core/12.1.0.3.0

Central Inventory : /u00/app/oraInventory

from           : /u00/app/oracle/agent12c/core/12.1.0.3.0/oraInst.loc

OPatch version   : 11.1.0.10.0

OUI version       : 11.1.0.11.0

Log file location : /u00/app/oracle/agent12c/core/12.1.0.3.0/cfgtoollogs/opatch/opatch2014-09-02_08-00-36AM_1.log

OPatch detects the Middleware Home as "/u00/app/oracle/Middleware/11g"

Lsinventory Output file location : /u00/app/oracle/agent12c/core/12.1.0.3.0/cfgtoollogs/opatch/lsinv/lsinventory2014-09-02_08-00-36AM.txt

Installed Top-level Products (1):EM Platform (Agent)                                                

12.1.0.3.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :Patch 10203435     : applied on Sat Jun 22 08:51:24 CEST 2013

Unique Patch ID: 15915936.1   Created on 7 Feb 2013, 18:06:13 hrs PST8PDT

Bugs fixed:     10203435

Patch 16087066     : applied on Sat Jun 22 08:51:22 CEST 2013

Unique Patch ID: 15928288  

Created on 4 Feb 2013, 04:52:18 hrs PST8PDT  

Bugs fixed:     13583799, 6895422

OPatch succeeded.

In the OMS environment, we have to download and copy the agent-side patches to $OMS_HOME/install/oneoffs/12.1.0.4.0/Generic.

In my example, I downloaded the 19002534 EM DB plugin bundle patch 12.1.0.6.1 (agent side):

oracle@vmtestoraem12c:/u01/app/oracle/MiddleWare_12cR4/oms/install/oneoffs/12.1.0.4.0/Generic/ [oms12c] ls

p19002534_121060_Generic.zip

The agent upgrade procedure will use this directory to apply the patch.

Let’s upgrade the agent from 12.1.0.3 to 12.1.0.4 by using the Cloud Control console:

ag1

Select the agent to be upgraded:

ag2_copy

The new job screen lists the different steps:

ag3_copy

In the log file we can visualize the patch:

Tue Sep 2 08:07:26 2014 -

Found following valid patch files from the patch location which will be considered in this patching session :

Tue Sep 2 08:07:26 2014 - p19002534_121060_Generic.zip

Tue Sep 2 08:07:26 2014 - /u00/app/oracle/agent12c/core/12.1.0.4.0/bin/unzip -o p19002534_121060_Generic.zip -d /u00/app/oracle/agent12c/oneoffs >> /u00/app/oracle/agent12c/core/12.1.0.4.0/cfgtoollogs/agentDeploy/applypatchesonapplicablehome2014-09-02_08-07-26.log 2>&1

Archive: p19002534_121060_Generic.zip  

creating: /u00/app/oracle/agent12c/oneoffs/19002534/  

creating: /u00/app/oracle/agent12c/oneoffs/19002534/etc/  

creating: /u00/app/oracle/agent12c/oneoffs/19002534/etc/config/

inflating: /u00/app/oracle/agent12c/oneoffs/19002534/etc/config/actions.xml

…………

By checking the agent inventory, we verify the new upgraded agent has received the EM DB PLUGIN BUNDLE PATCH 12.1.0.6.1:

[agent12c] opatch lsinventory -oh /u00/app/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.6.0/

Oracle Interim Patch Installer version 11.1.0.10.4

Copyright (c) 2014, Oracle Corporation. All rights reserved.

Oracle Home       : /u00/app/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.6.0

Central Inventory : /u00/app/oraInventory

   from          : /u00/app/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.6.0//oraInst.loc

OPatch version   : 11.1.0.10.4

OUI version       : 11.1.0.12.0

Log file location : /u00/app/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.6.0/cfgtoollogs/opatch/opatch2014-09-02_10-09-32AM_1.log

OPatch detects the Middleware Home as “/u00/app/oracle/Middleware/11g”

Lsinventory Output file location : /u00/app/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.6.0/cfgtoollogs/opatch/lsinv/lsinventory2014-09-02_10-09-32AM.txt

Installed Top-level Products (1):

Enterprise Manager plug-in for Oracle Database                       12.1.0.6.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 19002534     : applied on Tue Sep 02 10:05:37 CEST 2014

Unique Patch ID: 17759438

Patch description: “EM DB PLUGIN BUNDLE PATCH 12.1.0.6.1 (AGENT SIDE)”

   Created on 17 Jun 2014, 09:10:22 hrs PST8PDT

   Bugs fixed:

     19002534, 18308719

This feature is very useful for massive agent upgrades, because the agent is upgraded and, in the same operation, the bundle patch is applied. You are also able to use the patch plan to apply bundle patches to multiple agents in one operation.