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.
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
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