This discussion is archived
3 Replies Latest reply: Dec 13, 2012 9:30 PM by sonidba RSS

ORA-16538: no match on requested item

sonidba Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    Hello;

    Known bug.

    Would consider looking at patch 8267406.

    Best Regards

    mseberg
  • 2. Re: ORA-16538: no match on requested item
    MahirM.Quluzade Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points