This discussion is archived
1 Reply Latest reply: Dec 10, 2012 3:26 PM by 861120 RSS

Inventory corruption after fresh installation

979104 Newbie
Currently Being Moderated
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

Legend

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