ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL_MONITOR_LIST'
Steps:
1. Update OPatch and OMSPatcher in the Middleware Home. To update OPatch, go to the Patch 6880880, and pick 13.9 release. To update OMSPatcher, go to the Patch 19999993 and pick the correct Enterprise Manager release.
2. Download the patch 24914115 and apply the patch
3. Restart OMS
1. Update OPatch and OMSPatcher in the Middleware Home
[oracle@cloud ~]$ export ORACLE_HOME=/opt/oracle/middleware_13.2
[oracle@cloud ~]$ /opt/oracle/middleware_13.2/OPatch/opatch version
OPatch Version: 13.8.0.0.0
OPatch succeeded.
[oracle@cloud ~]$ /opt/oracle/middleware_13.2/OMSPatcher/omspatcher version
OMSPatcher Version: 13.8.0.0.0
OPlan Version: 12.1.0.2.2
OsysModel build: Mon Dec 21 18:31:52 PST 2015
OMSPatcher succeeded.
[oracle@cloud ~]$ cd /tmp/
[oracle@cloud tmp]$ mkdir downloadpatch
[oracle@cloud tmp]$ cd downloadpatch
Download Patch 6880880 and Patch 19999993
[oracle@cloud downloadpatch]$ wget --http-user=username --http-password=pass --no-check-certificate --output-document=filename https://updates.oracle.com/Orion/Services/download/p6880880_139000_Generic.zip?aru=20781116&patch_file=p6880880_139000_Generic.zip
[oracle@cloud downloadpatch]$ wget --http-user=username --http-password=pass --no-check-certificate --output-document=filename https://updates.oracle.com/Orion/Services/download/p19999993_132000_Generic.zip?aru=20713685&patch_file=p19999993_132000_Generic.zip
[oracle@cloud downloadpatch]$ ls
p19999993_132000_Generic.zip p6880880_139000_Generic.zip
[oracle@cloud downloadpatch]$ unzip p6880880_139000_Generic.zip
[oracle@cloud downloadpatch]$ ls
6880880 p19999993_132000_Generic.zip p6880880_139000_Generic.zip
[oracle@cloud downloadpatch]$ cd 6880880
[oracle@cloud 6880880]$ /opt/oracle/middleware_13.2/oracle_common/jdk/bin/java -jar opatch_generic.jar -silent ORACLE_HOME=/opt/oracle/middleware_13.2
[oracle@cloud 6880880]$ $OMS_HOME/OPatch/opatch version
OPatch Version: 13.9.1.0.0
OPatch succeeded.
[oracle@cloud 6880880]$ cd $OMS_HOME
[oracle@cloud middleware_13.2]$ mv OMSPatcher OMSPatcher.bak
[oracle@cloud middleware_13.2]$ unzip /tmp/downloadpatch /p19999993_132000_Generic.zip -d $OMS_HOME
Archive: /tmp/patch/p19999993_132000_Generic.zip
creating: /opt/oracle/middleware_13.2/OMSPatcher/
inflating: /opt/oracle/middleware_13.2/OMSPatcher/omspatcher.bat
creating: /opt/oracle/middleware_13.2/OMSPatcher/jlib/
inflating: /opt/oracle/middleware_13.2/OMSPatcher/jlib/omspatcher.jar
inflating: /opt/oracle/middleware_13.2/OMSPatcher/jlib/oracle.omspatcher.classpath.jar
inflating: /opt/oracle/middleware_13.2/OMSPatcher/jlib/oracle.omspatcher.classpath.unix.jar
inflating: /opt/oracle/middleware_13.2/OMSPatcher/jlib/oracle.omspatcher.classpath.windows.jar
creating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/
creating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/
creating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/
inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery
inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery.bat
inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls
inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls.bat
inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/omspatcher
inflating: /opt/oracle/middleware_13.2/OMSPatcher/scripts/oms/omspatcher.bat
creating: /opt/oracle/middleware_13.2/OMSPatcher/wlskeys/
inflating: /opt/oracle/middleware_13.2/OMSPatcher/wlskeys/createkeys.cmd
inflating: /opt/oracle/middleware_13.2/OMSPatcher/wlskeys/createkeys.sh
creating: /opt/oracle/middleware_13.2/OMSPatcher/oms/
inflating: /opt/oracle/middleware_13.2/OMSPatcher/oms/generateMultiOMSPatchingScripts.pl
inflating: /opt/oracle/middleware_13.2/OMSPatcher/omspatcher
inflating: /opt/oracle/middleware_13.2/readme.txt
inflating: /opt/oracle/middleware_13.2/PatchSearch.xml
[oracle@cloud middleware_13.2]$ $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.
2. Apply Patch 24914115
[oracle@cloud middleware_13.2]$ cd /opt/oracle/patch
[oracle@cloud patch]$ wget --http-user=username --http-password=pass --no-check-certificate --output-document=filename https://updates.oracle.com/Orion/Services/download/p24914115_132100_Generic.zip?aru=20792154&patch_file=p24914115_132100_Generic.zip
[oracle@cloud patch]$ unzip p24914115_132100_Generic.zip
[oracle@cloud patch]$ cd 24914115/
[oracle@cloud 24914115]$ pwd
/opt/oracle/patch/24914115
[oracle@cloud 24914115]$ $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 : /opt/oracle/middleware_13.2
Log file location : /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/opatch2017-03-07_16-26-41PM_1.log
OMSPatcher log file: /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-26-45PM_analyze.log
Please enter OMS weblogic admin server URL(t3s://cloud2.ipx.com:7102):> t3s://cloud.ipx.com: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) "24914115" and Oracle Home "/opt/oracle/middleware_13.2"...
Sub-patch(es) "24914115" are successfully analyzed for Oracle Home "/opt/oracle/middleware_13.2"
Complete Summary
================
All log file names referenced below can be accessed from the directory "/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/2017-03-07_16-26-41PM_SystemPatch_24914115_1"
Prerequisites analysis summary:
-------------------------------
The following sub-patch(es) are applicable:
Featureset Sub-patches Log file
---------- ----------- --------
oracle.sysman.top.oms 24914115 24914115_opatch2017-03-07_16-26-45PM_1.log
Log file location: /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-26-45PM_analyze.log
OMSPatcher succeeded.
[oracle@cloud 24914115]$ $ORACLE_HOME/OMSPatcher/omspatcher apply
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 : /opt/oracle/middleware_13.2
Log file location : /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/opatch2017-03-07_16-29-58PM_1.log
OMSPatcher log file: /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-30-02PM_deploy.log
Please enter OMS weblogic admin server URL(t3s://cloud2.ipx.com:7102):> t3s://cloud.ipx.com: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) "24914115" and Oracle Home "/opt/oracle/middleware_13.2"...
Sub-patch(es) "24914115" are successfully analyzed for Oracle Home "/opt/oracle/middleware_13.2"
To continue, OMSPatcher will do the following:
[Patch and deploy artifacts] :
Do you want to proceed? [y|n] y
User Responded with: Y
Applying sub-patch(es) "24914115"
Please monitor log file: /opt/oracle/middleware_13.2/cfgtoollogs/opatch/opatch2017-03-07_16-30-02PM_1.log
Complete Summary
================
All log file names referenced below can be accessed from the directory "/opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/2017-03-07_16-29-58PM_SystemPatch_24914115_1"
Patching summary:
-----------------
Binaries of the following sub-patch(es) have been applied successfully:
Featureset Sub-patches Log file
---------- ----------- --------
oracle.sysman.top.oms_13.2.0.0.0 24914115 24914115_opatch2017-03-07_16-30-02PM_1.log
Log file location: /opt/oracle/middleware_13.2/cfgtoollogs/omspatcher/24914115/omspatcher_2017-03-07_16-30-02PM_deploy.log
OMSPatcher succeeded.
3. Restart OMS
[oracle@cloud 24914115]$ /opt/oracle/middleware_13.2/bin/emctl stop oms –all
[oracle@cloud 24914115]$ /opt/oracle/middleware_13.2/bin/emctl start oms
To get more information please check Oracle Support Doc ID 2199723.1