Applying Oracle Enterprise Manager 13.4 RU 3

Oracle Enterprise Manager (EM) Release Update (RU) 3 for 13.4 version was released early this month.



In this post, I want to show you how to apply this RU to your Oracle Enterprise Manager environment.

Let me start by describing the environment that I’m using for this. Oracle Enterprise Manager 13.4 can be deployed both on-premises or in the Oracle Cloud (OCI). Oracle Enterprise Manager 13.4 is available in the OCI’s Marketplace. You have the ability to choose from both single-instance and multi-node EM deployment. This makes the process really straightforward and you can have an environment up and running with couple of clicks.



For this example I’m going to be using the on-premises option. This means that Oracle EM 13.4 is also available for download as a VirtualBox image. This image comes as a single-instance EM deployment. Is worth to mention that this image is not recommended for anything but for testing.



I assigned 16 Gb of RAM and 2 virtual CPUs to this VirtualBox VM. Follow the instructions in the README file and start your environment. I also downloaded patch 31299359 from MOS Doc ID 2647078.1

The overall steps are outlined below:

  1. Download and unzip patch 31299359
  2. Verify and make sure you meet the pre-reqs
  3. Stop the Oracle Management Service
  4. Apply the RU patch
  5. Start the Oracle Mangement Service

As I previously mentioned, I downloaded and staged the patch in the Oracle EM VM. Now, let’s make sure we meet the pre-reqs.

This patch requires OPatch to be version 13.9.4.2.2 or higher and OMSPatcher version 13.9.4.0.0 or higher.

$ export ORACLE_HOME=/u01/OracleHomes/Middleware
$ export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/OMSPatcher/
$ cd /u01/OracleHomes/Middleware/
$ cd OMSPatcher/
$ ./omspatcher version
OMSPatcher Version: 13.8.0.0.3
OPlan Version: 12.2.0.1.16
OsysModel build: Thu Oct 25 18:18:12 PDT 2018

OMSPatcher succeeded.
$ cd ../OPatch/
$ ./opatch version
OPatch Version: 13.9.4.2.2

OPatch succeeded.

As you can see from above output, we need to upgrade our OMSPatcher utility. Follow the instructions from MOS Doc ID 2646080.1.

After that, you will be ready to start patching.

$ ./omspatcher version
OMSPatcher Version: 13.9.4.1.0
OPlan Version: 12.2.0.1.16
OsysModel build: Thu Oct 25 18:18:12 PDT 2018

OMSPatcher succeeded.

Let’s now go to the directory where we are staging our patch and execute the OMSPatcher analyze command.

$ cd /home/oracle/Downloads/31299359/
$ omspatcher apply -analyze -property_file /home/oracle/property
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.9.4.1.0
OUI version        : 13.9.4.0.0
Running from       : /u01/OracleHomes/Middleware
Log file location  : /u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/opatch2020-06-08_11-54-31AM_1.log

OMSPatcher log file: /u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/31299359/omspatcher_2020-06-08_11-54-40AM_analyze.log

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "31187620,31187594,31140458,30851102,31189032,31187677,31193101,31187644,31187611,30851078,31187552,31187567" and Oracle Home "/u01/OracleHomes/Middleware"...
Sub-patch(es) "31187620,31187594,31140458,30851102,31189032,31187677,31193101,31187644,31187611,30851078,31187552,31187567" are successfully analyzed for Oracle Home "/u01/OracleHomes/Middleware"


Complete Summary
================


All log file names referenced below can be accessed from the directory "/u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/2020-06-08_11-54-31AM_SystemPatch_31299359_1"

Prerequisites analysis summary:
-------------------------------

The following sub-patch(es) are applicable:

             Featureset                                                                                                   Sub-patches                                                                                                                                        Log file
             ----------                                                                                                   -----------                                                                                                                                        --------
  oracle.sysman.top.oms   31187620,31187594,31140458,30851102,31189032,31187677,31193101,31187644,31187611,30851078,31187552,31187567   31187620,31187594,31140458,30851102,31189032,31187677,31193101,31187644,31187611,30851078,31187552,31187567_opatch2020-06-08_11-54-39AM_1.log



Log file location: /u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/31299359/omspatcher_2020-06-08_11-54-40AM_analyze.log

OMSPatcher succeeded.

After you validate that there are no conflicts. Proceed to shutdown the Oracle Management Service (OMS).

$ emctl stop oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down

And now let’s execute the OMSPatcher command to apply the RU patch.

$ omspatcher apply -property_file /home/oracle/property
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.9.4.1.0
OUI version        : 13.9.4.0.0
Running from       : /u01/OracleHomes/Middleware
Log file location  : /u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/opatch2020-06-08_14-45-59PM_1.log

OMSPatcher log file: /u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/31299359/omspatcher_2020-06-08_14-46-08PM_deploy.log                                                                                                                 

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "31187620,31187594,31140458,30851102,31189032,31187677,31193101,31187644,31187611,30851078,31187552,31187567" and Oracle Home "/u01/OracleHomes/Middleware"...                           
Sub-patch(es) "31187620,31187594,31140458,30851102,31189032,31187677,31193101,31187644,31187611,30851078,31187552,31187567" are successfully analyzed for Oracle Home "/u01/OracleHomes/Middleware" 
                         
...

Deployment summary:
-------------------

The following artifact(s) have been successfully deployed:

               Artifacts                                                      Log file
               ---------                                                      --------
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-06-36PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-11-28PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-12-13PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-13-02PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-13-35PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-14-08PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-14-47PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-15-21PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-15-57PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-16-44PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-17-33PM.log
                     SQL       rcu_applypatch_original_patch_2020-06-08_15-18-24PM.log
            MRS-commands             emctl_register_commands_2020-06-08_15-19-14PM.log
          MRS-procedures           emctl_register_procedures_2020-06-08_15-19-24PM.log
          MRS-procedures           emctl_register_procedures_2020-06-08_15-19-37PM.log
               MRS-swlib                emctl_register_swlib_2020-06-08_15-19-52PM.log
               MRS-swlib                emctl_register_swlib_2020-06-08_15-20-12PM.log
          MRS-targetType           emctl_register_targetType_2020-06-08_15-20-43PM.log
          MRS-targetType           emctl_register_targetType_2020-06-08_15-21-23PM.log
          MRS-targetType           emctl_register_targetType_2020-06-08_15-21-44PM.log
          MRS-targetType           emctl_register_targetType_2020-06-08_15-23-36PM.log
          MRS-targetType           emctl_register_targetType_2020-06-08_15-29-31PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2020-06-08_15-29-48PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2020-06-08_15-30-00PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2020-06-08_15-30-11PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2020-06-08_15-30-31PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2020-06-08_15-30-48PM.log
  MRS-default_collection   emctl_register_default_collection_2020-06-08_15-31-00PM.log
  MRS-default_collection   emctl_register_default_collection_2020-06-08_15-31-23PM.log
  MRS-default_collection   emctl_register_default_collection_2020-06-08_15-31-38PM.log
  MRS-default_collection   emctl_register_default_collection_2020-06-08_15-32-48PM.log
  MRS-default_collection   emctl_register_default_collection_2020-06-08_15-33-59PM.log
      MRS-omsPropertyDef       emctl_register_omsPropertyDef_2020-06-08_15-34-14PM.log
      MRS-omsPropertyDef       emctl_register_omsPropertyDef_2020-06-08_15-34-23PM.log
            MRS-jobTypes             emctl_register_jobTypes_2020-06-08_15-34-35PM.log
            MRS-jobTypes             emctl_register_jobTypes_2020-06-08_15-34-49PM.log
       MRS-systemStencil        emctl_register_systemStencil_2020-06-08_15-35-02PM.log
       MRS-systemStencil        emctl_register_systemStencil_2020-06-08_15-35-09PM.log
       MRS-systemStencil        emctl_register_systemStencil_2020-06-08_15-35-18PM.log
        MRS-gccompliance         emctl_register_gccompliance_2020-06-08_15-35-26PM.log
       MRS-derivedAssocs        emctl_register_derivedAssocs_2020-06-08_15-36-05PM.log


Log file location: /u01/OracleHomes/Middleware/cfgtoollogs/omspatcher/31299359/omspatcher_2020-06-08_14-46-08PM_deploy.log

OMSPatcher succeeded.

After the RU patch was successfully applied you’ll need to start the OMS back up.

$ emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server ...
BI Publisher Server Successfully Started
BI Publisher Server is Up

We have now our OMS running 13.4 RU 3 version. But we are not done yet. There’s one important step that we need to perform and is to apply the RU 3 to our agents as well.

In order to do this we need to download patch 31270875 from MOS. All the bug remediation information about this patch is outlined in Doc ID 2657051.1

Note: You don’t have to upgrade the OPatch utility for the agent as is already running the required version (13.9.4.2.2)

$ export ORACLE_HOME=/u01/OracleHomes/agent/agent_13.4.0.0.0
$ cd /u01/OracleHomes/agent/agent_13.4.0.0.0/OPatch
$ ./opatch lsinventory
Oracle Interim Patch Installer version 13.9.4.2.2
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/OracleHomes/agent/agent_13.4.0.0.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/OracleHomes/agent/agent_13.4.0.0.0/oraInst.loc
OPatch version    : 13.9.4.2.2
OUI version       : 13.9.4.0.0
Log file location : /u01/OracleHomes/agent/agent_13.4.0.0.0/cfgtoollogs/opatch/opatch2020-06-09_11-27-05AM_1.log


OPatch detects the Middleware Home as "/u01/OracleHomes/agent/agent_13.4.0.0.0"

Lsinventory Output file location : /u01/OracleHomes/agent/agent_13.4.0.0.0/cfgtoollogs/opatch/lsinv/lsinventory2020-06-09_11-27-05AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
ARU platform id: 226
ARU platform description:: Linux_AMD64


Interim patches (1) :

Patch  29812738     : applied on Wed Mar 18 12:51:59 EDT 2020
Unique Patch ID:  -1558519023
   Created on 22 May 2019, 02:57:03 hrs PST8PDT
   Bugs fixed:
     20141119, 27548560, 19030178, 24011099, 25423296, 21344996, 19154304



--------------------------------------------------------------------------------

OPatch succeeded.

Now is time to stop the agent and apply the RU patch.

$ cd /home/oracle/Downloads/31270875/
$ ls
30989011  31270875  README.html  README.txt
$ $ORACLE_HOME/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Stopping agent ... stopped.
$ $ORACLE_HOME/OPatch/opatch napply
Oracle Interim Patch Installer version 13.9.4.2.2
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/OracleHomes/agent/agent_13.4.0.0.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/OracleHomes/agent/agent_13.4.0.0.0/oraInst.loc
OPatch version    : 13.9.4.2.2
OUI version       : 13.9.4.0.0
Log file location : /u01/OracleHomes/agent/agent_13.4.0.0.0/cfgtoollogs/opatch/opatch2020-06-09_11-34-58AM_1.log


OPatch detects the Middleware Home as "/u01/OracleHomes/agent/agent_13.4.0.0.0"

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30989011  31270875

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '30989011' to OH '/u01/OracleHomes/agent/agent_13.4.0.0.0'

Patching component oracle.sysman.agent.ic, 13.4.0.0.0...
Applying interim patch '31270875' to OH '/u01/OracleHomes/agent/agent_13.4.0.0.0'

Patching component oracle.sysman.top.agent, 13.4.0.0.0...
Patches 30989011,31270875 successfully applied.
Log file location: /u01/OracleHomes/agent/agent_13.4.0.0.0/cfgtoollogs/opatch/opatch2020-06-09_11-34-58AM_1.log

OPatch succeeded.
$ $ORACLE_HOME/bin/emctl start agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Starting agent .................................... started.

The process is quite simple. Of course, I’m doing this in a test environment but you should do it too before attempting this in a production environment. For your production environment you want to make sure to have proper recovery settings in place and Oracle Management Repository backups.

Hope this helps to understand the patching process.

Happy patching!
Alfredo