Tuesday, 10 April 2012

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

No comments:

Post a Comment

Post a Comment