Helpful Oracle hints I've found and saved

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>

I hope that helps someone else.

Thanks to http://www.oracle-base.com/forums/viewtopic.php?f=1&t=8831

2 Responses to “How To Find An Existing ORACLE_HOME_NAME Value”

  1. little-E says:

    Thanks, that helps a lot. Most of my google search results for ORACLE_HOME_NAME said to login as oracle and basically "echo $ORACLE_HOME_NAME", which is not set in my environment.

Leave a Reply to little-E Cancel reply

Powered by WordPress | Designed by Elegant Themes

Pin It on Pinterest

Shares
Share This