Unable to apply RDBMS patch (Opatch) on 10G ENV after postclone and upgrade from 9i.

UNABLE TO APPLY RDBMS PATCH (Opatch) ON 10G ENV after postclone and upgrade from 9i.

SOLUTION:

Some options of opatch:

Opatch apply –invPtrLoc

Opatch apply –no_inventory

Which opatch

~/Oraclemine/10.2.0/OPatch/opatch

(Oracle06) 5005469 - -bash $ opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc

Invoking OPatch 10.2.0.2.0

. Oracle interim Patch Installer version 10.2.0.2.0

@ Copyright (c) 2005, Oracle Corporation.  All rights reserved..

. Oracle Home: /mine/oracle/oraclemine/10.2.0

Central Inventory: /mine/oracle/oraclemine/10.2.0/oraInventory

   from           : /mine/oracle/oraclemine/10.2.0/oraInst.loc

OPatch version: 10.2.0.2.0

OUI version: 10.2.0.2.0

OUI location: /mine/oracle/oraclemine/10.2.0/oui

Log file location: 

/mine/oracle/oraclemine/10.2.0/cfgtoollogs/opatch/opatch-2006_Apr_25_21-58-34-PDT_Tue.log

. ApplySession applying interim patch '5005469' to OH/mine/oracle/oraclemine/10.2.0'

List of Homes on this system:

OPatchSession cannot load inventory for the given Oracle Home 

/mine/oracle/oraclemine/10.2.0. Possible causes are:

   No read or write permission to ORACLE_HOME/.patch_storage

   Central Inventory is locked by another OUI instance

   No read permission to Central Inventory

   The lock file exists in ORACLE_HOME/.patch_storage

   The Oracle Home does not exist in Central Inventory

.

Apply Session failed: ApplySession failed to prepare the system.  No detail  available.

System intact, OPatch will not attempt to restore the system

.

OPatch failed with error code 73

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

I have checked that patch_lock file is not available on  $ORACLE_HOME/.patch_storage and no lock on Inventory. Also required permissions are exisitng  for .patch_storage and oraInventory.  .

lsinventory gives the following info

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

(oracle06) 5005469 - -bash $ opatch lsinventory -invPtrLoc 

$ORACLE_HOME/oraInst.loc

Invoking OPatch 10.2.0.2.0

. Oracle interim Patch Installer version 10.2.0.2.0

@ Copyright (c) 2005, Oracle Corporation.  All rights reserved..

.Oracle Home       : /mine/oracle/oraclemine/10.2.0

Central Inventory : / mine /oracle/ oraclemine /10.2.0/oraInventory

   from           : / mine /oracle/ oraclemine /10.2.0/oraInst.loc

OPatch version    : 10.2.0.2.0

OUI version       : 10.2.0.2.0

OUI location      : / mine /oracle/ oraclemine /10.2.0/oui

Log file location : 

/ mine /oracle/ oraclemine /10.2.0/cfgtoollogs/opatch/opatch-2006_Apr_25_22-00-16-PDT_Tue.log .

List of Homes on this system:

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

LsInventory Session failed: OracleHomeInventory::load() gets null  oracleHomeInfo .OPatch failed with error code 72

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

 Looks like $ORACLE_HOME is not attached to the local inventory. Attaching the ORACLE_HOME to the inventory.

Run runClone.sh as mentioned under "Run 10g Cloning" step  . This will resolve the issue