Thursday, 9 June 2016

How To Find An Existing ORACLE_HOME_NAME Value

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.
An example:
My ORACLE_HOME Directory
/u01/app/oracle/product/9.2.0/
My "oraInventory/ContentsXML" directory
/u01/app/oracle/oraInventory/ContentsXML/
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>2.1.0.6.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>

No comments:

Post a Comment