DBCA: Node Selection Page Does Not Show All Nodes in the Cluster or Custer Nodes Are Not Accessible－DanBrother的部落格

Issue:
DBCA: Node Selection Page Does Not Show All Nodes in the Cluster or Custer Nodes Are Not Accessible due to upper case or lower case differences.

For instance, the following nodes name come from the file $ORACLE_BASE/oraInventory/ContentsXML/inventory.xml

Examine this file, you will see the tag below (the second HOME tag):

<NODE_LIST>
<NODE NAME="rac01"/>
<NODE NAME="rac02"/>
<NODE NAME="RAC03"/>
<NODE NAME="RAC04"/>
</NODE_LIST>
</HOME>

Note the RAC03 and RAC04 presenting in different case with rac01 and rac02.
This causes the node RAC03 & RAC04 unavaliable in DBCA.
However, do not modify this file directly.

Solution:
Run the following procedure on the node from where DBCA is launched:
a) From an X-Window enabled session (ReflectionX, VNC, etc.)
b) Log in as oracle
c) Set you ORACLE_HOME to the db_home
d) cd $ORACLE_HOME/oui/bin
e) Execute:
       ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME \
        CLUSTER_NODES=<list all nodes here, separated by commas>

e.g.
$ORACLE/HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES=rac01,rac02,rac03,rac04