Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in:
  • HP/Solaris /var/opt/oracle/oraInst.loc
  • Linux /etc/oraInst.loc
  • Windows \\HKEY_LOCAL_MACHINE\Software\Oracle\inst_loc
To check if all oracle homes are registered within the Central Inventory run the following command:
${ORACLE_HOME}/oui/bin/opatch lsinventory -all
Invoking OPatch

Oracle interim Patch Installer version
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /software/oracle/OEM10gR2/agent10g
Central Inventory : /software/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version :
OUI version :
OUI location : /software/oracle/OEM10gR2/agent10g/oui
Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log

Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt
List of Oracle Homes:
Name Location
agent10g /software/oracle/OEM10gR2/agent10g
bzq18i /software/oracle8i
8i32bit /software/oracle/
oracle9207 /software/oracle/
oracle9205 /software/oracle/
OPatch succeeded.
If oracle home is missing in the Central Inventory , attach it by the following command:
${ORACLE_HOME}/oui/bin/runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="oracle home location" ORACLE_HOME_NAME="a name" CLUSTER_NODES="{}"
If you have problems while trying to attach a 9.2 home to the Central Inventory, read note 457457.1
To manual load the updated inventory to the OEM, use the command:
emctl control agent runCollection:host Inventory
To remove incorrect oracle home ftom the Central Inventory, run the command:
${ORACLE_HOME}/oui/bin/runInstaller -silent -detachHome ORACLE_HOME="oracle home location" ORACLE_HOME_NAME="a name"


Post a Comment

Popular posts from this blog

List RMAN backups size

Change Listener Ports in RAC Environment