On my 2 Node RAC db when I invoke “opatch lsinventory” it is failing
with below error message
oracleprod01:CUSTDB01:/u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch
$ ./opatch lsinventory
Oracle Interim
Patch Installer version 12.2.0.1.8
Copyright (c)
2017, Oracle Corporation. All rights
reserved.
Oracle
Home :
/u01/app/oracle/product/12.1.0.2/dbhome_1
Central
Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file
location :
/u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2017-03-22_21-10-36PM_1.log
List of Homes
on this system:
Home name= OraGI12Home1, Location=
"/u01/app/12.1.0.2/grid"
Home name= OraDb11g_home1, Location=
"/u01/app/oracle/product/11.2.0.4/dbhome_1"
LsInventorySession failed: RawInventory gets null
OracleHomeInfo
OPatch failed with error code 73
Solution:
oracleprod01:CUSTDB01:/u01/app $ cd oraInventory/
oracleprod01:CUSTDB01:/u01/app/oraInventory $ ls
backup ContentsXML logs
oraInst.loc orainstRoot.sh
oracleprod01:CUSTDB01:/u01/app/oraInventory $ cat oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
oracleprod01:CUSTDB01:/u01/app/oraInventory $ cd ContentsXML
oracleprod01:CUSTDB01:/u01/app/oraInventory/ContentsXML $ ls
comps.xml inventory.xml libs.xml
oracleprod01:CUSTDB01:/u01/app/oraInventory/ContentsXML $ cat inventory.xml
<?xml
version="1.0" standalone="yes" ?>
<!--
Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights
reserved. -->
<!-- Do not
modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.2.0.4.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME
NAME="OraGI12Home1" LOC="/u01/app/12.1.0.2/grid"
TYPE="O" IDX="1" CRS="true">
<NODE_LIST>
<NODE NAME="oracleprod01"/>
<NODE NAME="oracleprod02"/>
<NODE NAME=" oracleprod03"/>
<NODE NAME="oracleprod04"/>
</NODE_LIST>
</HOME>
<HOME
NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0.4/dbhome_1"
TYPE="O" IDX="2">
<NODE_LIST>
<NODE NAME="oracleprod01"/>
<NODE NAME="oracleprod02"/>
<NODE NAME=" oracleprod03"/>
<NODE NAME="oracleprod04"/>
</NODE_LIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
From the above output we can see that my 12c oracle home is missing so
then I have added it then "opatch" went success
oracleprod01:NOTSET:/u01/app/oraInventory/ContentsXML $ cat
/u01/app/oraInventory/ContentsXML/inventory.xml
<?xml
version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999,
2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the
contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.2.0.4.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME
NAME="OraGI12Home1" LOC="/u01/app/12.1.0.2/grid"
TYPE="O" IDX="1" CRS="true">
<NODE_LIST>
<NODE NAME="oracleprod01"/>
<NODE NAME="oracleprod02"/>
<NODE NAME="oracleprod03"/>
<NODE NAME="oracleprod04"/>
</NODE_LIST>
</HOME>
<HOME
NAME="OraDb11g_home1"
LOC="/u01/app/oracle/product/11.2.0.4/dbhome_1" TYPE="O"
IDX="2">
<NODE_LIST>
<NODE NAME="oracleprod01"/>
<NODE NAME="oracleprod02"/>
<NODE NAME=" oracleprod03"/>
<NODE NAME="oracleprod04"/>
</NODE_LIST>
</HOME>
<HOME
NAME="OraDb12c_home1" LOC="/u01/app/oracle/product/12.1.0.2/dbhome_1"
TYPE="O" IDX="3">
<NODE_LIST>
<NODE NAME="oracleprod01"/>
<NODE NAME="oracleprod02"/>
<NODE NAME="oracleprod03"/>
<NODE NAME="oracleprod04"/>
</NODE_LIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
Refer more:
OPatch Fails With "LsInventorySession failed: OracleHomeInventory
gets null oracleHomeInfo" (Doc ID 728417.1)
0 comments:
Post a Comment