3 Replies Latest reply: Dec 13, 2012 11:30 PM by sonidba RSS

    ORA-16538: no match on requested item

    sonidba
      Hello to all,

      I am using 10.2.0.5 Grid control. While trying to add new physical standby database using grid control, I am getting
      ORA-16538: no match on requested item. I have successfully created physical standby using command line.

      Please help.

      Thanks
        • 1. Re: ORA-16538: no match on requested item
          mseberg
          Hello;

          Known bug.

          Would consider looking at patch 8267406.

          Best Regards

          mseberg
          • 2. Re: ORA-16538: no match on requested item
            Mahir M. Quluzade
            Please check MOS Note : 1145294.1

            ORA-16538 When Adding Existent 11gR2 Standby Database to Grid Control 10.2.0.5 [ID 1145294.1]


            Mahir
            • 3. Re: ORA-16538: no match on requested item
              sonidba
              Applying 8267406 brings

              opatch apply
              Invoking OPatch 10.2.0.4.6

              Oracle Interim Patch Installer version 10.2.0.4.6
              Copyright (c) 2009, Oracle Corporation. All rights reserved.


              Oracle Home : /u01/app/oracle/product/10.2.0/db_1/oms10g
              Central Inventory : /u01/app/oracle
              from : /etc/oraInst.loc
              OPatch version : 10.2.0.4.6
              OUI version : 10.2.0.5.0
              OUI location : /u01/app/oracle/product/10.2.0/db_1/oms10g/oui
              Log file location : /u01/app/oracle/product/10.2.0/db_1/oms10g/cfgtoollogs/opatch/opatch2012-12-14_10-56-35AM.log

              Patch history file: /u01/app/oracle/product/10.2.0/db_1/oms10g/cfgtoollogs/opatch/opatch_history.txt

              ApplySession applying interim patch '8267406' to OH '/u01/app/oracle/product/10.2.0/db_1/oms10g'

              Running prerequisite checks...
              Prerequisite check "CheckApplicable" failed.
              The details are:
              Patch 8267406: Required component(s) missing : [ oracle.sysman.top.oms, 10.2.0.5.0 ]
              ApplySession failed during prerequisite checks: Prerequisite check "CheckApplicable" failed.
              System intact, OPatch will not attempt to restore the system

              OPatch failed with error code 74


              Here is the extract of the logfileINFO:Prereq checkPatchApplicableOnCurrentPlatform Passed on patch :8267406
              INFO:Prereq checkComponents failed. So, checkApplicable returning without execution.
              INFO:Prerequisite check "CheckApplicable" failed.
              The details are:
              Patch 8267406: Required component(s) missing : [ oracle.sysman.top.oms, 10.2.0.5.0 ]
              SEVERE:OUI-67074:ApplySession failed during prerequisite checks: Prerequisite check "CheckApplicable" failed.
              INFO:System intact, OPatch will not attempt to restore the system
              INFO:Finishing ApplySession at Fri Dec 14 09:52:51 GMT+05:30 2012
              INFO:Total time spent waiting for user-input is 0 seconds. Finish at Fri Dec 14 09:52:51 GMT+05:30 2012
              INFO:Stack Description: oracle.opatch.PrereqFailedException: Prerequisite check "CheckApplicable" failed.
              INFO:StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:3526)
              INFO:StackTrace: oracle.opatch.ApplySession.processLocal(ApplySession.java:3547)INFO:StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5378)
              INFO:StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:1633)
              INFO:StackTrace: oracle.opatch.OPatch.main(OPatch.java:630)