How to manually set up SSH communication between Unix Servers for Oracle Grid Infrastructure and RAC

• Author
• Recent Posts

Stratos Matzouranis

The journey began in 2008 where I officially started working in the field of IT (IT). Starting the first semester of school I realized a special attraction towards databases and automation. I have been involved with databases such as Microsoft SQL Server / Oracle Database, data analysis and automations using the command line (CLI), Visual Basic for Applications and Python. Through years of experience I have developed these capabilities so that I can make my life easier. For me, the purpose of every IT guy and every office worker is to have the knowledge so that through tools he can work a little but produce a lot. Through this his website DataPlatform.gr I try to offer knowledge and propose solutions to everyday problems.

Certifications:

Latest posts by Stratos Matzouranis (see all)

• How do we collect the actual execution plan from queries using Extended Event and how do we read its data - 2 December 2024
• How do we find what permissions a user has on an Oracle database - 1 November 2024
• How we enable Unified Auditing in Oracle Database - 7 October 2024

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:

ssh -V 

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