Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Apply the Latest OMSPatcher on OEM Server before apply the Main DBRU Patch

Posted by Mir Sayeed Hassan on July 19th, 2023

Apply the Latest OMSPatcher on OEM Server before apply the Main DBRU Patch

Check the status of the OMS

[oracle@oemdb ~]$ cd /u01/OEM13.5C/middleware/bin/
[oracle@oemdb bin]$ ./emctl status oms

Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up

Check the current version of omspatcher applied

[oracle@oemdb ~]$ cd /u01/OEM13.5C/middleware/OMSPatcher/

[oracle@oemdb OMSPatcher]$ ./omspatcher version
OMSPatcher Version: 13.9.4.4.0
OPlan Version: 12.2.0.1.16
OsysModel build: Tue Apr 28 18:16:31 PDT 2020

OMSPatcher succeeded.

Verify the current patches applied here

[oracle@oemdb OMSPatcher]$ ./omspatcher lspatches
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation. All rights reserved.

OMSPatcher version : 13.9.4.4.0
OUI version : 13.9.4.0.0
Running from : /u01/app/oracle/product/19.3.0/db_1
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/omspatcher/opatch2023-06-09_06-19-16AM_1.log

com.oracle.cie.gdr.external.InventoryException: Operation is not supported
at com.oracle.cie.gdr.external.impl.LegacyOracleHomeInventoryImpl.getFeatureSets(LegacyOracleHomeInventoryImpl.java:234)
at oracle.opatchauto.oms.LsPatchesSession.printInstalledPatchForAllHomes(LsPatchesSession.java:127)
at oracle.opatchauto.oms.LsPatchesSession.process(LsPatchesSession.java:100)
at oracle.opatchauto.oms.OMSPatchingSession.main(OMSPatchingSession.java:594)
at oracle.opatchauto.oms.OPatchAuto.main(OPatchAuto.java:814)
There are no patches installed in the OMS system.
OMSPatcher succeeded.

Now check any patches are applied on it

[oracle@oemdb ~]$ /u01/OEM13.5C/middleware/OPatch/opatch lsinventory | grep applied

As per the oracle documentation., Ensure that you have OMSPatcher version 13.9.5.11.0 or later for Enterprise Manager 13.5.0.0 release on all OMSes

Download the above require omspatcher from Oracle by using this document id: 2809842.1

Transfer the files into the server by using WINSCP or Anyother alternative method.

Take the backup of the omspatcher directory from the OMS Home

[oracle@oemdb middleware]$ cd /u01/OEM13.5C/middleware/
[oracle@oemdb middleware]$ mv OMSPatcher/ OMSPatcher_bkp_09062023

Copy the OMSPatcher file to OMS Home location & verify the ownership oracle:oinstall

[oracle@oemdb ~]$ cp /u03/source/OMSPatcher/p19999993_135000_Generic.zip /u01/OEM13.5C/middleware/
[oracle@oemdb ~]$ ll /u01/OEM13.5C/middleware/p19999993_135000_Generic.zip
-rwxr-xr-x. 1 oracle oinstall 1232344 Jun 9 06:49 /u01/OEM13.5C/middleware/p19999993_135000_Generic.zip

Install the OMSPatcher by unzipping the OMSPatcher file

[oracle@oemdb ~]$ cd /u01/OEM13.5C/middleware/
[oracle@oemdb middleware]$ unzip p19999993_135000_Generic.zip
Archive: p19999993_135000_Generic.zip
creating: OMSPatcher/
inflating: OMSPatcher/omspatcher.bat
creating: OMSPatcher/jlib/
inflating: OMSPatcher/jlib/emlcmuser.jar
inflating: OMSPatcher/jlib/omspatcher.jar
inflating: OMSPatcher/jlib/oracle.omspatcher.classpath.jar
inflating: OMSPatcher/jlib/oracle.omspatcher.classpath.unix.jar
inflating: OMSPatcher/jlib/oracle.omspatcher.classpath.windows.jar
creating: OMSPatcher/scripts/
creating: OMSPatcher/scripts/oms/
creating: OMSPatcher/scripts/oms/oms_child_scripts/
inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery
inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery.bat
inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls
inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls.bat
inflating: OMSPatcher/scripts/oms/omspatcher
inflating: OMSPatcher/scripts/oms/omspatcher.bat
creating: OMSPatcher/wlskeys/
inflating: OMSPatcher/wlskeys/createkeys.cmd
inflating: OMSPatcher/wlskeys/createkeys.sh
inflating: OMSPatcher/wlskeys/runCreateKeys.pl
inflating: OMSPatcher/wlskeys/storeKey.py
creating: OMSPatcher/createLcmUserUtl/
inflating: OMSPatcher/createLcmUserUtl/admin_init_pdb_admin_cre.sql
inflating: OMSPatcher/createLcmUserUtl/admin_pdbadmin_utl_pkgbody.plb
inflating: OMSPatcher/createLcmUserUtl/admin_pdbadmin_utl_pkgdef.plb
inflating: OMSPatcher/createLcmUserUtl/admin_postprep_pdb_admin_cre.sql
inflating: OMSPatcher/createLcmUserUtl/admin_precheck_pdb_admin_cre.sql
inflating: OMSPatcher/createLcmUserUtl/admin_profiles.sql
inflating: OMSPatcher/createLcmUserUtl/admin_sys_procs.sql
inflating: OMSPatcher/createLcmUserUtl/admin_transfer_privs_to_lcm_admin.sql
inflating: OMSPatcher/createLcmUserUtl/createLCMUser.pl
inflating: OMSPatcher/createLcmUserUtl/emLcmComponentInfo.xml
inflating: OMSPatcher/createLcmUserUtl/emLcmStorage.xml
inflating: OMSPatcher/createLcmUserUtl/emlcmuser.xml
inflating: OMSPatcher/version.txt
inflating: OMSPatcher/restoring_env.txt
inflating: OMSPatcher/jlib/gson.jar
creating: OMSPatcher/oms/
inflating: OMSPatcher/oms/CloneHomeForNzdt.pl
inflating: OMSPatcher/oms/PatchCmds.pm
inflating: OMSPatcher/oms/admin_nzdt_recompile.sql
inflating: OMSPatcher/oms/admin_recompile_invalid.sql
inflating: OMSPatcher/oms/createAddOMSScript.pl
inflating: OMSPatcher/oms/emPatchApply.xml
inflating: OMSPatcher/oms/emPatchRollback.xml
inflating: OMSPatcher/oms/generateMultiOMSPatchingScripts.pl
inflating: OMSPatcher/oms/generateMultiOMSPatchingScriptsForNZDT.sh
creating: OMSPatcher/adminConfig/
inflating: OMSPatcher/adminConfig/emlcm_admin_pkgbody.sql
inflating: OMSPatcher/adminConfig/emlcm_admin_pkgdef.sql
inflating: OMSPatcher/adminConfig/emlcm_admin_tables.sql
inflating: OMSPatcher/adminConfig/install.properties
inflating: OMSPatcher/adminConfig/lcmUserVersion.properties
inflating: OMSPatcher/omspatcher
inflating: readme.txt
inflating: PatchSearch.xml

Now export to the OMS HOME & verify the omspatcher version

[oracle@oemdb middleware]$ export ORACLE_HOME=/u01/OEM13.5C/middleware/
[oracle@oemdb middleware]$ export PATH=$PATH:/u01/OEM13.5C/middleware/OMSPatcher
[oracle@oemdb middleware]$ echo $PATH
/usr/sbin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/u01/app/oracle/product/19.3.0/db_1/bin:/home/oracle/.local/bin:/home/oracle/bin:/u01/OEM13.5C/middleware/OMSPatcher

verify the omspatcher version

[oracle@oemdb middleware]$ omspatcher version
OMSPatcher Version: 13.9.5.13.0
OPlan Version: 12.2.0.1.16
OsysModel build: Tue Apr 28 18:16:31 PDT 2020

OMSPatcher succeeded.

=====Hence tested & verified in your test env=====