1 Reply Latest reply: Dec 10, 2012 5:26 PM by 861120 RSS

    Inventory corruption after fresh installation

    979104
      Hi Everyone,

      After fresh installation, i am trying to apply patch 12341758 on 11.2.0.1 database.

      I tried de-attaching and then attaching the oracle home . but the error persists.


      [oracle@oel1 12341758]$ echo $ORACLE_HOME
      /oracle/product/11.2/database


      [oracle@oel1 bin]$ opatch lsinventory
      Invoking OPatch 11.1.0.6.6

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


      Oracle Home : /oracle/product/11.2/database
      Central Inventory : /stage/oraInventory
      from : /etc/oraInst.loc
      OPatch version : 11.1.0.6.6
      OUI version : 11.2.0.1.0
      OUI location : /oracle/product/11.2/database/oui
      Log file location : /oracle/product/11.2/database/cfgtoollogs/opatch/opatch2012-12-11_01-01-33AM.log

      Patch history file: /oracle/product/11.2/database/cfgtoollogs/opatch/opatch_history.txt

      Lsinventory Output file location : /oracle/product/11.2/database/cfgtoollogs/opatch/lsinv/lsinventory2012-12-11_01-01-33AM.txt

      --------------------------------------------------------------------------------
      There are no Interim patches installed in this Oracle Home.


      --------------------------------------------------------------------------------

      OPatch succeeded.


      [oracle@oel1 bin]$ cat /etc/oraInst.loc
      inventory_loc=/stage/oraInventory
      inst_group=oinstall


      [oracle@oel1 12341758]$ opatch apply
      Invoking OPatch 11.1.0.6.6

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


      Oracle Home : /oracle/product/11.2/database
      Central Inventory : /stage/oraInventory
      from : /etc/oraInst.loc
      OPatch version : 11.1.0.6.6
      OUI version : 11.2.0.1.0
      OUI location : /oracle/product/11.2/database/oui
      Log file location : /oracle/product/11.2/database/cfgtoollogs/opatch/opatch2012-12-11_01-04-44AM.log

      Patch history file: /oracle/product/11.2/database/cfgtoollogs/opatch/opatch_history.txt

      ApplySession applying interim patch '12341758' to OH '/oracle/product/11.2/database'

      Running prerequisite checks...
      Patch 12341758: Optional component(s) missing : [ oracle.rdbms, 11.2.0.1.0 ]
      Prerequisite check "CheckApplicable" failed.
      The details are:
      Patch is no-op patch.
      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


      [oracle@oel1 bin]$ ./runInstaller -silent -invPtrLoc $ORACLE_HOME/oraInst.loc -attachHome ORACLE_HOME="/oracle/product/11.2/database" ORACLE_HOME_NAME="Ora11gR2Home"
      Starting Oracle Universal Installer...

      Checking swap space: must be greater than 500 MB. Actual 1983 MB Passed
      Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-12-11_12-53-21AM. Please wait ...[oracle@oel1 bin]$ The inventory pointer is located at /oracle/product/11.2/database/oraInst.loc
      The inventory is located at /stage/oraInventory
      'AttachHome' was successful.


      [oracle@oel1 ContentsXML]$ pwd
      /stage/oraInventory/ContentsXML
      [oracle@oel1 ContentsXML]$ cat inventory.xml
      <?xml version="1.0" standalone="yes" ?>
      <!-- Copyright (c) 1999, 2009, Oracle. All rights reserved. -->
      <!-- Do not modify the contents of this file by hand. -->
      <INVENTORY>
      <VERSION_INFO>
      <SAVED_WITH>11.2.0.1.0</SAVED_WITH>
      <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
      </VERSION_INFO>
      <HOME_LIST>
      <HOME NAME="Ora11gR2Home" LOC="/oracle/product/11.2/database" TYPE="O" IDX="1"/>
      </HOME_LIST>
      </INVENTORY>


      Regards,
      Hari