Steps to Recreate Oracle Central Inventory in Real Applications Clusters(RAC)

Steps to Recreate Oracle Central Inventory in Real Applications Clusters(RAC) 

1-Locate the central inventory. This is platform-specific.

UNIX/Linux:

The central inventory is pointed to by  /etc/oraInst.loc  or  /var/opt/oracle/oraInst.loc  (platform specific)

Windows:

The central inventory should always be located in %SYSTEMDRIVE%\Program Files\Oracle\Inventory - see note 552502.1 .

(This is usually C:\Program Files\Oracle\Inventory but can be located elsewhere if %SYSTEMDRIVE% is not C:)



2-Get the Oracle home names and locations of your Oracle homes by looking in the central inventory's ContentsXML folder at file inventory.xml .

Unix/Linux example:


$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

$ cd /u01/app/oraInventory

$ cd ContentsXML

$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>11.2.0.3.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="Ora11g_gridinfrahome1" LOC="/u01/app/11.2.0.3/grid" TYPE="O" IDX="3" CRS="true">
   <NODE_LIST>
      <NODE NAME="cetrain21"/>
      <NODE NAME="cetrain22"/>
   </NODE_LIST>
</HOME>
<HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0.3/userb" TYPE="O" IDX="4">
   <NODE_LIST>
      <NODE NAME="cetrain21"/>
      <NODE NAME="cetrain22"/>
   </NODE_LIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>



3-Back up the central inventory by moving it to a new location. Repeat this on all the nodes in the cluster.

UNIX/Linux example:

mv oraInventory oraInventory.orig

Windows example:

cd C:\Program Files\Oracle\Inventory
 move C:\Program Files\Oracle\Inventory C:\Program Files\Oracle\Invt_org



4-cd to the OUI bin directory.

Unix/Linux example:

cd $ORACLE_HOME/oui/bin

Windows example:

cd %ORACLE_HOME%\oui\bin



5-Execute runInstaller or setup.exe with attachHome option for OraCrsHome.

Note: The Windows executable is setup.exe, the Unix/Linux command is runInstaller. Other than that, the commands are identical. The steps below use "runInstaller" ; for Windows, substitute "setup.exe".



./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="<oracle or grid home path>" ORACLE_HOME_NAME="<Name of oracleCRSHome>" LOCAL_NODE="<localnode>" CLUSTER_NODES="<nodelist>" CRS=true

example:

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oracle/product/10.2.0/crs_1" ORACLE_HOME_NAME="OraCrs10g_home" LOCAL_NODE="rac1" CLUSTER_NODES="{rac1,rac2}" CRS=true

** Important: Don't forget to include CRS=TRUE for the clusterware/grid home! ***



6-Execute runInstaller with attachHome option for OraDbHome

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="<oracle or grid home path>" ORACLE_HOME_NAME="<Name of oracleHome>" LOCAL_NODE=<localnode> CLUSTER_NODES=<nodelist>

example:

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1" ORACLE_HOME_NAME="OraDb10g_home1" LOCAL_NODE="rac1" CLUSTER_NODES="{rac1,rac2}"



6-Check the central inventory location in all the nodes to make sure the inventory was created.


7-Verify and compare XML files size inside oraInventory/ContentsXML across all the nodes.

appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

Post a Comment

Previous Post Next Post