ZDM and How We Migrated to OCI in 6 Weeks
Migrating an on-premise database to the cloud within a limited timeframe can be a challenging endeavor. I had a High Education Client that put us to ... Read More
Patching EM 13C to Release Unit 13.4.0.10
This will be a small blog post to help you patch your EM 13c environment to the latest release unit, which is 13.4.0.10. Which I highly recommend, as it fixes a bug (32288282) if you are planning to upgrade from EM 13.4 to 13.5.
The first thing is to download the following three patches:
- p19999993_134000_Generic.zip ( Download OMSPatcher patch of version 13.9.4.5.0 for Enterprise Manager Cloud Control 13.4.0.0.0 For RU6 and above)
- p28186730_139425_Generic.zip
- p32318082_134000_Generic.zip
Once I had downloaded the needed patches, I proceeded to create the WebLogic key so that I can use a property file, called property_file.txt, during the patching activity.
[oracle@ol7-em134 em_patch]$ ls p19999993_134000_Generic.zip p28186730_139425_Generic.zip p32318082_134000_Generic.zip [oracle@ol7-em134 em_patch]$ cd /u01/app/oracle/middleware/OMSPatcher/wlskeys/ [oracle@ol7-em134 wlskeys]$ ./createkeys.sh -oh /u01/app/oracle/middleware -location /home/oracle/working/keys The oraclehome passed is valid. Please enter weblogic admin server username: weblogic Please enter weblogic admin server password: Trying to get configuration and key files for the given inputs... This operation will take some time. Please wait for updates... 'createkeys' succeeded. [oracle@ol7-em134 keys]$ cat /home/oracle/working/keys/property_file.txt AdminServerURL=t3s://ol7-em134.localdomain:7102 AdminConfigFile=/home/oracle/working/keys/config AdminKeyFile=/home/oracle/working/keys/key
Now, I installed the latest OPatch to the OMS home. For this I need to stop OMS, making sure I had set the variable ORACLE_HOME to the OMS Home location. Also, I updated the 13.9.4.5.0 omspatcher.
[oracle@ol7-em134 em_patch]$ export ORACLE_HOME=/u01/app/oracle/middleware [oracle@ol7-em134 em_patch]$ ./emctl stop oms -all Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... WebTier Successfully Stopped Oracle Management Server Successfully Stopped Oracle Management Server is Down JVMD Engine is Down Stopping BI Publisher Server... BI Publisher Server Successfully Stopped AdminServer Successfully Stopped BI Publisher Server is Down [oracle@ol7-em134 bin]$ $ORACLE_HOME/oracle_common/jdk/bin/java -jar /home/oracle/working/em_patch/6880880/opatch_generic.jar -silent oracle_home=$ORACLE_HOME [oracle@ol7-em134 em_patch]$ mv $ORACLE_HOME/OMSPatcher $ORACLE_HOME/OMSPatcher.bak [oracle@ol7-em134 em_patch]$ unzip p19999993_134000_Generic.zip -d $ORACLE_HOME
Once I had finished setting up the latest OMSPatcher and OPatch, I now ran an analysis to see if I could proceed with the patch. I did see some warnings when I ran analyze, but these were due to that I didn’t have a few plugins enabled in my EM deployment.
[oracle@ol7-em134 32318082]$ omspatcher apply -analyze -property_file /home/oracle/working/keys/property_file.txt OMSPatcher Automation Tool Copyright (c) 2017, Oracle Corporation. All rights reserved. OMSPatcher version : 13.9.4.5.0 OUI version : 13.9.4.0.0 Running from : /u01/app/oracle/middleware Log file location : /u01/app/oracle/middleware/cfgtoollogs/omspatcher/opatch2021-04-26_17-17-06PM_1.log OMSPatcher log file: /u01/app/oracle/middleware/cfgtoollogs/omspatcher/32318082/omspatcher_2021-04-26_17-17-16PM_analyze.log WARNING: Could not apply the patch "32198935" because the "oracle.sysman.vt.oms.plugin with version 13.4.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system. ... Complete Summary ================ All log file names referenced below can be accessed from the directory "/u01/app/oracle/middleware/cfgtoollogs/omspatcher/2021-04-26_16-56-00PM_SystemPatch_32318082_1" Prerequisites analysis summary: ------------------------------- The following sub-patch(es) are not applicable: Featureset Sub-patches Log file ---------- ----------- -------- oracle.sysman.top.oms 32198950,32198906,32198825,31812958,32198812,32198843 32198950,32198906,32198825,31812958,32198812,32198843_opatch2021-04-26_16-56-10PM_1.log ... OMSPatcher Session completed with warnings. Log file location: /u01/app/oracle/middleware/cfgtoollogs/omspatcher/32318082/omspatcher_2021-04-26_16-56-35PM_analyze.log OMSPatcher completed with warnings.
With the OMS still down, I now applied the 13.4.10 release unit.
[oracle@ol7-em134 32318082]$ omspatcher apply -property_file /home/oracle/working/keys/property_file.txt OMSPatcher Automation Tool Copyright (c) 2017, Oracle Corporation. All rights reserved. OMSPatcher version : 13.9.4.5.0 OUI version : 13.9.4.0.0 Running from : /u01/app/oracle/middleware Log file location : /u01/app/oracle/middleware/cfgtoollogs/omspatcher/opatch2021-04-26_18-21-14PM_1.log OMSPatcher log file: /u01/app/oracle/middleware/cfgtoollogs/omspatcher/32318082/omspatcher_2021-04-26_18-21-28PM_deploy.log ... Running apply prerequisite checks for sub-patch(es) "32198950,32198906,32198825,31812958,32198812,32198843" and Oracle Home "/u01/app/oracle/middleware"... Sub-patch(es) "32198950,32198906,32198825,31812958,32198812,32198843" are successfully analyzed for Oracle Home "/u01/app/oracle/middleware" To continue, OMSPatcher will do the following: [Patch and deploy artifacts] : Apply sub-patch(es) [ 31812958 32198812 32198825 32198843 32198906 32198950 ] Apply RCU artifact with patch "/u01/app/oracle/middleware/.omspatcher_storage/32198812_Feb_21_2021_06_20_29/original_patch"; Apply RCU artifact with patch "/u01/app/oracle/middleware/.omspatcher_storage/32198825_Feb_21_2021_06_39_40/original_patch"; Apply RCU artifact with patch "/u01/app/oracle/middleware/.omspatcher_storage/32198906_Feb_21_2021_06_39_56/original_patch"; Apply RCU artifact with patch "/u01/app/oracle/middleware/.omspatcher_storage/32198950_Feb_21_2021_06_40_18/original_patch"; Apply RCU artifact with patch "/u01/app/oracle/middleware/.omspatcher_storage/32198843_Feb_21_2021_06_41_17/original_patch"; Apply RCU artifact with patch "/u01/app/oracle/middleware/.omspatcher_storage/31812958_Sep_8_2020_04_35_38/original_patch"; Register MRS artifact "commands"; Register MRS artifact "procedures"; Register MRS artifact "swlib"; Register MRS artifact "targetType"; Register MRS artifact "storeTargetType"; Register MRS artifact "default_collection"; Register MRS artifact "omsPropertyDef"; Register MRS artifact "jobTypes"; Register MRS artifact "systemStencil"; Register MRS artifact "gccompliance"; Register MRS artifact "discovery"; Register MRS artifact "SecurityClassManager"; Register MRS artifact "CredstoreMetadata"; Register MRS artifact "assoc"; Register MRS artifact "EcmMetadataOnlyRegistration"; Register MRS artifact "TargetPrivilege"; Register MRS artifact "derivedAssocs" Do you want to proceed? [y|n] y User Responded with: Y Applying sub-patch(es) "31812958,32198812,32198825,32198843,32198906,32198950" Please monitor log file: /u01/app/oracle/middleware/cfgtoollogs/opatch/opatch2021-04-26_18-21-27PM_1.log ... Complete Summary ================ All log file names referenced below can be accessed from the directory "/u01/app/oracle/middleware/cfgtoollogs/omspatcher/2021-04-26_18-21-14PM_SystemPatch_32318082_1" Patching summary: ----------------- Binaries of the following sub-patch(es) have been applied successfully: Featureset Sub-patches Log file ---------- ----------- -------- oracle.sysman.top.oms_13.4.0.0.0 31812958,32198812,32198825,32198843,32198906,32198950 31812958,32198812,32198825,32198843,32198906,32198950_opatch2021-04-26_18-21-27PM_1.log The following sub-patches are incompatible with components installed in the OMS system: 32198935,32198883,32198861,32198970,31894749,32198922,32198853,31889317,31802539 ... OMSPatcher Session completed with warnings. Log file location: /u01/app/oracle/middleware/cfgtoollogs/omspatcher/32318082/omspatcher_2021-04-26_18-21-28PM_deploy.log OMSPatcher completed with warnings.
As you can see, patching EM to the latest release unit is not that complex, but you will need downtime to update to the latest opatch and the actual patch application,
More from this Author
OCI CLI : Script to Set your Tenancy when you Manage Multiple Tenancies
OCI CLI is a great tool to have at your disposal, but one problem that starts to happen as you begin to deal with several clients is that you need to ... Read More
