Wednesday, March 22, 2017

Change the host name from uppercase to lowercase (correct one) in central inventory

One of node name in my RAC setup was appearing in UPPERCASE ( wrong one), let's try to correct this.


1. opatch lsinventory shows one node in uppercase (incorrect one) and the other node in lowercase (correct one) 

$ opatch lsinventory 
Oracle Grid Infrastructure 11g                                       11.2.0.2.0
There are 1 product(s) installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac1
Remote node = RAC2                   <<<<< Uppercase, incorrect one.


2. From the central inventory, it shows an uppercase hostname.

$ cat /u01/app/oraInventory/ContentsXML/inventory.xml
...
<HOME NAME="Ora11g_gridinfrahome1" LOC="/u01/app/11.2.0/grid" TYPE="O" IDX="1" CRS="true">
   <NODE_LIST>
      <NODE NAME="rac1"/>
      <NODE NAME="RAC2"/> >>upper case, incorrect
   </NODE_LIST>
</HOME>...


To change the hostname from uppercase to lowercase for a particular ORACLE_HOME:

1. Run the following command on each node to rectify the uppercase host name in the inventory, as the software owner:


$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=" /u01/app/11.2.0/grid" "CLUSTER_NODES={rac1,rac2}"   -silent -local


2. Verify the changes by repeating the command "opatch lsinventory" and "cat oraInventory/ContentsXML/inventory.xml"


No comments:

Post a Comment