Sunday, January 25, 2009

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}/opatch/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.1To 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"

No comments: