Inventory is the index for the oracle installation. All the details about the ORACLE_HOME including different utility versions, patch details etc. If you do a fresh Oracle installation the inventory will be updated. But if you copy the ORACLE binaries from some other location and if you are not updating the inventory, we cannot read the inventory using opatch utility.

Step 1: checking the inventory of a corrupted database using opatch lsinventory

$ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 12.1.0.1.7

Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1

Central Inventory : /u01/app/oracle/oraInventory

from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.7

OUI version : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2015-07-25_11-26-44AM_1.log

OPatch failed to locate Central Inventory.

Possible causes are:

The Central Inventory is corrupted
The oraInst.loc file specified is not valid.

LsInventorySession failed: OPatch failed to locate Central Inventory.

OPatch failed with error code 73

Solution:

Re-create the central inventory

Run the following command to fix the inventory in Unix prompt from ORACLE_HOME directory

$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/u01/app/oracle/product/12.1.0.2/db_1" -attachHome ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/db_1" ORACLE_HOME_NAME="OraDb12c_home1"

Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 23750 MB Passed

The inventory pointer is located at /var/opt/oracle/oraInst.loc

'AttachHome' was successful.

Now your corrupted Oracle inventory is fixed. Once again you check your inventory with opatch command.

$ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 12.1.0.1.7

Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1

Central Inventory : /u01/app/oracle/oraInventory

from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.7

OUI version : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2015-01-25_11-26-44AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-01-25_11-26-44AM.txt

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 20415564 : applied on Wed Jul 01 11:18:48 MDT 2015

Unique Patch ID: 18768682

Patch description: “Database PSU 12.1.0.2.3, Oracle JavaVM Component (Apr2015)”

Created on 1 Apr 2015, 06:55:25 hrs PST8PDT

Bugs fixed:

19699946, 19909862, 19223010, 19877336, 19895326, 20408829, 19153980

20415564, 19855285, 19895362, 19231857, 19245191, 20408866

——————————————————————————–

OPatch succeeded.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.