CLUSTER NODES details picked by OUI from ORACLE_HOME location

I was trying to simulate a live issue in our test RAC database server. we have 3 node RAC database, when we are trying to upgrade the cluster database from Oracle 10204 to 10205. we got in to some corruption issues on the sys tables. so we have planned to take the live copy of ORACLE_HOME and system related tablespaces to the our test server.

our test server has similar step to the live database. so we have copied the live RDBMS binaries(10204 Binaries) & oracle inventory & RMAN system related tablespaces from the live database.

1) we have restored the live copy of RDBMS binaries & oracle inventory
2) we have relink the RDBMS binary
3) when we start the upgrade process through OUI. on the cluster page, i could see the LIVE CLUSTER NODE Names & TEST CLUSTER NODE Names
4) i was getting 6 nodes instead of 3 nodes.

After doing alot of research, i found the place where the OUI picks the cluster node details from the Oracle RDBMS Binaries.

you can find the file from
$ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

cd $ORACLE_HOME/inventory/ContentsXML> cat oraclehomeproperties.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved -->
<!-- Do not modify the contents of this file by hand. -->
<ORACLEHOME_INFO>
   <GUID>392927504#.#1664361443</GUID>
   <HOME/>
   <ARU_PLATFORM_INFO>
      <ARU_ID>226</ARU_ID>
      <ARU_ID_DESCRIPTION>Linux x86-64</ARU_ID_DESCRIPTION>
   </ARU_PLATFORM_INFO>
   <CLUSTER_INFO>
      <LOCAL_NODE NAME="bhuvan1"/>
      <NODE_LIST>
         <NODE NAME="bhuvan1"/>
         <NODE NAME="bhuvan2"/>
         <NODE NAME="bhuvan3"/>
      </NODE_LIST>
   </CLUSTER_INFO>
</ORACLEHOME_INFO>

NOTE: Take a backup of oraclehomeproperties.xml file before modify anything on it.

you can find the CLUSTER NODE DETAILS for CRS_HOME,ASM & RDBMS in the central inventary home

Go To CENTRAL INVENTORY HOME

$CENTRAL_INVENTORY_HOME/ContentsXML/inventory.xml

cat $CENTRAL_INVENTORY_HOME/ContentsXML/inventory.xml

<?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="OraCrs10g_home" LOC="/opt/oracle/product/CRS10gR2" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="bhuvan1"/>

      <NODE NAME="bhuvan2"/>

      <NODE NAME="bhuvan3"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraASM10g_home2" LOC="/opt/oracle/product/ASM10gR2" TYPE="O" IDX="3">

   <NODE_LIST>

      <NODE NAME="bhuvan1"/>

      <NODE NAME="bhuvan2"/>

      <NODE NAME="bhuvan3"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraDb10g_home1" LOC="/opt/oracle/product/DB10gR2" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="bhuvan1"/>

      <NODE NAME="bhuvan2"/>

      <NODE NAME="bhuvan3"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

</INVENTORY>

you can find the Oracle cluster node details for ASM on the below directory

$ASM_HOME/inventory/ContentsXML/oraclehomeproperties.xml

Hope it you. Happy learning :) :)