In this Document
APPLIES TO:Oracle Applications DBA - Version 12.1.1 to 12.1.3 [Release 12.1]Information in this document applies to any platform. GOALHave installed E-Business Suite R12.1.1 vision instance on RHEL 5.3 platform for training purpose for ERP Implementation project.How to find the location of GLOBAL Inventory and LOCAL inventory? In my case there is no /etc/oraInventory directory, why? SOLUTIONTo explain the oraInventory, there are multiple notes explaining about this topic, to make all this clear, this note explains by giving the examples, and the scenarios.There are a few changes between the OraInventory on 11i and R12.1.x, please read the details explaining below (Note 603104.1). REMINDER : The global inventory is found by checking the Inventory Pointer file (oraInst.loc). This can be found as follows: AIX and LINUX under : /etc/oraInst.loc Other UNIX machines : /vat/opt/oracle/oraInst.loc WINDOWS (Registry): HKEY_LOCAL_MACHINE > Software > Oracle > INST_LOC This Inventory pointer points to the location of the Global Inventory. Example: "/etc/oraInst.loc" contains "inventory_loc=/d01/oracle/oraInventory" owned by applmgr, or oracle user, where /d01/oracle/oraInventory is the GLobal Inventory. Example1: ======= If one installed your "R12" into this directory "/VISR12", all your R12's "Global Inventory (oraInventory)" will be are stored there in the "/VISR12" directory. When reading the "oraInst.loc", one should find: more /etc/oraInst.loc inventory_loc=/VISR12/VIS/db/tech_st/11.1.0/admin/oui/VIS_vision/oraInventory" inst_group=dba "/VISR12/VIS/db/tech_st/11.1.0/admin/oui/VIS_vision/oraInventory" is your "Global Inventory " In R12.x, you have "Mulitple" oraInventory in diffrent ORACLE_HOME of FORMS, iAS, RDBMS....this is normal and expected. One has to search the file "orainst.loc" on your System: as root find / -name oraInst.loc -print Once found, do: more orainst.loc you will be informed where is located your global Inventory (oraInventory). Example 2: ======= Cloning : If one wants to Clone, create the NEW directory to create the Cloned environment over there: mkdir /cloneR12 chmod 777 /cloneR12 And the oraInventory of the Cloned instance will be created there under "/cloneR12" directory: inventory_loc=/cloneR12/VIS/db/tech_st/11.1.0/admin/oui/VIS_vision/oraInventory Both directories are tolatlly separated "/VISR12 (SOURCE)" and "/cloneR12(CLONE)". One should not have mismatch between the OraInventory of SOURCE and CLONE environment. QUESTION: There is no /etc/oraInventory directory on my system, why?. ANSWER: Only "root" has write privilege on the "/etc", if running Rapidwiz as "oracle" user, oracle could not. create"oraInst.loc" file, write on "/etc" directory, then Rapiwiz will create "them" under the ORACLE_HOME of FORMS, IAS and RDBMS, why one can find multiple "oraInst.loc" in many locations of R12 system. NOTES: (a) See details in the note below: Note 603104.1 Title: Troubleshooting RapidClone issues with Oracle Applications R12 With Oracle Applications Release 12, this is no longer the case. All dependencies to execute external scripts with root were removed with R12 as part of the design. RapidClone will check the location of the oraInst.loc in the default locations, and check to see the "inventory_loc" location within this file is writable by the current user. If it is not writable, or the files do not exist, then orainst.loc will be from the following locations. Database Tier: <RDBMS $ORACLE_HOME>/oraInst.loc <RDBMS $ORACLE_HOME>/admin/oui/$CONTEXT_NAME/oraInst.loc Applications Tier: $INST_TOP/admin/oraInst.loc $IAS_ORACLE_HOME/oraInst.loc Tools $ORACLE_HOME/oraInst.loc (b) Using "Optach" to find out your OraInventory on your system. Example: cd /oraapp/apps/tech_st/10.1.2/OPatch ./opatch lsinventory -detail -invPtrLoc /oraapp/apps/tech_st/10.1.2/oraInst.loc See The RDBMS Note 413829.1 Opatch Fails With 'Can not get details for given Oracle Home' CLONING OraInventory issues during the EBS cloning, known issue. Example of the errors found: Registering local Oracle Home located at /ora_dev/oracle/dev/10.2.0 to central oracle inventory RC-00127: Remove dependency of OracleHomeCloner: in file oracle.swd.jre Raised by oracle.apps.ad.clone.util.OracleHomeCloner RC-00123: Warning: ORACLE_HOME APPSDB_DEV already exists inside the inventory Registering the OUI component.... DEBUG: 10g OUI exists ... Explanation and Solution: This is the frequent known issue, as the TARGET machine has other Oracle instances installed on it, this means there is OraInventory already existed on the TARGET server. You will hit the problem with the OraInventory REGISTRATION, IF The user doing the cloning has no RW permisson on "/etc/oraInst.loc" or "oraInventory" on the TARGET machine. Missing Write permission granted to the user doing the Cloning, The existing OraInventory on TARGET machine could not be updated during the clone, why The Oracle Home Inventory is Not Synchronized after the clone. To solve this issue, please follow the referenced note below to recreate your Global OraInventory on the TARGET machine(Cloned environment). NOTE: For some additional information on known issues, please see Note 295185.1 How to Recreate the Global oraInventory and Note 603104.1 Troubleshooting RapidClone issues with Oracle Applications R12.0 & R12.1. Search for string oraInventory REFERENCESBUG:10 -NOTE:295185.1 - How to Recreate the Global oraInventory NOTE:360079.1 - Global and Local Inventory explained NOTE:413829.1 - OPatch Fails With 'Can not get details for given Oracle Home' NOTE:452120.1 - How To Locate the Log Files and Troubleshoot Rapid Install for Release 12.0.x and 12.1.x NOTE:564192.1 - FAQs on Central Inventory and Oracle Home Inventory (Local Inventory) in Oracle RDBMS NOTE:603104.1 - Troubleshooting RapidClone issues with Oracle Applications R12.0 & R12.1 NOTE:604125.1 - Fresh R12.0.4 Installation : Errors RW-50004, RW-50010 After Applying The Rapidwiz Patch 6796703 (Rapidwiz version 12.0.4.7) NOTE:742477.1 - How To Create, Update or Rebuild The Central Inventory For Oracle Applications E-Business Suite Release 12 ? NOTE:834894.1 - How to Create a Clean oraInventory in Release 12 |
No comments:
Post a Comment