{"id":4228,"date":"2018-10-26T14:15:16","date_gmt":"2018-10-26T14:15:16","guid":{"rendered":"https:\/\/dbtut.com\/?p=4228"},"modified":"2018-11-27T21:31:27","modified_gmt":"2018-11-27T21:31:27","slug":"oracle-recreate-central-inventory-in-clustareware-in-linux","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/26\/oracle-recreate-central-inventory-in-clustareware-in-linux\/","title":{"rendered":"Oracle – Recreate Central Inventory in Clustareware in Linux"},"content":{"rendered":"
<\/p>\n
In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work<\/span><\/span> for DBAs. It should be used when your inventory is corrupted. For example, you may encounter by executing opatch command.<\/p>\n
opatch lsinventory\r\nOracle Interim Patch Installer version 12.1.0.1.5\r\nCopyright (c) 2018, Oracle Corporation. All rights reserved.\r\n\r\nOracle Home : \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\r\nCentral Inventory : \/u01\/app\/oraInventory\r\nfrom : \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\/oraInst.loc\r\nOPatch version : 12.1.0.1.5\r\nOUI version : 12.1.0.2.0\r\nLog file location : \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\/cfgtoollogs\/opatch\/opatch2018-10-18_10-17-53AM_1.log\r\n\r\nList of Homes on this system:\r\n\r\nInventory load failed... OPatch cannot load inventory for the given Oracle Home.\r\nPossible causes are:\r\nOracle Home dir. path does not exist in Central Inventory\r\nOracle Home is a symbolic link\r\nOracle Home inventory is corrupted\r\nLsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo\r\n\r\nOPatch failed with error code 73<\/pre>\n
<\/p>\n
We assume that you set Oracle Home properly. Therefore, in this situation, you should recreate your inventory.<\/p>\n
Firstly, let’s get our Oracle Homes from our central inventory file. In Linux systems, it is generally pointed to by\u00a0 “\/etc\/oraInst.loc”<\/span><\/p>\n
oracle@orcldb01:~$ cat \/etc\/oraInst.loc\r\ninventory_loc=\/u01\/app\/oraInventory\r\ninst_group=oinstall\r\noracle@orcldb01:~$ cd \/u01\/app\/oraInventory\r\noracle@orcldb01:\/u01\/app\/oraInventory$ cd ContentsXML\r\noracle@orcldb01:\/u01\/app\/oraInventory\/ContentsXML$ cat inventory.xml\r\n<?xml version=\"1.0\" standalone=\"yes\" ?>\r\n<!-- Copyright (c) 1999, 2014, Oracle and\/or its affiliates.\r\nAll rights reserved. -->\r\n<!-- Do not modify the contents of this file by hand. -->\r\n<INVENTORY>\r\n<VERSION_INFO>\r\n<SAVED_WITH>12.1.0.2.0<\/SAVED_WITH>\r\n<MINIMUM_VER>2.1.0.6.0<\/MINIMUM_VER>\r\n<\/VERSION_INFO>\r\n<HOME_LIST>\r\n<HOME NAME=\"OraGI12Home1\" LOC=\"\/u01\/app\/12.1.0.2\/grid\" TYPE=\"O\" IDX=\"1\" CRS=\"true\">\r\n<NODE_LIST>\r\n<NODE NAME=\"orcldb01\"\/>\r\n<NODE NAME=\"orcldb02\"\/>\r\n<\/NODE_LIST>\r\n<\/HOME>\r\n<HOME NAME=\"OraDB12Home1\" LOC=\"\/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\" TYPE=\"O\" IDX=\"2\">\r\n<NODE_LIST>\r\n<NODE NAME=\"orcldb01\"\/>\r\n<NODE NAME=\"orcldb02\"\/>\r\n<\/NODE_LIST>\r\n<\/HOME>\r\n<\/HOME_LIST>\r\n<COMPOSITEHOME_LIST>\r\n<\/COMPOSITEHOME_LIST>\r\n<\/INVENTORY><\/pre>\n
<\/p>\n
We have Grid Home and Oracle Home. Before starting recreation, we must copy original inventory folder from all nodes<\/strong>.<\/p>\n
Go to OUI bin directory and run below commands from first node.<\/p>\n
oracle@orcldb01:~$ cd $ORACLE_HOME\/oui\/bin\r\n.\/runInstaller\r\n -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=\"<grid home path>\" ORACLE_HOME_NAME=\"<Name of oracleCRSHome>\" \r\nLOCAL_NODE=\"<localnode>\" CLUSTER_NODES=\"<nodelist>\" CRS=true\r\n\r\n.\/runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=\"<oracle home path>\" \r\nORACLE_HOME_NAME=\"<Name of oracleHome>\" LOCAL_NODE=<localnode> CLUSTER_NODES=<nodelist>\r\n\r\n***Important***\r\nIn Our Case:\r\nGrid home Path =\/u01\/app\/12.1.0.2\/grid\r\nOracle CRS Home Name =OraGI12Home1\r\nOracle home Path =\/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\r\nOracle Home Name =OraDB12Home1\r\nlocalNode =orcldb01\r\nCluster Nodes = {orcldb01,orcldb02}\r\n\r\nYou must edit these values according to your contents!!!<\/pre>\n
Verify the central inventory location in all the nodes to make sure the inventory was created.<\/span><\/p>\n\n