What is ORACLE_HOME_NAME and How to Find it ?


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 11.1.0.6)

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s