Issue with Opatch

[Former Member]

Hi ,

When we are trying check the patches applied to oracle using

we are getting the following error.

wave0305:orat10 53> $ORACLE_HOME/OPatch/opatch lsinventory

========================================================

GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY

========================================================

Invoking OPatch 10.2.0.4.5

Oracle Interim Patch Installer version 10.2.0.4.5

Copyright (c) 2008, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/T10/102_64

Central Inventory : /oracle/oraInventory

from : /var/opt/oracle/oraInst.loc

OPatch version : 10.2.0.4.5

OUI version : 10.2.0.4.0

OUI location : /oracle/T10/102_64/oui

Log file location : /oracle/T10/102_64/cfgtoollogs/opatch/opatch2010-01-25_19-30-00PM.log

Patch history file: /oracle/T10/102_64/cfgtoollogs/opatch/opatch_history.txt

List of Homes on this system:

Home name= P11_102_64, Location= "/oracle/P11/102_64"

Home name= OraAV10g_home1, Location= "/oracle/P11/AuditVault/1023_64"

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.

Possible causes are:

Oracle Home dir. path does not exist in Central Inventory

Oracle Home is a symbolic link

Oracle Home inventory is corrupted

LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

When checked the inventory.xml file it is pointing to the production system.

wave0305:orat10 52> more inventory.xml

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 2008 Oracle Corporation. All rights Reserved -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

<SAVED_WITH>10.2.0.4.0</SAVED_WITH>

<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="P11_102_64" LOC="/oracle/P11/102_64" TYPE="O" IDX="1"/>

<HOME NAME="OraAV10g_home1" LOC="/oracle/P11/AuditVault/1023_64" TYPE="O" IDX="2"/>

</HOME_LIST>

</INVENTORY>

IDeally it should be the same system as T10 but it is pointing to a P11 which is our production system.

Any poin

[Former Member · Accepted solution]

Your inventory is corrupted thats the reason for the error .

make a copy of your inventory first

Go to /oracle/oraInventory/ContentsXML and modify the inventory.xml to point to te right ORACLE_HOME and LOC

SID_102_64 (if its 10.2.x.x ) or SID_920_64(if its 9i)

Check orainst.loc and see confirm it points to /oracle/orainventory

Check /etc and more the oratab file and see whether you can find teh entry

SID:/oracle/SID/102_64:N

it shouldnt be commented .

Once this is done do a opatch lsinventory and see whether its comes up fine.

Gerard

[stefan_koehler]

Hello Ambarish,

it seems like that the global oracle inventory was copied from another system (P11) .

If your production system is running on the same system it can be correct and you may have two global oracle inventories.

I have seen anything about this topic .. every customer handles it different ..

Normally all oracle installations should be stored in one global oracle inventory (it is also needed for Grid Control for example).

If your system T10 is missing in the global inventory you can recreate its entries from the local oracle inventory with the following command:

shell> su - orat10
shell> cd $ORACLE_HOME/oui/bin
shell> ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/oracle/T10/102_64/" ORACLE_HOME_NAME="T10_102_64"
*** Now it should work fine ***
shell> $ORACLE_HOME/OPatch/opatch lsinventory

If you may have installed some Oracle 9i database on this server before, you may hit an issue with "oracle.swd.jre 1.1.8.3.0" ... if this is true check metalink note #457457.1

Regards

Stefan

[Former Member]

Hi I had the same problem on various Q systems and the solution is stunning - it saved days of my time .