Environment Details:
Oracle Database 12.1.0.2
Operating System: Linux
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 -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