We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| oraInventory in Oracle |
| Thursday, December 14, 2006 |
|
You all might be familiar with oraInventory & its importance so lets take a look at few common things about it like binary/xml inventory, What to do if Inventory is corrupted , What is global / Local Inventory and where to find documentation related to oraInventory .
What is oraInventory ?
oraInventory is repository (directory) which store/records oracle software products & their oracle_homes location on a machine. This Inventory now a days in XML format and called as XML Inventory where as in past it used to be in binary format & called as binary Inventory.
There are basically two kind of Inventory Global Inventory (also called as Central Inventory) and Local Inventory also called as Oracle Home Inventory.
Global Inventory ?
Global Inventory holds information about Oracle Products on a Machine. These products can be various oracle components like database, oracle application server, collaboration suite, soa suite, forms & reports or discoverer server . This global Inventory location will be determined by file oraInst.loc in /etc (on Linux) or /var/opt/oracle (solaris). If you want to see list of oracle products on machine check for file inventory.xml under ContentsXML in oraInventory (Please note if you have multiple global Inventory on machine check all oraInventory directories)
You will see entry like
HOME NAME="ORA10g_HOME" LOC="/u01/oracle/10.2.0/db" TYPE="O" IDX="1"/
...
...
Local Inventory
Inventory inside each Oracle Home is called as local Inventory or oracle_home Inventory. This Inventory holds information to that oracle_home only.
Can I have multiple Global Inventory on a machine ?
Quite common questions is that can you have multiple global Inventory and answer is YES you can have multiple global Inventory but if your upgrading or applying patch then change Inventory Pointer oraInst.loc to respective location. If you are following single global Inventory and if you wish to uninstall any software then remove it from Global Inventory as well.
What to do if my Global Inventory is corrupted ?
No need to worry if your global Inventory is corrupted, you can recreate global Inventory on machine using Universal Installer and attach already Installed oracle home by option
-attachHome
./runInstaller -silent -attachHome -invPtrLoc $location_to_oraInst.loc
ORACLE_HOME="Oracle_Home_Location" ORACLE_HOME_NAME="Oracle_Home_Name"
CLUSTER_NODES="{}"
Do I need to worry about oraInventory during oracle Apps 11i cloning ?
No, Rapid Clone will update both Global & Local Inventory with required information , you don't have to worry about Inventory during Oracle Apps 11i cloning.
Those of you who have registered email notification and not receiving any mails, drop me a mail at atul_iiit@yahoo.com
Your comments are quite important to me so leave comments about posts , suggestions, criticism, topics you want to hear or any thing about this post ....Labels: basics |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 3:41 PM
  |
|
| 11 Comments: |
-
thanks for the supprt Mr.ATUL can u give some information abt configuring standby database in the coming posts
cheers
chandoo
-
-
Good Post,Simple and clear-cut explanation about oraInventory.
Sam
http://appsdbablog.com
-
Thanks Sam,
I often read your blog , they are quite interesting. Good to hear from you .
Atul
-
Hi Atul
We are trying to attach a home to orainventory which was created jus by copying an oracle home. Can u plz help me with this....
Rupa.
-
Rupa,
Could you try ./runInsaller with option mentioned in pos & let me know if you face any issues .
Atul
-
Atul,
I was trying to use runInstaller (10.2 version as 9i doesn't have attachHome ability) to attach a 9.2.0.8 home on Solaris.
The session failed with the following:
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /var/opt/oracle/oraInst.loc
The inventory is located at /opt/oracle/oraInventory
'AttachHome' failed.
Wonder if you had such experience, i.e. attach 9208 home via 10.2.0.3 runInstaller?
Thanks.
-
Hi Anonymous for any issues you can raise them at forum http://teachMeOracle.com/forum
Atul
-
We are upgrading 11.5.10 running on 9.2.0.8 to 10g Databases, Is it recommend to maintain new inventory for 10g RDBMS or Just have the inventory under exiting inventory.
-
Hi Atul,
It's a damn good post for which i'm awaiting a long.....
I got so much here/../.
Keep posting
-
|
| |
| << Home |
| |
|
|
thanks for the supprt Mr.ATUL can u give some information abt configuring standby database in the coming posts
cheers
chandoo