LsInventorySession failed: OPatch failed to locate Central Inventory. The Central Inventory is corrupted or oraInst.loc file specified is not valid OPatch failed with error code 73.
In case if central inventory is lost or corrupted then you will get this type of error. I executed opatch lsinventory and encountered with the below error.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
In this case you need to recreate the oraInventory if someone accidentally deleted or restore the oraInst.loc file if not valid.
Steps to Recreate oraInventory:
STEP 1: Check the oraInventory location. This file will be located under /etc or /var/opt/oracle directory.
[oracle@orahow-ux ~]$ cat /etc/oraInst.loc
inventory_loc=/home/oracle/oraInventory
inst_group=oracle
STEP 2: Find the Oracle Home
There are multiple ways to find the ORACLE_HOME. You can use any of the below methods:
1. [oracle@orahow-ux ~]$ env|grep ORA
ORACLE_SID=db11g
ORACLE_HOME=/home/oracle/app/product/11.2.4/dbhome_1
2. [oracle@orahow-ux ~]$ cat /etc/oratab
3. You can also check manually or entry in listener.ora file.
4. Under ORACLE_BASE/cfgtoollogs/dbca, check the trace.log file as shown below.
[oracle@orahow-ux dbca]$ pwd
/home/oracle/app/cfgtoollogs/dbca
[oracle@orahow-ux dbca]$ ls -lrt
total 96
-rw-r----- 1 oracle oracle 97470 Mar 19 15:01 trace.log_OraDb11g_home1_2019-03-19_03-01-05-PM
drwxr-x--- 2 oracle oracle 6 Mar 19 15:06 db11g
5. If you have oracle old inventory, then you can view from-
/oraInventory/ContentsXML/inventory.xml
you can see ORACLE_HOME & ORACLE_HOME_NAME
STEP 2: You can find the ORACLE_HOME_NAME using below methods:
1. [oracle@orahow-ux admin]$ $ORACLE_HOME/patch/opatch lsinventory -all
2. Invoke the runInstaller inside $ORACLE_HOME/oui/bin
-> Select Installed Products
-> The products (ORACLE_HOME_NAME) installed will be displayed
-> Put a check mark on the ORACLE_HOME_NAME and its location will be displayed
Environment
The installed ORACLE_HOME_NAME along with Home Path will be displayed.
3. Under ORACLE_BASE/cfgtoollogs/dbca, check the trace.log file as shown below.
[oracle@orahow-ux dbca]$ ls -lrt
total 96
-rw-r----- 1 oracle oracle 97470 Mar 19 15:01 trace.log_OraDb11g_home1_2019-03-19_03-01-05-PM
drwxr-x--- 2 oracle oracle 6 Mar 19 15:06 db11g
[main] [ 2019-03-19 15:01:18.676 IST ] [Host.cleanup:3682] Dbca exit status is: 0
[main] [ 2019-03-19 15:01:18.676 IST ] [Host.cleanup:3685] check point context null
[main] [ 2019-03-19 15:01:18.677 IST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2019-03-19 15:01:18.677 IST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home1
[main] [ 2019-03-19 15:01:18.677 IST ] [OsUtilsBase.copyFile:1565] OsUtilsBase.copyFile:
[main] [ 2019-03-19 15:01:18.678 IST ] [OsUtilsBase.copyFile:1613] **write of file at destination complete…
[main] [ 2019-03-19 15:01:18.679 IST ] [OsUtilsBase.copyFile:1648] **file copy status:= true
4. /oraInventory/ContentsXML/inventory.xml
STEP 3: Once you get the ORACLE_HOME and ORACLE_HOME_NAME you can execute the below command to recreate or attach the oraInventory.
Invoke the runinstaller from $ORACLE_HOME/oui/bin/runInstaller.
[oracle@orahow-ux ~]$ $ORACLE_HOME/oui/bin/runInstaller -silent -attachHome ORACLE_HOME=/home/oracle/app/product/11.2.4/dbhome_1 ORACLE_HOME_NAME=OraDb11g_home1
Starting Oracle Universal Installer…
Checking swap space: must be greater than 500 MB. Actual 1159 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /home/oracle/oraInventory
'AttachHome' was successful.
STEP 4: Check the opatch lsinventory command.
[oracle@orahow-ux ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/product/11.2.4/dbhome_1
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/product/11.2.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /home/oracle/app/product/11.2.4/dbhome_1/cfgtoollogs/opatch/opatch2019-04-23_18-29-33PM_1.log
Lsinventory Output file location : /home/oracle/app/product/11.2.4/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-04-23_18-29-33PM.txt
Local Machine Information::
Hostname: orahow-ux
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 28729262 : applied on Tue Apr 02 20:14:47 IST 2019
Unique Patch ID: 22664181
Patch description: "Database Patch Set Update : 11.2.0.4.190115 (28729262)"
Created on 19 Dec 2018, 22:33:21 hrs PST8PDT
Sub-patch 28204707; "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
Sub-patch 27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17184721, 21174504, 21538558, 16091637, 18092127, 17381384, 15979965
20671094, 16731148, 16314254, 13837378, 18441944, 23105538, 17291347
17835048, 28254374, 13558557, 21842740, 21656630, 17008068, 17201159
25427662, 17853498, 20717359, 17246576, 18356166, 18681862, 18440047
20569094, 20031873, 16875449, 20387265, 19788842, 17296856, 21330264
14010183, 17648596, 17025461, 17551063, 24719736, 17267114, 21063322
22507210, 17912217, 17889583, 18202441, 17040764, 17478145, 16524926
25655390, 19358317, 22730454, 22148226, 18747196, 26544823, 18641419
17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 17359610
16618694, 8322815, 16832076, 18247991, 16692232, 22507234, 17570240
13871092, 24624166, 26631046, 19429927, 24348685, 17848897, 17441661
14034426, 17465741, 20273319, 19207156, 16596890, 17437634, 21343897
20506706, 18339044, 21453153, 17951233, 21795111, 22321741, 18430495
21787056, 22380919, 19469538, 19692824, 20506715, 17811429, 17903598
19721304, 18230522, 19554106, 19458377, 21281607, 17612828, 6599380
22092979, 17040527, 22321756, 17811438, 18641461, 18682983, 14657740
25635149, 13364795, 19490948, 21387964, 17346671, 17588480, 22351572
18235390, 18849970, 26474853, 17889549, 19309466, 16472716, 25775213
20596234, 18331850, 18641451, 17019356, 17344412, 19461270, 21179898
17546761, 24842886, 17231779, 14521849, 18203835, 18203838, 18964939
18203837, 17313525, 22195457, 18139690, 16837842, 14106803, 22296366
17842825, 22657942, 21352646, 16360112, 22594718, 20657441, 22195441
17389192, 26198926, 14565184, 17019345, 17205719, 18740837, 18440095
14764829, 22195448, 14354737, 17019086, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 27374796, 19972569
19972568, 20144308, 19972566, 17282229, 19972564, 16870214, 16410570
21629064, 19615136, 26039623, 21354456, 17390431, 18762750, 23007241
16613964, 17957017, 18098207, 17484762, 18471685, 19730508, 18264060
21538485, 17323222, 17754782, 17600719, 18317531, 17852463, 17596908
17655634, 18166013, 16228604, 20074391, 27053456, 24790914, 19972570
20856766, 19891090, 18090142, 18996843, 16042673, 19854503, 22901797
17835627, 20334344, 17393683, 20861693, 18000422, 17551709, 26575788
23315889, 20506699, 19006849, 18277454, 18456514, 19174430, 17258090
17174582, 25654936, 17242746, 27097854, 16399083, 17824637, 21132297
22465352, 17762296, 22168163, 18604692, 17397545, 16450169, 12364061
20067212, 18856999, 19211724, 19463893, 19463897, 21343775, 17853456
18673304, 20004021, 26030218, 21668627, 16194160, 17477958, 23140259
16538760, 12982566, 24570598, 20828947, 18259031, 20296213, 28855981
18293054, 17610798, 19699191, 23065323, 17311728, 18135678, 18774543
23294548, 16785708, 10136473, 24560906, 19777862, 22551446, 17786518
25879984, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760
17390160, 18899974, 17232014, 20598042, 26245237, 26679352, 16354467
17484731, 18673325, 16422541, 18155762, 19827973, 14015842, 22683225
17726838, 18554871, 23177648, 18051556, 20803583, 21972320, 15990359
17922254, 18282562, 16855292, 16668584, 21343838, 20299015, 17446237
18043064, 18093615, 23713236, 17694209, 17288409, 20475845, 18308268
17274537, 13955826, 16934803, 17634921, 17501491, 16315398, 23725036
22683212, 17006183, 13829543, 18191164, 26746894, 22809871, 17655240
28819280, 18384391, 19393542, 21538567, 16198143, 21847223, 25823754
17892268, 20142975, 19584068, 17165204, 25165496, 18604493, 21756699
18508861, 18554763, 16901385, 21532755, 18189036, 17443671, 17385178
14829250, 17936109, 20925795, 20509482, 17478514, 27441326, 16850630
13951456, 16595641, 14054676, 15861775, 21142837, 16912439, 17299889
17297939, 23003979, 16833527, 18619917, 17798953, 19697993, 17816865
25914276, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160
17586955, 20558005, 19049453, 21051840, 17587063, 16956380, 18328509
25423453, 29033139, 14133975, 19718981, 18061914, 18522509, 17518652
21051833, 20294666, 18765602, 20860659, 18272672, 20324049, 18199537
17332800, 13609098, 22502493, 18384537, 14338435, 17945983, 16392068
21067387, 17752995, 21051862, 16863422, 17237521, 25505382, 18244962
19544839, 24433711, 24717859, 17156148, 18973907, 23026585, 17449815
17877323, 18180390, 17088068, 17037130, 20004087, 21422580, 19466309
11733603, 25505371, 18610915, 21051858, 18084625, 18674024, 26243698
21051852, 18091059, 18306996, 25369547, 16306373, 17787259, 18193833
19915271, 20513399, 20631274, 16344544, 25879656, 14692762, 18614015
17346091, 18228645, 17721717, 13960236, 18685892, 18436307, 19888853
21756677, 11883252, 17891943, 19475971, 22353199, 16384983, 19121551
25634317, 27825893, 12816846, 17982555, 17761775, 22243719, 17265217
25505394, 17071721, 16721594, 18262334, 21756661, 17891946, 15913355
17672719, 17602269, 17239687, 17042658, 25555252, 17238511, 17811456
17284817, 17752121, 20879889, 28806384, 21380789, 17394950, 17011832
16579084, 22195465, 14602788, 28790634, 18325460, 27567477, 24476265
26569225, 24476274, 12611721, 18674465, 16903536, 17006570, 19689979
28076295, 16043574, 18783224, 24662775, 16494615, 21526048, 17392698
19197175, 16069901, 17811447, 27870645, 28876684, 17308789, 24835538
22195477, 17865671, 17343514, 19013183, 17325413, 18316692, 16180763
17348614, 14368995, 21983325, 17393915, 16285691, 19211433, 20331945
17883081, 17705023, 24316947, 17614227, 19578350, 22195485, 14084247
24975421, 26078387, 23115139, 13645875, 16777840, 19727057, 14852021
18744139, 18674047, 17716305, 19285025, 18482502, 17622427, 19289642
27534509, 25947799, 22195492, 14458214, 20869721, 21172913, 17767676
18723434, 25505407, 17786278, 19258504, 17082983, 17365043, 21351877
13498382, 18331812, 16065166, 25489607, 16685417, 18031668, 22893153
17551674, 16943711, 19272701, 21517440, 25897615, 17649265, 13866822
18094246, 24528741, 17783588, 14245531, 17082359, 18280813, 20448824
23330119, 16268425, 19487147, 25600421, 18018515, 17302277, 17215560
24411921, 19271443, 14176370, 25764020, 17016369, 20777150, 16756406
23330124, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550
13853126, 17227277, 17551699, 23536835, 25957038, 24652769, 20725343
19207117, 9756271, 18868646, 17614134, 26667023, 17546973, 18704244
19680952, 26667015, 17050888, 18273830, 18828868, 17360606, 16992075
24563422, 17375354, 12905058, 18362222, 21429602, 26667032, 28364007
27086138, 17571039, 17468141, 18436647, 17570606, 17235750, 21168487
17279227, 16220077, 16929165
OPatch succeeded.
How to restore oraInst.loc file?
Copy oraInst.loc file from $ORACLE_HOME/oraInst.loc to /var/opt/oracle/oraInst.loc in Solaris or /etc/oraInst.loc in RHEL flavour Linux.