After I have installed the EM13c R2, I noticed that I couldn’t access the SQL Monitoring page. I tested the SQL monitoring page for 11g to 12c database targets, and it gave the same error: ORA-06553: PLS-306: wrong number or types of arguments in call to ‘REPORT_SQL_MONITOR_LIST’. As you can guess I hit a bug, good thing is someone else already raised a service request and Oracle released Patch 24914115 to fix the bug. When I examined the patch, I saw that it’s also released for DB Plugin (OMS) 12.1.0.8.161031 Bundle. So if you applied this 161031 bundle for EM13 R1, you probably have the same bug, and you need to apply the patch.
I was planning to say a few words about the poor testing of EM13c releases, but I’m sure everyone already knows it, so I’ll just tell how I applied the Patch 24914115.
First of all, we need to update OPatch (in the Middleware Home) and OMSPatcher. To update OPatch, go to the Patch 6880880, and pick 13.9 release. It’s the OPatch for Enterprise Manager. I don’t think that Oracle Database will have 13.9 release so it seems 13.9 is reserved for Enterprise Manager 13c.
OPatch 13.9 is a different than previous OPatch releases. It comes with an installer. Download “p6880880_139000_Generic.zip”, unzip it to a temporary directory. You’ll see a file named “opatch_generic.jar”. Using JDK of Oracle Middleware Home, run the jar file:
1 2 3 |
unzip p6880880_139000_Generic.zip -d /tmp cd /tmp $OMS_HOME/oracle_common/jdk/bin/java -jar opatch_generic.jar -silent oracle_home=/u02/oracle/Middleware |
According to the readme file, the jar file requires two parameters. First one is “-slient” (I didn’t tested what happens if I don’t give -slient parameter), and second one is oracle_home. The oracle_home parameter should point to the Oracle Middleware Home.
To update OMSPatcher, go to the Patch 19999993, and pick the correct Enterprise Manager release. Download the patch file, rename the old OMSPatcher folder and unzip the new OMSPatcher:
1 2 3 |
cd $OMS_HOME mv OMSPatcher OMSPatcher.bak unzip p19999993_132000_Generic.zip -d $OMS_HOME |
After you update them, check the releases of the OMSPatcher and OPatch:
1 2 3 4 5 6 7 8 9 10 11 |
$OMS_HOME/OMSPatcher/omspatcher version OMSPatcher Version: 13.8.0.0.1 OPlan Version: 12.2.0.1.6 OsysModel build: Tue Nov 08 17:52:30 PST 2016 OMSPatcher succeeded. $OMS_HOME/OPatch/opatch version OPatch Version: 13.9.1.0.0 OPatch succeeded. |
So we upgraded both the OMSPatcher and the OPatch. Now we can download the patch and apply it to our system.
Go to the Patch 24914115, download the patch for EM13c R2, unzip the file for a temporary folder, switch that folder, set ORACLE_HOME variable to your Oracle Middleware Home, and run the omspatcher. I’ll run it with analyze parameter to be sure that the patch has no conflicts and all prerequisites are already met:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
unzip p24914115_132100_Generic.zip -d /home/oracle/patches cd /home/oracle/patches/24914115 export ORACLE_HOME=/u02/oracle/Middleware $ORACLE_HOME/OMSPatcher/omspatcher apply -analyze OMSPatcher Automation Tool Copyright (c) 2016, Oracle Corporation. All rights reserved. OMSPatcher version : 13.8.0.0.1 OUI version : 13.8.0.0.0 Running from : /u02/oracle/Middleware Log file location : /u02/oracle/Middleware/cfgtoollogs/omspatcher/...log OMSPatcher log file: /u02/oracle/Middleware/cfgtoollogs/omspatcher/24914115/...log Please enter OMS weblogic admin server URL(t3s://...com:7102):> Please enter OMS weblogic admin server username(weblogic):> Please enter OMS weblogic admin server password:> |
Enter the weblogic admin server, username and password. OMSPatcher will detect the admin server and username, so you probably just accept them with pressing enter. All you need is to enter the admin server password.
1 2 3 4 5 6 7 8 |
Prerequisites analysis summary: ------------------------------- The following sub-patch(es) are applicable: Featureset Sub-patches Log file ---------- ----------- -------- oracle.sysman.top.oms 24914115 24914115_opatch...log |
If you see a message similar to above, you’re ready to apply the patch. Issue “omspatcher apply” command (without -analzye parameter) to apply the patch. After applying the patch, you need to restart OMS to make changes take effect. That’s all, so we can access the SQL Monitoring page!
J
Gokhan Atil
Paul Hubbert
Gokhan Atil
J.P. Boileau
Yusuf Eyidogan