- How to bulk detach / attach databases in SQL Server - February 2, 2024
- How to enforce password policy in an Oracle database - 4 January 2024
- How do we change the name of the user / schema in an Oracle database - 1 December 2023
In this article we will see what to do if during the installation of Oracle Grid Infrastructure on Unix we get an error when we try to Setup SSH connectivity.
When we select in the following tab the SSH connectivity and Setup for communication between nodes:
After a while we get the following error:
ERROR [INS-06003] Failed to setup passwordless SSH connectivity
How to fix error [INS-06003]
To establish connectivity between oracledev1 and oracledev2, we connect to each node and run the following.
In the oracledev1 (node1):
su oracle cd $HOME chmod 700 ~/.ssh /usr/bin/ssh-keygen -t rsa cd ~/.ssh cat id_rsa.pub >> authorized_keys scp authorized_keys oracledev2:/home/oracle/.ssh/
In the oracledev2 (node2):
su oracle cd $HOME chmod 700 ~/.ssh /usr/bin/ssh-keygen -t rsa cd ~/.ssh cat id_rsa.pub >> authorized_keys scp authorized_keys oracledev1:/home/oracle/.ssh/
Then we choose no on the same tab Setup this time but the choice Test, but after we have first selected the checkbox Reuse private and public keys existing in the user home that we made manually.
How to fix error [INS-06006]
If you get the following error:
[INS-06006] Passwordless SSH connectivity not set up between the following nodes
It may be a bug that appears when we have OpenSSH 8.0 installed on the servers. So we check what version we have with the following:
OpenSSH_8.0p1, OpenSSL 1.1.1c FIPS 28 May 2019
After confirming that this is the problem to fix it we run the following steps:
# Rename the original scp. mv /usr/bin/scp /usr/bin/scp.orig # Create a new file </usr/bin/scp>. vi /usr/bin/scp # Add the below line to the new created file </usr/bin/scp>. /usr/bin/scp.orig -T $* # Change the file permission. chmod 555 /usr/bin/scp After installation: mv /usr/bin/scp.orig /usr/bin/scp