Environment Details:
- Oracle Database 12.1.0.2
- Operating System: Linux
Error:
$ cd $ORACLE_HOME/OPatch
$ pwd
/opt/oracle/product/12.1.0.2/OPatch
$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home :
/opt/oracle/product/12.1.0.2
Central Inventory : /opt/oracle/oraInventory
from :
/opt/oracle/product/12.1.0.2/oraInst.loc
OPatch version :
12.2.0.1.8
OUI version :
12.1.0.2.0
Log file location :
/opt/oracle/product/12.1.0.2/cfgtoollogs/opatch/opatch2016-11-23_11-15-31AM_1.log
List of Homes on this system:
Home name= OraDb11g_home1,
Location= "/opt/oracle/product/11.2.0.1"
Home name= OraDb11g_home2,
Location= "/opt/oracle/product/11.2.0.1se"
Home name= OraDb11g_home3,
Location= "/opt/oracle/product/11.2.0.3"
Home name= OraDb11g_home4,
Location= "/opt/oracle/product/11.2.0.3se"
Home name= OraDb11g_home5,
Location= "/opt/oracle/product/11.2.0.4"
LsInventorySession failed: RawInventory gets null OracleHomeInfo
OPatch failed with error code 73
You do not require DB
downtime to attach Oracle Home to Inventory.
Solution:
Step 1: Set below environment variables.
- ORACLE_SID
- ORACLE_HOME
- PATH
Step 2: Go to the below location.
$ cd $ORACLE_HOME/oui/bin
$ pwd
/opt/oracle/product/12.1.0.2/oui/bin
$ ls -ltr
total 948
-rwxr-x--- 1 oracle dba 21862 May 23 2014 runSSHSetup.sh
-rwxr-xr-x 1 oracle dba 658 May 23 2014 filesList.bat
-rwxr-xr-x 1 oracle dba 201 May 23 2014 filesList.properties
-rwxr-xr-x 1 oracle dba 837 May 23 2014 filesList.sh
-rwxr-x--- 1 oracle dba
341624 Jun 18 2014 runInstaller
-rwxr-x--- 1 oracle dba
101472 Oct 31 2014 lsnodes
drwxr-xr-x 2 oracle dba 2048 Oct 17 11:55 resource
-rwxr-x--- 1 oracle dba 190 Oct 17 11:55 detachHome.sh
-rwxr-x--- 1 oracle dba 1564 Oct 17 11:55 runConfig.sh
-rwxr-x--- 1 oracle dba 214 Oct 17 11:55 addLangs.sh
-rwxr-x--- 1 oracle dba 68 Oct 17 11:55 runInstaller.sh
-rwxr-x--- 1 oracle dba 284 Oct 17 11:55 attachHome.sh
$ cat attachHome.sh
#!/bin/sh
OHOME=/opt/oracle/product/12.1.0.2
OHOMENAME=OraDB12Home1
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 $*
cd $CUR_DIR
Step 3: Run below two scripts.
$ ./OraDB12Home1
$ ./attachHome.sh
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 8192 MB Passed
The inventory pointer is located at /var/opt/oracle/oraInst.loc
'AttachHome' was successful.
Step 4: Verify opatch lsinventory once done.
$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home :
/opt/oracle/product/12.1.0.2
Central Inventory : /opt/oracle/oraInventory
from :
/opt/oracle/product/12.1.0.2/oraInst.loc
OPatch version :
12.2.0.1.8
OUI version :
12.1.0.2.0
Log file location :
/opt/oracle/product/12.1.0.2/cfgtoollogs/opatch/opatch2016-11-23_11-17-56AM_1.log
Lsinventory Output file location :
/opt/oracle/product/12.1.0.2/cfgtoollogs/opatch/lsinv/lsinventory2016-11-23_11-17-56AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test01.example.com
ARU platform id: 197
ARU platform description:: HP-UX Itanium
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 24006101 : applied on Wed Oct 19 17:34:20 EDT 2016
Unique Patch ID: 20654854
Patch description:
"Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Created on 6 Oct 2016,
01:18:03 hrs PST8PDT
Sub-patch 23054246;
"Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127;
"Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354;
"Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755;
"Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110;
"Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023;
"Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480;
"Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
21099555, 22175564,
19141838, 22083366, 20842388, 20117253, 19865345
19791273, 19243521,
20951038, 19908836, 21281532, 19238590, 24577566
21184223, 19134173,
20387265, 19149990, 21263635, 18886413, 17551063
22160989, 22507210,
19703301, 19366375, 19001390, 18202441, 20267166
19358317, 19706965,
18549238, 19068970, 18797519, 22148226, 20825533
19649152, 19670108,
18940497, 18948177, 18964978, 19035573, 19176326
20413820, 19176223,
20904530, 20134339, 19074147, 20868862, 18411216
21322887, 22507234,
20425790, 18966843, 21329301, 19333670, 19468991
20124446, 19883092,
19658708, 19591608, 19402853, 20618595, 21787056
22380919, 21266085,
17835294, 19721304, 19791377, 19068610, 22178855
22173980, 20746251,
20048359, 20898391, 19185876, 20281121, 20907061
6599380, 19577410,
22092979, 20603378, 19001359, 19490948, 21387964
20832516, 17532734,
19309466, 19081128, 20627866, 20844426, 21188532
18791688, 21442094,
20890311, 20596234, 18973548, 21296029, 19303936
19461270, 21479753,
20936905, 20235511, 21220620, 18964939, 19430401
22296366, 21153266,
19409212, 22657942, 20657441, 19879746, 19684504
20528052, 19024808,
20977794, 18799993, 20466322, 18740837, 19662635
20228093, 19065556,
20212067, 19524384, 17722075, 20446883, 18952989
16870214, 19928926,
19835133, 21629064, 20466628, 24386767, 19931709
19730508, 18819908,
23124895, 19188927, 20074391, 20356733, 14643995
19547370, 19065677,
21960504, 21225209, 20397490, 18967382, 19174430
21241829, 19536415,
19171086, 22465352, 22168163, 19335438, 20447445
18856999, 20471920,
19869255, 21620471, 18990693, 17890099, 18990023
20101006, 21300341, 20848335,
21744290, 20897759, 21668627, 19304354
19052488, 20794034,
23260854, 18681056, 20952966, 19896336, 18618122
20328248, 20440930,
18456643, 19699191, 19201867, 22865673, 18743542
20798891, 20347562,
22551446, 19777862, 19687159, 21373076, 19174942
20424899, 21899588,
18899974, 20598042, 19032777, 19058490, 22815955
19399918, 19434529,
21273804, 19018447, 22757364, 18851894, 19284031
19022470, 18043064,
20173897, 22062026, 20475845, 17274537, 19440586
16887946, 22374754,
17319928, 20708701, 17655240, 16439813, 19805359
19155797, 20859910,
19393542, 22024071, 17210525, 21847223, 19189525
21649497, 19075256,
22762046, 22075064, 19280225, 18845653, 20560611
19248799, 21756699,
18988834, 20245930, 18921743, 18799063, 20373598
20476175, 19571367,
20925795, 19018206, 20509482, 20711718, 20588502
18849537, 19183343,
21917884, 19189317, 19644859, 19390567, 19279273
20669434, 16863642,
22528741, 19619732, 18607546, 20348653, 19315691
19676905, 20165574,
17867700, 20558005, 20734332, 19532017, 20922010
19450314, 22353346,
20361671, 20009833, 22366558, 20294666, 18191823
19307662, 19371175,
19195895, 20043616, 19154375, 18914624, 20139391
21291274, 19174521,
19520602, 19382851, 21875360, 19676012, 19326908
20217801, 20093776,
21097043, 21246723, 21665897, 19143550, 20428621
19627012, 14283239,
19518079, 18610915, 18674024, 18306996, 19524158
19915271, 20122715,
20284155, 20017509, 19363645, 19597439, 21239530
19888853, 20880215,
21756677, 19534363, 19354335, 19044962, 19639483
22353199, 22243719,
22916353, 20378086, 21756661, 21260431, 22923409
20877664, 19028800,
20879889, 19723336, 19077215, 21421886, 19604659
19308965, 19048007,
18288842, 19689979, 21526048, 19180770, 19197175
19902195, 20318889,
19013183, 19012119, 20464614, 19067244, 21632821
19512341, 19841800,
20331945, 19587324, 24316947, 19578350, 19637186
18674047, 19054077,
20898997, 19708632, 21091431, 19289642, 20869721
19258504, 17365043,
19468347, 21373473, 16359751, 19439759, 19769480
19272708, 19978542,
20402832, 19329654, 19873610, 23229229, 21517440
13542050, 19291380,
21915719, 19076343, 19561643, 19990037, 19487147
18909599, 20831538, 18250893,
19016730, 16619249, 18354830, 21188584
19989009, 17414008,
20688221, 20704450, 20441797, 19157754, 18885870
21785691, 21450666,
18893947, 18705806, 22223463, 16923858, 18417036
20919320, 20474192,
22046677, 19385656, 19501299, 20920911, 20899461
21387128, 21315084,
18122373, 20581111, 19606174, 18436647, 19023822
19178851, 19124589,
19597583, 18499088, 19050649
--------------------------------------------------------------------------------
OPatch succeeded.
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !
super document Sir.... :-)
ReplyDelete