Description:
In Oracle EBS Instance, recently I have faced the error as lsinventory session failed while try to run ./opatch lsinventory in our Instance.OPatch wasn’t able to find the database home in central Inventory, due to this issue (opatch failed with error code 73) unable to do the oracle database patching.To fix the issue we have to re-attached Oracle Home to the Central Inventory of the server , so that the Opatch can find the exact oracle home related script present in $ORACLE_HOME/oui/bin ‘’attachHome.sh’’.
[oratest@prodapps OPatch]$ ./opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u011/data/dbhome_1
Central Inventory : /etc/oraInventory
from : /u011/data/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.15
OUI version : 11.2.0.4.0
Log file location :/u011/data/dbhome_1/cfgtoollogs/opatch/opatch2017-06-08_11-07-55AM_1.log
List of Homes on this system:
Home name= GST_WEBOH__apps_tech_st_10_1_3, Location= “/apps/tech_st/10.1.3”
Home name= GST_TOOLS__apps_tech_st_10_1_2, Location= “/apps/tech_st/10.1.2”
LsInventorySession failed: RawInventory gets null OracleHomeInfo
OPatch failed with error code 73
Solution:
step 1:
[oracle@abcserver] $ cd $ORACLE_HOME/oui/bin[oracle@abcserver] $ pwd
step 2:
Change the entery of attachHome.sh
[oratest@aceapps bin]$ vi attachHome.sh#!/bin/sh
OHOME=/u011/data/dbhome_1 –>change Oracle Home — OHOMENAME=dbhome_1
CUR_DIR=`pwd`
cd $OHOME/oui/bin
./runInstaller -detachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME $* > /dev/null 2>&1
./runInstaller -attachhome ORACLE_HOME=$OHOME ORACLE_HOME_NAME=$OHOMENAME$*
Step 3:
Run the attachHome.sh
[oratest@aceapps bin]$ ./attachHome.shStarting Oracle Universal Installer…
Checking swap space: must be greater than 500 MB.Actual 40760 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /etc/oraInventory
‘AttachHome’ was successful.
Step 4:
Check the lsinventory again.
[oracle@abcserver] $opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u011/data/dbhome_1
Central Inventory : /etc/oraInventory
from : /u011/data/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.15
OUI version : 11.2.0.4.0
Log file location : /u011/data/dbhome_1/cfgtoollogs/opatch/opatch2020-06-24_10-38-53AM_1.log
Lsinventory Output file location : /u011/data/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-06-24_10-38-53AM.txt
——————————————————————————–
Local Machine Information::
Hostname: test.******.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (2):
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Examples 11.2.0.4.0
There are 2 products installed in this Oracle Home.
——————————————————————————–
OPatch succeeded.