Update RAC nodelist using runInstaller -updateNodeList

Last week i tried to apply the the patchset 10.2.0.3 on my RAC.
The CRS was successfully patched to 10.2.0.3
But when tried to patch the RDBMS, the OUI did not recognise the ORACLE_HOME as a cluster installation.

So, checked with opatch to see whether the inventory was corrupted.
$ cd /u01/app/oracle/product/10.2.0/db_1/OPatch
$./opatch lsinventory -detail

Invoking OPatch 10.2.0.2.0

Oracle interim Patch Installer version 10.2.0.2.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/10.2.0/db_1/oraInst.loc
OPatch version : 10.2.0.2.0
OUI version : 10.2.0.2.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui

——————————————————————————–
Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0
There are 2 products installed in this Oracle Home.

Installed Products (168):

Agent Required Support Files 10.2.0.1.0
Agent Required Support Files Patch
.
.
.
.

Patch 5117016 : applied on Wed Jul 19 19:48:22 JST 2006
Created on 30 Mar 2006, 12:52:17 hrs US/Pacific
Bugs fixed:
5117016
Files Touched:
ins_rdbms.mk –> ORACLE_HOME/rdbms/lib/ioracle
Patch Location in Inventory:
/u01/app/oracle/product/10.2.0/db_1/inventory/oneoffs/5117016
Patch Location in Storage area:
/u01/app/oracle/product/10.2.0/db_1/.patch_storage/5117016_Mar_30_2006_12_52_17

——————————————————————————–

OPatch succeeded.
$

Oops!!! where are the RAC details ?

Then i checked the central inventory file [/u01/app/oracle/oraInventory/ContentsXML/inventory.xml] for the cluster details

$ cat /u01/app/oracle/oraInventory/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.2.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”OraCrs10g_home1″ LOC=”/u01/app/oracle/product/crs” TYPE=”O” IDX=”1″ CRS=”true”>
<NODE_LIST>
<NODE NAME=”node01″/>
<NODE NAME=”node02″/>
</NODE_LIST>
</HOME>
<HOME NAME=”agent10g” LOC=”/u01/app/oracle/product/agent10g” TYPE=”O” IDX=”3″>
<NODE_LIST>
<NODE NAME=”node01″/>
<NODE NAME=”node02″/>
</NODE_LIST>
</HOME>
<HOME NAME=”OraDb10g_home2″ LOC=”/u01/app/oracle/product/10.2.0/db_1″ TYPE=”O” IDX=”2″/>
<HOME NAME=”OraDb10g_home3″ LOC=”/u01/app/oracle/product/10.2.0/db_2″ TYPE=”O” IDX=”4″/>
<HOME NAME=”OraDb10g_home3″ LOC=”/u01/app/oracle_dg/product/10.2.0/db_1″ TYPE=”O” IDX=”5″ REMOVED=”T”/>
</HOME_LIST>
</INVENTORY>
$
$

OraDb10g_home2 is the RAC RDBMS home and there isn’t any nodelist associated with it.

I also checked the local inventory file [/u01/app/oracle/product/10.2.0/db_1/inventory/ContentsXML/oraclehomeproperties.xml]

$ cat /u01/app/oracle/product/10.2.0/db_1/inventory/ContentsXML/oraclehomeproperties.xml
<?xml version = ‘1.0′ encoding = ‘UTF-8′?>
<!– Copyright (c) 2005 Oracle Corporation. All rights Reserved –>
<!– Do not modify the contents of this file by hand. –><ORACLEHOME_INFO>
<GUID>1389252986.348583676</GUID>
<HOME/>
<ARU_PLATFORM_INFO>
<ARU_ID>23</ARU_ID>
<ARU_ID_DESCRIPTION>Solaris Operating System (SPARC 64-bit)
</ARU_ID_DESCRIPTION>
</ARU_PLATFORM_INFO>
</ORACLEHOME_INFO>
$
$

There were no trace of the cluster here too.

It was the same in the node2 too

Though not sure on how the cluster details faded away from these files i decided to update the inventory running ‘runInstaller -updateNodeList‘ explicitly on both the nodes

http://download.oracle.com/docs/cd/B19306_01/em.102/b16227/oui3_manage_oracle_homes.htm#CJADBAHJ

./runInstaller -updateNodeList CLUSTER_NODES=node01,node02 ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 -local

Then i checked the opatch lsinventory and the central and local inventories..

$ ./opatch lsinventory -detail
Invoking OPatch 10.2.0.2.0

Oracle interim Patch Installer version 10.2.0.2.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/10.2.0/db_1/oraInst.loc
.
.
.
.
.
Patch 5117016 : applied on Wed Jul 19 19:48:22 JST 2006
Created on 30 Mar 2006, 12:52:17 hrs US/Pacific
Bugs fixed:
5117016
Files Touched:
ins_rdbms.mk –> ORACLE_HOME/rdbms/lib/ioracle
Patch Location in Inventory:
/u01/app/oracle/product/10.2.0/db_1/inventory/oneoffs/5117016
Patch Location in Storage area:
/u01/app/oracle/product/10.2.0/db_1/.patch_storage/5117016_Mar_30_2006_12_52_17

Rac system comprising of multiple nodes
Local node = node01
Remote node = node02

——————————————————————————–

OPatch succeeded.
$
Hurray!!! its updated ))

Central Inventory
—————–

$ cat /u01/app/oracle/oraInventory/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.2.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”OraCrs10g_home1″ LOC=”/u01/app/oracle/product/crs” TYPE=”O” IDX=”1″ CRS=”true”>
<NODE_LIST>
<NODE NAME=”node01″/>
<NODE NAME=”node02″/>
</NODE_LIST>
</HOME>
<HOME NAME=”agent10g” LOC=”/u01/app/oracle/product/agent10g” TYPE=”O” IDX=”3″>
<NODE_LIST>
<NODE NAME=”node01″/>
<NODE NAME=”node02″/>
</NODE_LIST>
</HOME>
<HOME NAME=”OraDb10g_home2″ LOC=”/u01/app/oracle/product/10.2.0/db_1″ TYPE=”O” IDX=”2″>
<NODE_LIST>
<NODE NAME=”node01″/>
<NODE NAME=”node02″/>
</NODE_LIST>
</HOME>
<HOME NAME=”OraDb10g_home3″ LOC=”/u01/app/oracle/product/10.2.0/db_2″ TYPE=”O” IDX=”4″/>
<HOME NAME=”OraDb10g_home3″ LOC=”/u01/app/oracle_dg/product/10.2.0/db_1″ TYPE=”O” IDX=”5″ REMOVED=”T”/>
</HOME_LIST>
</INVENTORY>
$
$
See the nodelist associated with OraDb10g_home2.

Local Inventory
—————-
$ cat /u01/app/oracle/product/10.2.0/db_1/inventory/ContentsXML/oraclehomeproperties.xml
<?xml version = ‘1.0′ encoding = ‘UTF-8′?>
<!– Copyright (c) 2005 Oracle Corporation. All rights Reserved –>
<!– Do not modify the contents of this file by hand. –><ORACLEHOME_INFO>
<GUID>1389252986.348583676</GUID>
<HOME/>
<ARU_PLATFORM_INFO>
<ARU_ID>23</ARU_ID>
<ARU_ID_DESCRIPTION>Solaris Operating System (SPARC 64-bit)
</ARU_ID_DESCRIPTION>
</ARU_PLATFORM_INFO>

<CLUSTER_INFO><LOCAL_NODE NAME=”node01″/><NODE_LIST><NODE NAME=”node01″/><NODE NAME=”node02″/></NODE_LIST></CLUSTER_INFO></ORACLEHOME_INFO>
$
$

See the cluster details are updated.

Then i confirmed with the OUI and it selected both the nodes to upgrade

---

Possibly related posts: (automatically generated)

• Installing BUG fix 5749953-ONS SIGBUS ERROR AFTER INSTALL PATCHSET 10.2.0.3…
• Relink -ing binaries of Oracle RDBMS and Oracle Agent
• Configure heterogeneous connection from Oracle DB to PostgreSQL DB