Home » Oracle » Oracle Ebuisness Suite » How to re-attach 12.2 E-Business Oracle Homes to the central inventory

How to re-attach 12.2 E-Business Oracle Homes to the central inventory

Leave a Comment / By /

In R12.1, we have just two applications homes (10.1.2) and (10.1.3)  and database homes registered in central inventory. Due to dual filesystem and weblogic inclusion, this has undergone drastic changes,  We have now 4 Oracle homes per filesystem registered in central inventory and one database home. This article presents How to re-attach 12.2 E-Business Oracle Homes to the central inventory

A working inventory.xml  file in R12.2 looks like

<HOME_LIST>
<HOME NAME="OraDb11g_home1" LOC="/u000/TEST/11.2.0" TYPE="O" IDX="1"/>
<HOME NAME="OH481075858" LOC="/u000/TEST/fs1/FMW_Home/oracle_common" TYPE="O" IDX="5">
 <REFHOMELIST>
 <REFHOME LOC="/u000/TEST/fs1/FMW_Home/webtier"/>
 </REFHOMELIST>
</HOME>
<HOME NAME="OH657355352" LOC="/u000/TEST/fs1/FMW_Home/webtier" TYPE="O" IDX="6">
 <DEPHOMELIST>
 <DEPHOME LOC="/u000/TEST/fs1/FMW_Home/oracle_common"/>
 </DEPHOMELIST>
</HOME>
<HOME NAME="u03_TEST_fs1_Oracle_EBS_app" LOC="/u000/TEST/fs1/FMW_Home/Oracle_EBS-app1" TYPE="O" IDX="7"/>
<HOME NAME="TEST_TOOLS__u03_TEST_fs1_EBSapps_10_1_2" LOC="/u000/TEST/fs1/EBSapps/10.1.2" TYPE="O" IDX="8"/>
<HOME NAME="OH548082611" LOC="/u000/TEST/fs2/FMW_Home/oracle_common" TYPE="O" IDX="1">
 <REFHOMELIST>
 <REFHOME LOC="/u000/TEST/fs2/FMW_Home/webtier"/>
 </REFHOMELIST>
</HOME>
<HOME NAME="OH339717001" LOC="/u000/TEST/fs2/FMW_Home/webtier" TYPE="O" IDX="2">
 <DEPHOMELIST>
 <DEPHOME LOC="/u000/TEST/fs2/FMW_Home/oracle_common"/>
 </DEPHOMELIST>
</HOME>
<HOME NAME="OH2040000521" LOC="/u000/TEST/fs2/FMW_Home/Oracle_EBS-app1" TYPE="O" IDX="3"/>
<HOME NAME="TEST_TOOLS__u03_TEST_fs2_EBSapps_10_1_2" LOC="/u000/TEST/fs2/EBSapps/10.1.2" TYPE="O" IDX="4"/>
</HOME_LIST>

As we can see we have 4 application tier homes registered per file system in the inventory

fs1
<HOME NAME="OH489865858" LOC="/u000/TEST/fs1/FMW_Home/oracle_common" TYPE="O" IDX="5">
<HOME NAME="OH65735875352" LOC="/u000/TEST/fs1/FMW_Home/webtier" TYPE="O" IDX="6">
<HOME NAME="u03_TEST_fs1_Oracle_EBS_app" LOC="/u000/TEST/fs1/FMW_Home/Oracle_EBS-app1" TYPE="O" IDX="7"/>
<HOME NAME="TEST_TOOLS__u03_TEST_fs1_EBSapps_10_1_2" LOC="/u000/TEST/fs1/EBSapps/10.1.2" TYPE="O" IDX="8"/>
fs2
<HOME NAME="OH548082[[611" LOC="/u000/TEST/fs2/FMW_Home/oracle_common" TYPE="O" IDX="1">
<HOME NAME="OH3397517001" LOC="/u000/TEST/fs2/FMW_Home/webtier" TYPE="O" IDX="2">
<HOME NAME="OH20400550521" LOC="/u000/TEST/fs2/FMW_Home/Oracle_EBS-app1" TYPE="O" IDX="3"/>
<HOME NAME="TEST_TOOLS__u03_TEST_fs2_EBSapps_10_1_2" LOC="/u000/TEST/fs2/EBSapps/10.1.2" TYPE="O" IDX="4"/>
Database
<HOME NAME="OraDb11g_home1" LOC="/u000/TEST/11.2.0" TYPE="O" IDX="1"/>

You can re-register any one of the 3 FMW application tier homes as follows. Important, you must run these for both file systems (fs1 and fs2)

Usage of each of these

  • Oracle Application Server Developer Tools(10.12): Contains the files required to run Forms and Reports.
  • Oracle_EBS-app1: Oracle E-Business Suite is deployed as an Oracle Home under Fusion Middleware (FMW). This directory contains all the configuration files related to oacore, forms, oafm, and forms-c4ws.
  • webtier: Contains the HTTP server instance used by EBS. All the HTTP-specific configuration and log files are located here.
  • oracle_common: Contains all the Java Required Files (JRFs) needed by Oracle E-Business Suite.
See also  Oracle ASM Diskgroups : Create and Alter diskgroup

How to re-attach 12.2 E-Business Oracle Homes to the central inventory

How to register the FMW Home

By FMW home,i mean the webtier,oracle_common and Oracle_EBS-app1

<path to fs1>/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="<path to Oracle Home>" ORACLE_HOME_NAME="Oracle Home Name" CLUSTER_NODES="{}"
<path to fs2>/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="<path to Oracle Home>" ORACLE_HOME_NAME="Oracle Home Name" CLUSTER_NODES="{}"
For example
/u01/test/fs1/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/test/fs1/FMW_Home/oracle_common" ORACLE_HOME_NAME="TEST_TOOLS__u03_TEST_fs1_EBSapps_10_1_2" CLUSTER_NODES="{}"
/u01/test/fs2/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/test/fs1/FMW_Home/oracle_common" ORACLE_HOME_NAME="TEST_TOOLS__u03_TEST_fs2_EBSapps_10_1_2" CLUSTER_NODES="{}

How to register the 10.12 Home

If you need to register the tools (10.1.2) home you can use these commands, again you will need to run this for both fs1 and fs2:

<path to fs1>/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="<path to the 10.1.2 Home>" ORACLE_HOME_NAME="<Oracle Home Name>"
<path to fs2>/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="<path to the 10.1.2 Home>" ORACLE_HOME_NAME="<Oracle Home Name>"
Example
/u01/test/fs1/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/TEST/fs1/EBSapps/10.1.2" ORACLE_HOME_NAME="TEST_TOOLS__u03_TEST_fs1_EBSapps_10_1_2"
/u01/test/fs2/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/TEST/fs2/EBSapps/10.1.2" ORACLE_HOME_NAME="TEST_TOOLS__u03_TEST_fs2_EBSapps_10_1_2"

Following things need to be taken care while registering oracle home
1) Oracle home name must be unique
2) It must be registered from both the filesystem
3) Inventory should be taken backup before updating the entries

How to build a new Central Inventory from scratch in case the central inventory is corrupted and things are not working fine

(1)Create a new directory to hold the new Central Inventory, or empty the existing one after backing up its contents, and set its permissions.

Example:
mkdir /u00/oracle/oraInventory
chmod 777 /u00/oracle/oraInventory

(2) Verify or modify the oraInst.loc file, for its location see the Introduction, so ‘inventory_loc’ points to the directory created in step 1.

Example:
inventory_loc=/u00/oracle/oraInventory

(3) Register the Oracle Home using the command given above for both fs1 and fs2 and the database Oracle home

See also  How to get the outline hint in oracle and use for tuning

In case  Oracle Universal Installer cannot identify the Central Inventory through the oraInst.loc in the default location, the following argument can be used:
-invPtrLoc <Inventory-Pointer-Location-File>

For example
runInstaller -invPtrLoc /u01/oracle/PROD/fs1/EBSapps/10.1.2/oraInst.loc

Related Articles

How to recreate central inventory in Real applications cluster
Oracle E-business Suite Architecture in R12.2
Adop explained R12.2

Related Posts

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top