Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, September 18, 2015

The Oracle Home does not exist in Central InventoryUtilSession failed:

While applying the patch I was getting below error:

orporation.  All rights reserved.UTIL sessionOracle Home       : /u01/app/oracle/product/11.2.0.2/SHAIKPRODCentral Inventory : /u01/app/oraInventory   from           : /etc/oraInst.locOPatch version    : 11.1.0.6.6OUI version       : 11.2.0.1.0OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/ouiLog file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_21-03-18PM.logPatch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txtList of Homes on this system:  Home name= OraGI12Home1, Location= "/u01/app/oracle/product/12.1.0/grid"OPatch failed with error code 73OPatchSession cannot load inventory for the given Oracle Home /u01/app/oracle/product/11.2.0.2/SHAIKPROD. 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 InventoryUtilSession failed: OracleHomeInventory gets null oracleHomeInfo :failed
System intact, OPatch will not attempt to restore the system

Fix:
Verify the file under $INV_LOC/ContentsXML -> inventory.xml has the ORACLE_HOME details that you are trying to patch:

[oracle@collabn1 SHAIKPROD]$  vi /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

Below ORACLE_HOME is missing....modify the file and retry the patch:

 vi /u01/app/oraInventory/ContentsXML/inventory.xml
from:
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2014, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>12.1.0.2.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
   <NODE_LIST>
      <NODE NAME="collabn1"/>
      <NODE NAME="collabn2"/>
   </NODE_LIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

to:
<HOME_LIST>
<HOME NAME="OraGI12Home1" LOC="/u01/app/oracle/product/12.1.0/grid" TYPE="O" IDX="1" CRS="true">
   <NODE_LIST>
      <NODE NAME="collabn1"/>
      <NODE NAME="collabn2"/>
   </NODE_LIST>
</HOME>
<HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0.2/SHAIKPROD" TYPE="O" IDX="2">
   <NODE_LIST>
      <NODE NAME="collabn1"/>
      <NODE NAME="collabn2"/>
   </NODE_LIST>



[oracle@collabn1 .patch_storage]$  opatch rollback -id 13467683 -connectstring "SHAIKPRD1:system:test123:collabn1"
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       : /u01/app/oracle/product/11.2.0.2/SHAIKPROD
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/oui
Log file location : /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch2015-09-18_21-18-49PM.log

Patch history file: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/cfgtoollogs/opatch/opatch_history.txt

RollbackSession rolling back interim patch '13467683' from OH '/u01/app/oracle/product/11.2.0.2/SHAIKPROD'

The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.

Running prerequisite checks...

OPatch detected the node list and the local node from the inventory.  OPatch will patch the local system then propagate the patch to the remote nodes.

Backing up files affected by the patch '13467683' for restore. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
The patch will be removed from active database instances.
Disabling and removing online patch 'bug13467683.pch', on database 'SHAIKPRD1'

RollbackSession removing interim patch '13467683' from inventory

Patching in all-node mode.

Updating nodes 'collabn2'
   Rollback-related files are:
     FR = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_files.txt"
     DR = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_dirs.txt"
     FP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt"
     MP = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/make_cmds.txt"
     RC = "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_files.txt" with actual path.
Removing files on remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/remove_dirs.txt" with actual path.
Removing directories on remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0.2/SHAIKPROD/.patch_storage/13467683_Feb_5_2012_00_15_49/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...

OPatch succeeded.

No comments: