dbca not show remote node

admin

Applies to:
Oracle Database Configuration Assistant - Version 10.2.0.1 and later
Information in this document applies to any platform.
Symptoms

Trying to create a clustered database, but Database Configuration Assistant (DBCA) does not show all the nodes in the cluster:


   

$CRS_HOME/bin/olsnodes does show all nodes, but DBCA does not.


Looked at Note 270048.1 {Node Selection Screen Does Not Show The Nodenames Installing 9205 (OUI 10g)}
and although it mentions the fix, it is worded too specifically for 9205 and/or includes additional steps
for another issues.
That is why I decided to create this note that is broader to include 10g and 11g and only to list the
issue why DBCA would not list all nodes that are part of the cluster.

[This section is not visible to customers.]

Changes


Cause

The cause of why the $ORACLE_BASE/oraInventory/ContentsXML/inventory.xml file does not contain all nodes is unknown; however the following steps help discover where is the issue.

Looked at the DBCA log file which is located under $ORACLE_BASE/cfgtoollogs/dbca directory (11g) or $ORACLE_HOME/cfgtoollogs/dbca directory (10g), and shows:
trace.log_OraDb11g_home1
~~~~~~~~~~~~~~~~~~~~~~~~~~
...
[main] [8:12:47:338] [Host.setNodeNames:2011] Setting nodeNames.length: 1 <-- should be >1
...
[AWT-EventQueue-0] [8:12:55:629] [OPSNodeListPage.initializePage:266] initializePage: m_nodeNames[0]=mynode1 <-- Only one line shown for node1. We are missing similar lines for remaining nodes.
...


Looking into the contents of $ORACLE_BASE/oraInventory/ContentsXML/inventory.xml which is used by olsnodes as well as by DBCA.

- For the Oracle home used by the DBCA, notice that all the nodes of the cluster will not be listed:
<HOME NAME="OUIHome2" LOC="<ORACLE_HOME>" TYPE="O" IDX="2">
<NODE_LIST>
<NODE NAME="mynode1"/>
</NODE_LIST>
</HOME>


The RDA also shows inventory.xml data:
- Click "Oracle Installation" under the section "RDA 4.10 Main Index"
- Click on "inventory.xml File" under "Oracle Installer"

Also sometimes the Oracle Home is installed only on one node. In this case will need to use addnode.sh to extend the $Oracle_Home inventory to the remote node.


Note: A new issue that also reported similar situation, had to do with improper SSH (Secure Shell) configuration. Please check the Oracle install guide for details on how to manually configure SSH.

如果ssh调整了非默认端口，例如9936，需要修改/etc/services中的ssh端口，本案例修改端口后恢复正常，将inventory.xml复原后也能正常显示remote node



Solution

Do not directly edit manually the inventory.xml file!

Instead 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> \
        LOCAL_NODE=<list local node where the command is executed> -local


The inventory should now list both nodes in the local node's inventory.xml and for the db_home.
Now launch DBCA and all nodes in the cluster should be listed in DBCA's Node Selection page.

If not, repeat steps a~e on each node where inventory.xml needs to be corrected.