What is ORACLE_HOME_NAME ?
Each Oracle S/W is given a unique name at time of Database installation which is called as Oracle_home_name and the path at which S/W is installed is known as Oracle_home_Path.For a DBA it’s necessary to know Database Oracle Home Name and it path.
The ORACLE_HOME_NAME is the name of the ORACLE_HOME which was given when the base release is installed (for example, database releases 10.2.0.1 or 126.96.36.199)
If you’ve been tasked with uninstalling or upgrading an existing Oracle application, you might be doing it silently.
Well, one of the fields in the response file is “ORACLE_HOME_NAME“.
How do you find the value of an old Oracle installation’s Home Name?
Easy, go to the “oraInventory/ContentsXML/” directory.
My ORACLE_HOME Directory
My “oraInventory/ContentsXML” directory
When in the ContentsXML directory, view the “inventory.xml” file.
Mine looks like this:
<?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>10.2.0.1.0</SAVED_WITH> <MINIMUM_VER>188.8.131.52.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="Home1" LOC="/u01/app/oracle/product/9.2.0" TYPE="O" IDX="1"/> <HOME NAME="Home1082" LOC="/u01/app/oracle/product/10.2.0" TYPE="O" IDX="2"/> </HOME_LIST> </INVENTORY>
I hope that helps.