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



Last updated on August 27th, 2016 at 04:51 am

In R12.1 , we have just two application home (10.1.2) and (10.1.3)  and database home registered in central inventory. Due to dual filesystem and weblogic inclusion, this has undergone drastic changes,  We have now 4 oracle home per filesystem registered in central inventory and one database home.This articles 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 inventorty

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.

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

Related Articles

How to recreate central inventory in Rela applications cluster

Oracle E-buisness Suite Architecture in R12.2

Adop explained R12.2

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 database oracle home

In case  Oracle Universal Installer cannot identify the Central Inventory though 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


Leave a Reply