Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • CPU speed on Linux Linux/Unix
  • Changing Instance Name ( No DB_NAME) Oracle
  • find_longsql.sql Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • Good Link from metalink 1 Oracle
  • Composite Index creation tip from Vivek Oracle
  • Rownum with Order by Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • shr1.sql for MTS or Shared server configuration Oracle
  • Logic to chech # of parameters command line parameters Linux/Unix
  • My Minimum Tuning Programs Oracle
  • Find_planinfo.sql Oracle
  • Drop tempfiles from database Oracle
  • Removing first line Linux/Unix

Configure ssh authentications for RAC

Posted on 04-Jan-2009 By Admin No Comments on Configure ssh authentications for RAC

Applies to:

Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.1.0.6

Information in this document applies to any platform.

Reviewed 22-Oct-2008

Goal

This document will explain how to configure SSH, which is required to run a RAC installation. Following the instructions in the installation guide are also correct, but sometimes this will not work, although the reason for that isn’t clear. Therefore after some investigation it seems to be that the steps below will work too.

Solution

To configure SSH you need to perform the following steps on each node in the cluster.

$ cd $HOME

$ mkdir .ssh

$ chmod 700 .ssh

$ cd .ssh

$ ssh-keygen -t rsa

Now accept the default location for the key file

Enter and confirm a passphrase. (you can also press enter twice).

$ ssh-keygen -t dsa

Now accept the default location for the key file

Enter and confirm a passphrase. (you can also press enter twice).

$ cat *.pub > authorized_keys. (nodeX could be the nodename to differentiate files later)

Now do the same steps on the other nodes in the cluster.

When all those steps are done on the other nodes, start to copy the authorized_keys. to all the nodes into $HOME/.ssh/

For example if you have 4 nodes you will have after the copy in the .ssh 4 files with the name authorized_keys.

Then on EACH node continue the configuration of SSH by doing the following:

$ cd $HOME/.ssh

$ cat *.node* > authorized_keys

$ chmod 600 authorized_keys

To test that everything is working correct now execute the commands

$ ssh date

So on example in a 4 node environment:

$ ssh node1 date

$ ssh node2 date

$ ssh node3 date

$ ssh node4 date

Repeat this 4 times on each node, including the node itself. The nodeX is the hostname of the node.

The first time you will be asked to add the node to a file called ‘known_hosts’ this is correct and answer the question with ‘yes’. After that when correctly configured you must be able to get the date returned and you will not be prompted for a password.

Note: the above will work if during RSA and DSA configuration no password was provided. If you provide a password then you need to do 2 addition steps.

$ exec /usr/bin/ssh-agent $SHELL

$ /usr/bin/ssh-add

These statements will inform the ssh agent to add the keys to the shell used. So when a new shell is started you need to repeat the last to statements to make sure ssh is working properly.

ssh will not allow passwordless access if permissions on the home directory of the account you are using allow write access for everyone.

You will also see permission denied error when the permissions on $HOME are 777 or 775.

Disable banner (/etc/banner) on all cluster nodes when you

* run clusterverify (cluvfy, runcluvfy)

* install software

* patch the system

Oracle, RAC

Post navigation

Previous Post: 339939.1 Running Cluster Verification Utility to Diagnose Install Problems
Next Post: 10g RAC: Troubleshooting CRS Root.sh Problems

Related Posts

  • tab.sql Oracle
  • Good Oracle Architecture In Short and point to point Oracle
  • create database link syntax Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Drop tempfiles from database Oracle
  • export import with parameter file. Oracle
  • Good notes for shared pool Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix
  • Search and replace pattern Linux/Unix
  • DBA_HIST_SQLSTAT contents Oracle
  • To see how much time or progress of long transaction Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme