When running Database Configuration Assistant (dbca) on Exadata compute nodes, you will receive this error if all nodes cannot connect to each other without password for oracle user.
Error
The error message will be as follows:
“[INS-06006] Passwordless SSH connectivity not set up between the following node(s) , node1,node2,node3….”
Solution
All nodes must be able to connect to other nodes using passwordless ssh connection.
The following actions can be taken to resolve this issue.
Create SSH Key
First of all, if there is no ssh key in the relevant nodes, ssh key must be created with oracle user with the command below.
1 |
ssh-keygen -t rsa |
Create a file that includes Host names
A file named dbs_group must be created containing all compute node host names.
The contents of the dbs_group file should be similar to the following.
1 2 3 4 5 6 7 8 |
node1 node2 node3 node4 node5 node6 node7 node8 |
Configure Passwordless SSH Connections
Configure the passwordless ssh connection between your current node and other nodes.
1 |
dcli -g dbs_group -l oracle -k -s '-o StrictHostKeyChecking=no' |
Sample output:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
[oracle@orcldb02 ~]$ dcli -g dbs_group -l oracle -k -s '-o StrictHostKeyChecking=no' oracle@orcldb01's password: oracle@orcldb02's password: oracle@orcldb03's password: oracle@orcldb04's password: oracle@orcldb05's password: oracle@orcldb06's password: oracle@orcldb07's password: oracle@orcldb08's password: orcldb01: ssh key added orcldb02: ssh key added orcldb03: ssh key added orcldb04: ssh key added orcldb05: ssh key added orcldb06: ssh key added orcldb07: ssh key added orcldb08: ssh key added |
Note: The above operation must be repeated on all nodes specified in the error.