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

Advertisements

2 thoughts on “Update RAC nodelist using runInstaller -updateNodeList

  1. Pingback: Installing patchset 10.2.0.3 on RAC « My confrontations with oracle

  2. Pingback: Index « My confrontations with oracle

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