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:
- Download and unzip patch 31299359
- Verify and make sure you meet the pre-reqs
- Stop the Oracle Management Service
- Apply the RU patch
- 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 DownAnd 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 UpWe 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