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 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
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 : 10.2.0.3.0
OUI version : 10.2.0.3.0
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/8.1.7.4_32
oracle9207 /software/oracle/9.2.0.7
oracle9205 /software/oracle/9.2.0.5
.
.
.
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"

Comments

Anonymous said…
Nice !

Popular posts from this blog

Export in Pl/Sql via DBMS_DATAPUMP