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

Comments