R12.2 How To Re-attach Oracle Homes To The Central Inventory

In this Document

Goal

Solution

---

APPLIES TO:

Oracle Applications Manager - Version 12.2.2 and later
Information in this document applies to any platform.

GOAL

This document explains how to re-attach 12.2 EBS Oracle Homes to the central inventory.

There could be a number of reasons why you wish to re-attach the Oracle Homes. It could be that you have experienced one of the following 2 errors during upgrade or Autoconfig runs :

1/ INST-07536 and INST-07531, Middleware home location specified does not have the required Oracle homes installed

 2/ oraInventory/ContentsXML/inventory has no homes listed

  

SOLUTION

Before looking at a solution, let us observe a working inventory.xml file. This file is located in

   10.1.0.6.0
   2.1.0.6.0



  
     
  

  
     
  



  
     
  

  
     
  

Note, we have 4 application tier homes registered per file system, here is an example:

fs1





fs2

Database

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)

/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="" ORACLE_HOME_NAME="Oracle Home Name" CLUSTER_NODES="{}"
/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="" ORACLE_HOME_NAME="Oracle Home Name" CLUSTER_NODES="{}"

e.g.
/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="VIS_TOOLS__u03_VIS_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="VIS_TOOLS__u03_VIS_fs2_EBSapps_10_1_2" CLUSTER_NODES="{}"

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:

/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="" ORACLE_HOME_NAME=""
/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="" ORACLE_HOME_NAME=""

e.g.
/u01/test/fs1/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/VIS/fs1/EBSapps/10.1.2" ORACLE_HOME_NAME="VIS_TOOLS__u03_VIS_fs1_EBSapps_10_1_2"
/u01/test/fs2/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/u01/VIS/fs2/EBSapps/10.1.2" ORACLE_HOME_NAME="VIS_TOOLS__u03_VIS_fs2_EBSapps_10_1_2"

Make sure each ORACLE_HOME_NAME is unique. Once you have completed the steps for all missing Oracle Homes confirm that the inventory.xml file now contains all missing homes. Log files for the attachment process can be found at oraInventory/logs