Oracle Enterprise Manager EM13c – My Oracle Support is back!

Since a few weeks, the online connection in Oracle Enterprise Manager EM13c to My Oracle Support was broken. This resulted in errors like Error occurred when sending request to My Oracle Support, for example when you tried to set the My Oracle Support credentials in a fresh EM13c setup. Existing configurations were not able to get newest patch information anymore. Oracle has documented it in the note Recent Changes to MOS will Disable Enterprise Manager Online Connections (Doc ID 2664002.1)

Screenshot when trying to set MOS credentials in a new EM13c RU4 setup:

Now there is a fix available for all current EM 13 releases, RU included. For more details see Patch Now Available For Recent Changes to MOS That Disabled Enterprise Manager Online Connections (Doc ID 2678494.1). Here is the installation of the patch for an Oracle Enterprise Manager EM13c Release 4 RU2 without using a property file (optional). The patch is transferred to target OMS server and extracted in directory /u01/app/oracle/stage/31233849.

oracle@kestenholz:/u01/app/oracle/stage/ [em13cr4] ll
total 424
drwxr-xr-x 3 oracle oinstall 92 Jul 12 23:00 .
drwxr-xr-x. 13 oracle dba 4096 May 11 13:03 ..
drwxr-x--- 4 oracle oinstall 76 Jun 22 22:10 31233849
-rw-rw-r-- 1 oracle oinstall 3092 Jul 6 17:24 PatchSearch.xml
-rw-r--r-- 1 oracle oinstall 425127 Jul 12 23:00 p31233849_13400200531Bundle_Generic.zip

 

Stop OMS

oracle@kestenholz:/u01/app/oracle/stage/ [em13cr4] emctl stop oms

Validate Patch Apply

oracle@kestenholz:/u01/app/oracle/stage/ [em13cr4] cd /u01/app/oracle/stage/31233849

oracle@kestenholz:/u01/app/oracle/stage/31233849/ [em13cr4] $ORACLE_HOME/OMSPatcher/omspatcher apply -analyze
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/app/oracle/product/em13cr4
Log file location : /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/opatch2020-07-12_23-01-08PM_1.log

OMSPatcher log file: /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/31233849/omspatcher_2020-07-12_23-01-13PM_analyze.log

Please enter OMS weblogic admin server URL(t3s://kestenholz.martinberger.local:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>

Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "31233849" and Oracle Home "/u01/app/oracle/product/em13cr4"...
Sub-patch(es) "31233849" are successfully analyzed for Oracle Home "/u01/app/oracle/product/em13cr4"


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


All log file names referenced below can be accessed from the directory "/u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/2020-07-12_23-01-08PM_SystemPatch_31233849_1"

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

The following sub-patch(es) are applicable:

Featureset Sub-patches Log file
---------- ----------- --------
oracle.sysman.top.oms 31233849 31233849_opatch2020-07-12_23-01-13PM_1.log

Log file location: /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/31233849/omspatcher_2020-07-12_23-01-13PM_analyze.log

OMSPatcher succeeded.

Patch Apply

oracle@kestenholz:/u01/app/oracle/stage/31233849/ [em13cr4] $ORACLE_HOME/OMSPatcher/omspatcher apply
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/app/oracle/product/em13cr4
Log file location : /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/opatch2020-07-12_23-03-23PM_1.log

OMSPatcher log file: /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/31233849/omspatcher_2020-07-12_23-03-27PM_deploy.log

Please enter OMS weblogic admin server URL(t3s://kestenholz.martinberger.local:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>

Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "31233849" and Oracle Home "/u01/app/oracle/product/em13cr4"...
Sub-patch(es) "31233849" are successfully analyzed for Oracle Home "/u01/app/oracle/product/em13cr4"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts] : Apply sub-patch(es) [ 31233849 ]
Apply RCU artifact with patch "/u01/app/oracle/product/em13cr4/.omspatcher_storage/31233849_Jun_22_2020_22_08_35/original_patch";
Register MRS artifact "omsPropertyDef"


Do you want to proceed? [y|n]
y
User Responded with: Y

Applying sub-patch(es) "31233849"
Please monitor log file: /u01/app/oracle/product/em13cr4/cfgtoollogs/opatch/opatch2020-07-12_23-03-27PM_1.log


Updating repository with RCU reference file "/u01/app/oracle/product/em13cr4/.omspatcher_storage/31233849_Jun_22_2020_22_08_35/original_patch"

Registering service "omsPropertyDef" with register file "/u01/app/oracle/product/em13cr4/sysman/metadata/omsProperties/definition/MosOMSPropDefinition.xml" for plugin id as "core"...
Please monitor log file: /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/2020-07-12_23-03-23PM_SystemPatch_31233849_1/emctl_register_omsPropertyDef_2020-07-12_23-06-34PM.log


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


All log file names referenced below can be accessed from the directory "/u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/2020-07-12_23-03-23PM_SystemPatch_31233849_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 31233849 31233849_opatch2020-07-12_23-03-27PM_1.log

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

The following artifact(s) have been successfully deployed:

Artifacts Log file
--------- --------
SQL rcu_applypatch_original_patch_2020-07-12_23-06-16PM.log
MRS-omsPropertyDef emctl_register_omsPropertyDef_2020-07-12_23-06-34PM.log


Log file location: /u01/app/oracle/product/em13cr4/cfgtoollogs/omspatcher/31233849/omspatcher_2020-07-12_23-03-27PM_deploy.log

OMSPatcher succeeded.

 

Start OMS

oracle@kestenholz:/u01/app/oracle/stage/31233849/ [em13cr4] 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

 

New try to set My Oracle Support Credentials – MOS is back!

Et voilà

MOS is back, take care if you use a proxy or a firewall – a new URL has to be whitelisted:  https://oauth-e.oracle.com !